程序员开发日志

mysql根据经纬度计算距离并排序

SELECT , ROUND( 6378.138 2 ASIN( SQRT(POW(SIN((36.666450 PI()/ 180-lat PI()/ 180 )/ 2 ),2)+ COS( 36.666450 PI()/ 180 ) COS( lat PI()/ 180 ) POW(SIN((117.076410 PI()/ 180-lng PI()/ 180)/ 2),2))) 1000) AS distance FROM agent ORDER BY distance ASC LIMIT 3

程序猿发布于 2022-9-13 11:52

评论(0) 浏览(1490)

微信小程序页面切换的几种方式

// 只能跳转到tabBar配置页面
wx.switchTab({
url: '/pages/index/index',
});

// 返回上一级页面（delta：返回的页面数，如果 delta 大于现有页面数，则返回到首页，默认值为1）
wx.navigateBack({
delta: 2 // 默认值是1
})

// 关闭当前页面，跳转到应用内的某个页面
wx.redirectTo({
url: '/pages/index/index',
});

// 保留当前页面，跳转到应用内的某个页面
wx.navigateTo({
url: '/pages/index/index',
});

// 关闭所有页面，打开到应用内的某个页面
wx.reLaunch({
url: '/pages/index/index',
})

程序猿发布于 2022-8-3 14:26

评论(0) 浏览(1949)

mysql插入先判断是否存在若没有则插入若有则更新

INSERT INTO history(staid, stype, sdate, svalue) VALUES( '53357', 1, '2022-06-20 10:00:00', 0.1)
ON DUPLICATE KEY
UPDATE svalue = 0.3

来源：天气API tianqiapi.com

程序猿发布于 2022-6-17 01:31

评论(0) 浏览(2145)

PHP通过CURL伪装IP来源

请求这个url打开输出自己的ip, 用PHP提交后, IP为 101.32.22.109
↓↓↓
$url = 'https://quan.xianguomall.com/gaode2.php';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('CLIENT-IP: 101.32.22.109','X-FORWARDED-FOR: 101.32.22.109'));
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 30);
// 模拟来源
curl_setopt($ch, CURLOPT_REFERER, '');
$response = curl_exec($ch);
if($error=curl_error($ch)){
die($error);
}
curl_close($ch);
echo $response;

程序猿发布于 2022-6-16 05:46

评论(0) 浏览(2151)

nginx伪静态demo

location /china {
rewrite ^/china.xml$ /index.php?c=xmlapi;
}
location /t/xml_city {
rewrite ^/t/xml_city/([a-zA-Z]+).xml$ /index.php?c=xmlapi&a=city&alias=$1;
}

location /news {
rewrite ^/news/(\d+)/(\d+)(|\/)$ /news/index.php?catid=$1&page=$2;
}
location /newsinfo {
rewrite ^/newsinfo/(\d+).html$ /news/info.php?id=$1;
}

程序猿发布于 2022-5-17 06:29

评论(0) 浏览(8967)

微信小程序优惠券领券核销源码领券核销平台

领券演示小程序 , 如需购买源码请联系微信: hype522147 电话：15562679693

微信公众号|小程序领券核销源码含全套代码, 包配置
最近更新：2022年7月25日
更新功能：

新增在线收款功能 ( 和收钱吧类似, 输入金额后在线支付 )
新增商品在线下单功能 (包含分类、购物车、下单、在线支付)
新增"在线收款"和"在线下单"消息推送提醒

操作流程非常简单

用户端:

券流程：扫码进入店铺小程序 > 点击领券 > 支付 > 出示二维码核销
在线收款：进入店铺主页或通过收款二维码直接进入, 点击 "在线付款" 输入金额后支付
在线下单：进入店铺主页或通过店铺二维码直接进入, 点击 "在线下单" 进入商城, 可以加入购物车, 确认订单, 支付订单, 付款后可在用户中心查看订单

管理端:
打开微信扫一扫扫描用户出示的二维码 > 核销成功
后台端:
创建优惠券、套餐券、订单查看、店员管理(扫码绑定)、结算提现、数据报表等等
BOSS端:
店铺审核、券管理、订单管理、结算管理、用户管理、流量统计等等

界面截图

小程序截图	小程序截图	小程序截图

程序猿发布于 2022-4-10 12:41

评论(0) 浏览(8600)

微信小程序返回上一页没有上一页的情况下返回首页

goback: function (e) {
        let pages = getCurrentPages();
        if (pages.length > 1) {
          wx.navigateBack({//返回
            delta: 1
          });
        }
        if (pages.length == 1) {
          wx.reLaunch({
            url: '/pages/index/index',
          })
        }
      },

程序猿发布于 2022-3-25 06:55

评论(0) 浏览(12109)

PHP 计算两个坐标之间距离

/**

计算两个坐标（经度，纬度）之间距离
/
public static function distance($lat1, $lng1, $lat2, $lng2, $miles = true)
{
$pi80 = M_PI / 180;
$lat1 = $pi80;
$lng1 = $pi80;
$lat2 = $pi80;
$lng2 = $pi80;
$r = 6372.797; // mean radius of Earth in km
$dlat = $lat2 - $lat1;
$dlng = $lng2 - $lng1;
$a = sin($dlat/2)sin($dlat/2)+cos($lat1)cos($lat2)sin($dlng/2)sin($dlng/2);
$c = 2 atan2(sqrt($a), sqrt(1 - $a));
$km = $r $c;
return ($miles ? ($km 0.621371192) : $km);
}

程序猿发布于 2022-2-11 08:40

评论(0) 浏览(11388)

2022年北京东奥会奖牌榜API接口

官网文档地址
https://yikeapi.com/index/olympic

请求方式
GET

接口地址：
http://apia.yikeapi.com/olympic/

请求示例 (appid和appsecret进入官网注册账号)
http://apia.yikeapi.com/olympic/?appid=&appsecret=

请求参数说明：
appid 用户appid
appsecret 用户appsecret
callback jsonp参数如: jQuery.Callbacks
vue 跨域参数如果您使用的是react、vue、angular请填写值: 1

返回JSON示例

   {
        "errcode":0,
        "errmsg":"success",
        "update_time":"2022-01-01 11:26:46",
        "list":[
            {
                "country":"中国", #国家名称
                "flag":"https://search-operate.cdn.bcebos.com/7dce3e5758a82e720ec1c7123d246616.png", #国旗图片CDN
                "jin":1, #金牌
                "yin":0, #银牌
                "tong":0, #铜牌
                "total":1 #总数
            },
            {
                "country":"美国",
                "flag":"https://search-operate.cdn.bcebos.com/8c00d69be531ba4b21d5100d2a13fb8b.png",
                "jin":0,
                "yin":1,
                "tong":0,
                "total":1
            },
            {
                "country":"澳大利亚",
                "flag":"https://search-operate.cdn.bcebos.com/be6980d6afd68c698d92dd85b00ac35e.png",
                "jin":0,
                "yin":0,
                "tong":1,
                "total":1
            }
        ]
    }

程序猿发布于 2022-2-3 02:12

评论(0) 浏览(849)

12306列车查询API接口对接高铁动车查询接口文档

该接口提供全国火车票车次查询, 站到站查询接口。
比如您查询"济南"到"北京", 接口会返回所有济南到北京的列车, 慢车、动车、高铁都会有, 但是不会出现票价, 适合做出行规划。

请求方式：GET

接口地址：
http://apia.yikeapi.com/train/

请求示例
http://apia.yikeapi.com/train/?start_station=烟台&stop_station=青岛&appid=43656176&appsecret=I42og6Lm

请求参数说明：

参数名	必选	类型	说明	备注（示例）
appid	是	string	用户appid	注册开发者账号
appsecret	是	string	用户appsecret
start_station	是	string	出发站	示例: 烟台
stop_station	是	string	终点站	示例: 青岛

响应JSON

{
    "errcode":0,
    "errmsg":"success",
    "api":"yikeapi.com",
    "usetime":0.10343503952026367,
    "list":[
        {
            "train_id":"16019",//列车编号,根据此编号查询列车详情
            "station_train_code":"C6520",//列车名称
            "train_from_station":"烟台",//列车始发站
            "train_to_station":"青岛",//列车终点站
            "from_station":"烟台",//出发站
            "to_station":"青岛",//到达站
            "start_time_unix":1642544460,
            "start_time":"06:21",//出发时间
            "stop_time":"08:12",//到达时间
            "day_diff":0//是否跨日, 0:否 1是
        },
        {
            "train_id":"9861",
            "station_train_code":"D2926",
            "train_from_station":"荣成",
            "train_to_station":"上海虹桥",
            "from_station":"烟台南",
            "to_station":"青岛西",
            "start_time_unix":1642546560,
            "start_time":"06:56",
            "stop_time":"08:53",
            "day_diff":0
        },
        {
            "train_id":"8173",
            "station_train_code":"D2138",
            "train_from_station":"烟台",
            "train_to_station":"上海虹桥",
            "from_station":"烟台",
            "to_station":"青岛西",
            "start_time_unix":1642548840,
            "start_time":"07:34",
            "stop_time":"09:41",
            "day_diff":0
        },
        {
            "train_id":"21837",
            "station_train_code":"C6552",
            "train_from_station":"荣成",
            "train_to_station":"青岛北",
            "from_station":"烟台南",
            "to_station":"青岛北",
            "start_time_unix":1642549080,
            "start_time":"07:38",
            "stop_time":"08:40",
            "day_diff":0
        },
        {
            "train_id":"3346",
            "station_train_code":"G5588",
            "train_from_station":"威海",
            "train_to_station":"曲阜东",
            "from_station":"烟台南",
            "to_station":"青岛北",
            "start_time_unix":1642551960,
            "start_time":"08:26",
            "stop_time":"09:44",
            "day_diff":0
        },
        {
            "train_id":"4535",
            "station_train_code":"G1850",
            "train_from_station":"烟台",
            "train_to_station":"长沙南",
            "from_station":"烟台",
            "to_station":"青岛西",
            "start_time_unix":1642556640,
            "start_time":"09:44",
            "stop_time":"11:35",
            "day_diff":0
        },
        {
            "train_id":"4880",
            "station_train_code":"G2684",
            "train_from_station":"威海",
            "train_to_station":"兰州西",
            "from_station":"烟台南",
            "to_station":"青岛西",
            "start_time_unix":1642558560,
            "start_time":"10:16",
            "stop_time":"11:57",
            "day_diff":0
        },
        {
            "train_id":"20773",
            "station_train_code":"C6546",
            "train_from_station":"烟台",
            "train_to_station":"青岛北",
            "from_station":"烟台",
            "to_station":"青岛北",
            "start_time_unix":1642558560,
            "start_time":"10:16",
            "stop_time":"11:23",
            "day_diff":0
        },
        {
            "train_id":"8746",
            "station_train_code":"D6050",
            "train_from_station":"烟台",
            "train_to_station":"青岛北",
            "from_station":"烟台",
            "to_station":"青岛北",
            "start_time_unix":1642559520,
            "start_time":"10:32",
            "stop_time":"11:40",
            "day_diff":0
        },
        {
            "train_id":"21440",
            "station_train_code":"C6508",
            "train_from_station":"荣成",
            "train_to_station":"青岛",
            "from_station":"烟台南",
            "to_station":"青岛",
            "start_time_unix":1642571760,
            "start_time":"13:56",
            "stop_time":"15:40",
            "day_diff":0
        },
        {
            "train_id":"20506",
            "station_train_code":"C6544",
            "train_from_station":"威海",
            "train_to_station":"青岛",
            "from_station":"烟台南",
            "to_station":"青岛",
            "start_time_unix":1642573680,
            "start_time":"14:28",
            "stop_time":"15:50",
            "day_diff":0
        },
        {
            "train_id":"8744",
            "station_train_code":"D6046",
            "train_from_station":"烟台",
            "train_to_station":"青岛",
            "from_station":"烟台",
            "to_station":"青岛",
            "start_time_unix":1642573980,
            "start_time":"14:33",
            "stop_time":"16:29",
            "day_diff":0
        },
        {
            "train_id":"3344",
            "station_train_code":"G5584",
            "train_from_station":"威海",
            "train_to_station":"曲阜东",
            "from_station":"烟台南",
            "to_station":"青岛西",
            "start_time_unix":1642575600,
            "start_time":"15:00",
            "stop_time":"16:39",
            "day_diff":0
        },
        {
            "train_id":"9863",
            "station_train_code":"D2930",
            "train_from_station":"威海",
            "train_to_station":"上海虹桥",
            "from_station":"烟台南",
            "to_station":"青岛西",
            "start_time_unix":1642577340,
            "start_time":"15:29",
            "stop_time":"17:06",
            "day_diff":0
        },
        {
            "train_id":"3348",
            "station_train_code":"G5592",
            "train_from_station":"烟台",
            "train_to_station":"菏泽东",
            "from_station":"烟台",
            "to_station":"青岛西",
            "start_time_unix":1642577760,
            "start_time":"15:36",
            "stop_time":"17:18",
            "day_diff":0
        },
        {
            "train_id":"21438",
            "station_train_code":"C6504",
            "train_from_station":"荣成",
            "train_to_station":"青岛",
            "from_station":"烟台南",
            "to_station":"青岛",
            "start_time_unix":1642585080,
            "start_time":"17:38",
            "stop_time":"19:17",
            "day_diff":0
        },
        {
            "train_id":"23007",
            "station_train_code":"C6582",
            "train_from_station":"威海",
            "train_to_station":"青岛北",
            "from_station":"烟台南",
            "to_station":"青岛北",
            "start_time_unix":1642586160,
            "start_time":"17:56",
            "stop_time":"18:58",
            "day_diff":0
        },
        {
            "train_id":"23009",
            "station_train_code":"C6588",
            "train_from_station":"威海",
            "train_to_station":"青岛",
            "from_station":"烟台南",
            "to_station":"青岛",
            "start_time_unix":1642586940,
            "start_time":"18:09",
            "stop_time":"20:01",
            "day_diff":0
        },
        {
            "train_id":"8768",
            "station_train_code":"D6092",
            "train_from_station":"烟台",
            "train_to_station":"青岛北",
            "from_station":"烟台",
            "to_station":"青岛北",
            "start_time_unix":1642589280,
            "start_time":"18:48",
            "stop_time":"20:00",
            "day_diff":0
        },
        {
            "train_id":"22804",
            "station_train_code":"C6578",
            "train_from_station":"烟台",
            "train_to_station":"青岛北",
            "from_station":"烟台",
            "to_station":"青岛北",
            "start_time_unix":1642592040,
            "start_time":"19:34",
            "stop_time":"20:54",
            "day_diff":0
        },
        {
            "train_id":"23945",
            "station_train_code":"C662",
            "train_from_station":"龙口市",
            "train_to_station":"青岛",
            "from_station":"烟台",
            "to_station":"青岛",
            "start_time_unix":1642593240,
            "start_time":"19:54",
            "stop_time":"22:11",
            "day_diff":0
        }
    ]
}

程序猿发布于 2022-1-21 09:14

评论(0) 浏览(1581)