- 博客(11)
- 资源 (3)
- 收藏
- 关注
原创 mysql导出导入远程数据mysqldump
mysqldump -h hostname -P 3306 -u username -p database tables > /Users/yangyongjian/Downloads/file.sql;
2024-06-05 09:29:20
94
2
原创 nginx配置ssl证书
listen 443 ssl http2; ssl_certificate /usr/local/nginx/conf/vhost/ssl/cn.crt; ssl_certificate_key /usr/local/nginx/conf/vhost/ssl/cn.key; ssl_protocols TLSv1 TLSv1.1 TLSv1.2; ssl_ciphers EECDH+CHACHA20:EECDH+AES128:RSA+AES128:EECDH+AES2...
2022-04-08 09:56:58
2614
原创 nginx禁止某个目录执行访问php,防止脚本攻击
location ~* ^/Public/(Uploads|2021-05-21)/.*\.(php|php5|asp|jsp|js)?$ { deny all;}
2022-01-13 11:44:15
1038
原创 遍历读取目录文件并排序
function read_all ($dir,$name=''){ if(!is_dir($dir)) return false; $handle = opendir($dir); $files = array(); if($handle){ while(($fl = readdir($handle)) !== false){ $temp = $dir.DIRECTORY_SEPARA.
2021-05-13 11:03:50
167
原创 php计算多个集合的笛卡尔积
$arr = [ [1, 2, 3], [1, 4], [2, 5],];$res = $arr[0];unset($arr[0]);foreach ($arr as $val){ $res1 = []; foreach($res as $s){ foreach($val as $v){ $res1[] = $s. $v; } $res = $res1; }}Arr..
2021-04-02 09:23:21
96
原创 linux配置数据库sh备份脚本以及nginx日志管理
#!/bin/bashhost='127.0.0.1'port='3306'name='root'passwd='root'logfile='/home/backer/backups/backup.log'backdir='/home/backer/backups/'echo $(date -d yesterday +"%Y%m%d %H:%M:%S") "start export "${1} >> ${logfile}mysqldump -h${host} -P${port}.
2020-11-02 16:58:56
139
原创 nginx重写向访问url
#nginx访问变改转发location /api/ { rewrite /api/(.*) /web/index.php?r=$1 break; proxy_pass http://www.demo.cn;}#匹配请求url有某个值时返回404if ($request_uri ~* "lists") { return 404;}#正则匹配url参数并转发代理location = /web/store.php { if ($request_...
2020-09-17 15:02:28
260
原创 array_multisort双重排序
$list = [ { "goods_id": "2137", "shop_id": "641", "store_id": "6", "stock": "10", "distances": 0, "shop_key": false, ...
2020-04-29 15:39:35
246
转载 Yii2 MySql读写分离主从配置及测试样例
这边只关注测试使用,关于主从配置或更多服务器相关的请自行充电废话不多说了,源码样例如下基于Yii2 basic 应用模板配置篇//config/db.php return [ 'class' => 'yii\db\Connection', 'serverRetryInterval' => 10,//在[[主服务器]]和[[从服务器]]中列出的死服务器的重试...
2020-04-07 14:16:18
196
ci框架3.0 全中文chm手册
2017-03-14
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人