首页
关于
搜索
1
微信【限制新设备登录功能】解决办法
939 阅读
2
使用Mem Reduct定时清理内存
451 阅读
3
TP6+Workerman实现聊天室功能
374 阅读
4
PlanetScale 线上免费的数据库
231 阅读
5
PHPExcel快速生成字母表
197 阅读
默认分类
搜索
标签搜索
PHP
Windows 软件
GO
TrafficMonitor
网速悬浮窗
Mem Reduct
内存
PHPExcel
PlanetScale
ZipArchive
One Note插件
Redis
FRP
内网穿透
Philip
累计撰写
20
篇文章
累计收到
1
条评论
首页
栏目
默认分类
页面
关于
搜索到
4
篇与
的结果
2022-12-13
Redis 键(key) PHP用法
Redis keys 命令下表给出了与 Redis 键相关的基本命令:命令描述DEL key该命令用于在 key 存在是删除 keyDUMP key序列化给定 key ,并返回被序列化的值EXISTS key检查给定 key 是否存在EXPIRE key seconds为给定 key 设置过期时间EXPIREAT key timestampEXPIREAT 的作用和 EXPIRE 类似,都用于为 key 设置过期时间。 不同在于 EXPIREAT 命令接受的时间参数是 UNIX 时间戳(unix timestamp)PEXPIRE key milliseconds设置 key 的过期时间亿以毫秒计PEXPIREAT key milliseconds-timestamp设置 key 过期时间的时间戳(unix timestamp) 以毫秒计KEYS pattern查找所有符合给定模式( pattern)的 keyMOVE key db将当前数据库的 key 移动到给定的数据库 db 当中PERSIST key移除 key 的过期时间,key 将持久保持PTTL key以毫秒为单位返回 key 的剩余的过期时间TTL key以秒为单位,返回给定 key 的剩余生存时间(TTL, time to live)RANDOMKEY从当前数据库中随机返回一个 keyRENAME key newkey修改 key 的名称RENAMENX key newkey仅当 newkey 不存在时,将 key 改名为 newkeyTYPE key返回 key 所储存的值的类型{collapse}{collapse-item label="业务代码(PHP)" open}class RedisKeyDemo{ public $redis; // redis实例 public $type_list = ['Not Found', 'String', 'Set', 'List', 'Zset', 'Hash', 'Stream']; // 数据类型 public function __construct(){ $this->redis = new Redis(); } /** * 链接 Redis * @param string $host * @param int $port * @return bool */ public function connect(string $host = '127.0.0.1', int $port = 6379): bool{ return $this->redis->connect($host, $port); } /** * 打印到html * @param $str */ public function printToHtml(string $str = ''): void{ echo $str."<br>"; } /** * 打印所有keys */ public function printAllKeys(): void{ $this->keys(); } /** * 判断键是否存在 * @param string $key * @return bool|int */ public function isExists(string $key = ''): void{ $this->redis->exists($key) ? $this->printToHtml("$key is exists") : $this->printToHtml("$key is not exists"); } /** * 返回键类型 * @param string $type */ public function keyType(string $key = ''): void{ $this->printToHtml($this->type_list[$this->redis->type($key)]); } /** * 删除指定键 * 原本方法可以 key1,key2···, 接受string或array * @param string $key */ public function delKey(string $key = ''): void{ $this->printToHtml($this->redis->del($key) ? "'$key'删除成功" : "'$key'删除失败"); } /** * 为指定键设置过期时间 * @param string $key * @param int $ttl 过期时间 * @param string $type second 使用秒, timestamp 使用时间戳, milliseconds 使用时间亿以毫秒计 */ public function expiredKey(string $key = '', int $ttl, string $type = 'second'): void{ $error = "设置过期时间失败"; if ($ttl > 0){ switch ($type){ case 'second': $this->printToHtml($this->redis->expire($key, $ttl) ? "$key 将在 $ttl s 后删除" : $error);break; case 'timestamp': $this->printToHtml($this->redis->expireAt($key, $ttl) ? "$key 将在 ".date('Y-m-d H:i:s', $ttl)." 删除": $error);break; case 'milliseconds': $this->printToHtml($this->redis->pExpire($key, $ttl) ? "$key 将在 $ttl 亿以毫秒后删除" : $error);break; default: $this->printToHtml('$type: second 使用秒, timestamp 使用时间戳, milliseconds 使用时间亿以毫秒计'); } } else { $this->printToHtml($error); } } /** * 查找符合给定模式的key * 例如 查找te开头的所有key: te* ; 查找包含a的key: *a* ; 获取所有key: * * @param string $pattern */ public function keys(string $pattern = '*'): void{ $this->printToHtml(json_encode($this->redis->keys($pattern))); } /** * 将当前数据库的 key 移动到给定的数据库 db 当中 * @param string $key * @param int $db * @return bool */ public function move(string $key = '', int $db = 0): bool{ return $this->redis->move($key, $db); } /** * 移除 key 的过期时间,key 将持久保持。 * @param string $key * @return bool */ public function persist(string $key): bool{ return $this->redis->persist($key); } /** * 返回key的剩余过期时间 * @param string $key * @param string $type ttl以秒为单位, pttl以毫秒为单位 */ public function ttl(string $key, string $type = 'ttl'): void{ $error_flag = [ -1 => '没有设置过期时间', -2 => '不存在的key', false => '不存在的key' ]; switch ($type){ case 'ttl': $temp = $this->redis->ttl($key); $this->printToHtml($error_flag[$temp] ?? "剩余 $temp 秒");break; case 'pttl': $temp = $this->redis->pttl($key); $this->printToHtml($error_flag[$temp] ?? "剩余 $temp 毫秒");break; default: $this->printToHtml('$type ttl以秒为单位, pttl以毫秒为单位'); } } /** * 从数据库中随机返回一个key */ public function randomKey(){ $this->printToHtml("Random Key: ".$this->redis->randomKey()); } /** * 修改 key 的名称 * @param string $key * @param string $new_name * @param bool $strict == true时, 仅当 new_name 不存在时,将 key 改名为 new_name */ public function rename(string $key = '', string $new_name = '', bool $strict = false): void{ $flag = !$strict ? $this->redis->rename($key, $new_name) : $this->redis->renameNx($key, $new_name); $this->printToHtml($flag ? "重命名 $key->$new_name" : '重命名失败'); } }{/collapse-item}{collapse-item label="调用示例"}$demo = new RedisKeyDemo(); $demo->connect(); // 判断指定键是否存在 $demo->isExists('cao'); // 判断指定键类型 $demo->keyType('redis_yes'); $demo->keyType('myname'); // 删除键 //$demo->delKey('myname'); $demo->printAllKeys(); // 为key设置过期时间 $demo->expiredKey('test', time()+9999, 'timestamp'); // 使用时间戳 // 查找'te'开头的所有key $demo->keys('te*'); // 查看key的过期时间 $demo->ttl('test'); $demo->ttl('philip', 'pttl'); $demo->ttl('hstab'); // 移除过期时间 $demo->printToHtml('test 移除过期时间'. ($demo->persist('test') ? '成功' : '失败')); // 从数据库中随机获取一个key $demo->randomKey(); // 重命名key $demo->redis->set('test2', 5555); $demo->rename('test2', 'testt'); $demo->rename('testt', 'hstab', true); // 仅当new_name不存在时改名{/collapse-item}{/collapse}
2022年12月13日
123 阅读
0 评论
0 点赞
2022-10-23
php下载文件到指定目录,并打包
前几天有这么个需求,以后可能也用的上,先保存下来。下载文件到指定目录/** * 下载文件到指定目录 * @param $file_url 请求下载的链接 * @param $path 保存位置 * @param string $save_name 文件名,留空使用下载来的文件名 * @return string 返回下载的文件路径 */ public function downloadFile($file_url, $path, $save_name = ''){ $basePath = DIR_ROOT."upfile/"; if($path){ $basePath .= $path."/"; } $dir_path = $basePath; if (!is_dir($dir_path)) { mkdir($dir_path, 0777, true); } $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $file_url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30); $file = curl_exec($ch); curl_close($ch); //传入保存文件的名称 $filename = $save_name ?: pathinfo($file_url, PATHINFO_BASENAME); $resource = fopen($dir_path. '/'. $filename, 'a'); fwrite($resource, $file); fclose($resource); return $basePath . '/' . $filename; }打包文件/** * 打包文件 * @param $path 需要打包的路径 * @param $zip ZipArchive对象 * @param string $child_path 递归子文件夹用的 */ public function addFileToZip($path, &$zip, $child_path = ''){ $handler = opendir($path); //打开当前文件夹由$path指定。 while(($filename=readdir($handler)) !== false){ if($filename != "." && $filename != ".."){ //文件夹文件名字为'.'和‘..',不要对他们进行操作 if(is_dir($path."/".$filename)){ // 如果读取的某个对象是文件夹,则递归 $zip->addEmptyDir($filename); // 这里注意:php只需传递一个文件夹名称路径即可 $this->addFileToZip($path . "/" . $filename, $zip, $filename); }else{ //将文件加入zip对象 if (!empty($child_path)){ $zip->addFile($path."/".$filename, $child_path."/".$filename); } else{ $zip->addFile($path."/".$filename, $filename); } } } } @closedir($path); }{alert type="warning"}注意调用上面的打包方法时,需要先实例化ZipArchive对象,上示例:{/alert}// 下载到服务器后将文件夹打包为zip $outName = $this->datasheetBase->FormatJobCode($job_code_id).'.zip'; // 压缩包名称 $zipPath = DIR_ROOT."upfile/output/$outName"; // 导出的路径 if (file_exists($zipPath)) @unlink($zipPath); // 清理旧文件 $zip = new ZipArchive(); $data_file = DIR_ROOT."upfile/zip/".$this->customer->getID(); // 需要打包的路径 if ($zip->open($zipPath, ZipArchive::CREATE) === TRUE){ if (!is_dir($data_file)) mkdir($data_file); $this->datasheetBase->addFileToZip($data_file, $zip); } $zip->close();打包完成后,清理缓存文件。因为rmdir方法不能删除有文件的文件夹,所以需要先删除改文件夹的文件,再清理文件夹。上代码:/** * 清理文件 * @param $path */ public function clearFile($path){ $handler = opendir($path); while (($filename=readdir($handler)) !== false){ if($filename != "." && $filename != ".."){ //文件夹文件名字为'.'和‘..',不要对他们进行操作 if(is_dir($path."/".$filename)){ // 删除文件夹底下的文件 $this->clearFile($path . "/" . $filename); }else{ @unlink("$path/$filename"); } } } @closedir($path); $this->removeDIR($path); } /** * 将缓存文件夹删除 * @param $path */ private function removeDIR($path){ $handler = opendir($path); while (($filename=readdir($handler)) !== false){ if($filename != "." && $filename != ".."){ //文件夹文件名字为'.'和‘..',不要对他们进行操作 if(is_dir($path."/".$filename)){ @rmdir($path . "/" . $filename); // 删除文件夹 } } } @closedir($path); }最后重定向到打包好的文件就行header("Cache-Control: public"); header("Content-Description: File Transfer"); header('Content-disposition: attachment; filename='.$outName); // 文件名 header("Content-Type: application/zip"); header("Content-Transfer-Encoding: binary"); header('Content-Length: '. filesize($zipPath)); // 文件大小 header("Location:".HTTPS_SERVER."upfile/output/$outName");
2022年10月23日
84 阅读
0 评论
0 点赞
2022-05-27
PHP短开标签
从PHP5.4开始支持短开标签假设已有变量 $str = 'Hello';使用正常方式输出:<?php echo $str; ?>使用短开标签方式输出<?= $str; ?>短开标签<?= 是echo的快捷用法
2022年05月27日
118 阅读
0 评论
0 点赞
2022-05-26
PHPExcel快速生成字母表
用于在字段很多的情况下自动生成列标识, 代码如下$count = 26 * 27; $l = 'A'; $arr = []; while ($count--){ $arr[] = $l; $l++; }这样$arr里面就是excel的列字母表了, 具体数据如下, 怎么用看业务需求吧:["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW","AX","AY","A Z","BA","BB","BC","BD","BE","BF","BG","BH","BI","BJ","BK","BL","BM","BN","BO","BP","BQ","BR","BS","BT","BU","BV","BW","BX","BY","BZ","CA","CB","CC","CD","CE","CF","CG","CH","CI","CJ","CK","CL","CM","CN","CO","CP","CQ","CR","CS","CT" ,"CU","CV","CW","CX","CY","CZ","DA","DB","DC","DD","DE","DF","DG","DH","DI","DJ","DK","DL","DM","DN","DO","DP","DQ","DR","DS","DT","DU","DV","DW","DX","DY","DZ","EA","EB","EC","ED","EE","EF","EG","EH","EI","EJ","EK","EL","EM","EN"," EO","EP","EQ","ER","ES","ET","EU","EV","EW","EX","EY","EZ","FA","FB","FC","FD","FE","FF","FG","FH","FI","FJ","FK","FL","FM","FN","FO","FP","FQ","FR","FS","FT","FU","FV","FW","FX","FY","FZ","GA","GB","GC","GD","GE","GF","GG","GH","GI ","GJ","GK","GL","GM","GN","GO","GP","GQ","GR","GS","GT","GU","GV","GW","GX","GY","GZ","HA","HB","HC","HD","HE","HF","HG","HH","HI","HJ","HK","HL","HM","HN","HO","HP","HQ","HR","HS","HT","HU","HV","HW","HX","HY","HZ","IA","IB","IC", "ID","IE","IF","IG","IH","II","IJ","IK","IL","IM","IN","IO","IP","IQ","IR","IS","IT","IU","IV","IW","IX","IY","IZ","JA","JB","JC","JD","JE","JF","JG","JH","JI","JJ","JK","JL","JM","JN","JO","JP","JQ","JR","JS","JT","JU","JV","JW","J X","JY","JZ","KA","KB","KC","KD","KE","KF","KG","KH","KI","KJ","KK","KL","KM","KN","KO","KP","KQ","KR","KS","KT","KU","KV","KW","KX","KY","KZ","LA","LB","LC","LD","LE","LF","LG","LH","LI","LJ","LK","LL","LM","LN","LO","LP","LQ","LR" ,"LS","LT","LU","LV","LW","LX","LY","LZ","MA","MB","MC","MD","ME","MF","MG","MH","MI","MJ","MK","ML","MM","MN","MO","MP","MQ","MR","MS","MT","MU","MV","MW","MX","MY","MZ","NA","NB","NC","ND","NE","NF","NG","NH","NI","NJ","NK","NL"," NM","NN","NO","NP","NQ","NR","NS","NT","NU","NV","NW","NX","NY","NZ","OA","OB","OC","OD","OE","OF","OG","OH","OI","OJ","OK","OL","OM","ON","OO","OP","OQ","OR","OS","OT","OU","OV","OW","OX","OY","OZ","PA","PB","PC","PD","PE","PF","PG ","PH","PI","PJ","PK","PL","PM","PN","PO","PP","PQ","PR","PS","PT","PU","PV","PW","PX","PY","PZ","QA","QB","QC","QD","QE","QF","QG","QH","QI","QJ","QK","QL","QM","QN","QO","QP","QQ","QR","QS","QT","QU","QV","QW","QX","QY","QZ","RA", "RB","RC","RD","RE","RF","RG","RH","RI","RJ","RK","RL","RM","RN","RO","RP","RQ","RR","RS","RT","RU","RV","RW","RX","RY","RZ","SA","SB","SC","SD","SE","SF","SG","SH","SI","SJ","SK","SL","SM","SN","SO","SP","SQ","SR","SS","ST","SU","S V","SW","SX","SY","SZ","TA","TB","TC","TD","TE","TF","TG","TH","TI","TJ","TK","TL","TM","TN","TO","TP","TQ","TR","TS","TT","TU","TV","TW","TX","TY","TZ","UA","UB","UC","UD","UE","UF","UG","UH","UI","UJ","UK","UL","UM","UN","UO","UP" ,"UQ","UR","US","UT","UU","UV","UW","UX","UY","UZ","VA","VB","VC","VD","VE","VF","VG","VH","VI","VJ","VK","VL","VM","VN","VO","VP","VQ","VR","VS","VT","VU","VV","VW","VX","VY","VZ","WA","WB","WC","WD","WE","WF","WG","WH","WI","WJ"," WK","WL","WM","WN","WO","WP","WQ","WR","WS","WT","WU","WV","WW","WX","WY","WZ","XA","XB","XC","XD","XE","XF","XG","XH","XI","XJ","XK","XL","XM","XN","XO","XP","XQ","XR","XS","XT","XU","XV","XW","XX","XY","XZ","YA","YB","YC","YD","YE ","YF","YG","YH","YI","YJ","YK","YL","YM","YN","YO","YP","YQ","YR","YS","YT","YU","YV","YW","YX","YY","YZ","ZA","ZB","ZC","ZD","ZE","ZF","ZG","ZH","ZI","ZJ","ZK","ZL","ZM","ZN","ZO","ZP","ZQ","ZR","ZS","ZT","ZU","ZV","ZW","ZX","ZY", "ZZ"]
2022年05月26日
197 阅读
0 评论
0 点赞