- 博客(11)
- 资源 (3)
- 收藏
- 关注
RSS订阅原创 mysql导出导入远程数据mysqldump
mysqldump -h hostname -P 3306 -u username -p database tables > /Users/yangyongjian/Downloads/file.sql;
2024-06-05 09:29:20
176
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
2786
原创 nginx禁止某个目录执行访问php，防止脚本攻击
location ~* ^/Public/(Uploads|2021-05-21)/.*\.(php|php5|asp|jsp|js)?$ { deny all; }
2022-01-13 11:44:15
1128
原创 遍历读取目录文件并排序
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
216
原创 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
119
原创 linux配置数据库sh备份脚本以及nginx日志管理
#!/bin/bash host='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
171
原创 nginx重写向访问url
#nginx访问变改转发 location /api/ { rewrite /api/(.*) /web/index.php?r=$1 break; proxy_pass http://www.demo.cn; } #匹配请求url有某个值时返回404 if ($request_uri ~* "lists") { return 404; } #正则匹配url参数并转发代理 location = /web/store.php { if ($request_...
2020-09-17 15:02:28
291
原创 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
290
转载 Yii2 MySql读写分离主从配置及测试样例
这边只关注测试使用，关于主从配置或更多服务器相关的请自行充电废话不多说了，源码样例如下基于Yii2 basic 应用模板 配置篇 //config/db.php return [ 'class' => 'yii\db\Connection', 'serverRetryInterval' => 10,//在[[主服务器]]和[[从服务器]]中列出的死服务器的重试...
2020-04-07 14:16:18
231
ci框架3.0 全中文chm手册
2017-03-14
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人