叶测试 - PHP
type: channel
link: https://r1989.com/tag/PHP/
items: 使用phpword读取word中的文本、表格等内容
items: PHP在PDF指定位置添加数字签名/图片
items: libpng warning: iccp: known incorrect sRGB profile
items: 关于秒杀系统的几点记录
items: NanoID - 轻量、安全的 Unique ID 生成器
items: wampserver升级phpMyAdmin版本
items: php国密sm4加解密
items: 利用DatePeriod 类获取两个日期之间的所有日期

使用phpword读取word中的文本、表格等内容
type: item
date: 2025-08-27T14:35:24+08:00
description: phpword读取word中的内容，调用deepseek后生成word下载，代码如下： <?php /** * Desc: * User: SenSen Wechat:1050575278 * Date: 2025-8-27 * Time: 11:02 */ namespace app\index\controller\service; use app\index\controller\Auth; use PhpOffice\PhpWord\IOFactory; use PhpOffice\PhpWord\PhpWord; use PhpOffice\PhpWord\SimpleType\Jc; use sensen\services\HttpService; use sensen\services\JsonService; use sensen\services\upload\Upload; class QiSuZhuang extends Auth { /** * 诉状上传 */ public function upload() { $upload_type = $this->request->get('upload_type', sys_config('upload_type', 1)); try { $path = make_path('qisuzhuang', 2, true); $upload = new Upload((int)$upload_type, [ 'accessKey' => sys_config('accessKey'), 'secretKey' => sys_config('secretKey'), 'uploadUrl' => sys_config('uploadUrl'), 'storageName' => sys_config('storage_name'), 'storageRegion' => sys_config('storage_region'), ]); //验证类型 $res = $upload->to($path)->validate(['fileExt'=>'doc,docx', 'fileMime'=>['application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'application/msword']])->move('file'); if ($res === false) { return JsonService::fail('上传失败：' . $upload->getError()); } else { $fileInfo = $upload->getUploadInfo(); if ($fileInfo) { $file = '.'.$fileInfo['dir']; $phpWord = IOFactory::load($file); $sections = $phpWord->getSections(); $szContent = ''; foreach ($sections as $section) { $elements = $section->getElements(); // 获取当前section的所有元素 foreach ($elements as $element) { if ($element instanceof \PhpOffice\PhpWord\Element\TextRun) { // 文本段落 foreach ($element->getElements() as $ele) { $szContent .= self::getTextNode($ele) . "\n"; } }else if ($element instanceof \PhpOffice\PhpWord\Element\Table) { foreach ($element->getRows() as $ele) { $szContent .= self::getTableNode($ele) . "\n"; } } } } $deepSeekContent = $this->getDeepSeekContent($szContent); debug_file($deepSeekContent, 'qisuzhuang'); $fileName = date('YmdHis'); $this->generateQszWord($deepSeekContent, $fileName); return JsonService::successful('上传成功', ['path'=>…

PHP在PDF指定位置添加数字签名/图片
type: item
date: 2024-11-01T11:08:00+08:00
description: 基本业务需求：按指定范本填充生成word文档，word转pdf后，在指定字符位置添加数字签名。难点：获取pdf需要插入数字签名的坐标使用到的第三方依赖：phpoffice/phpwordtecnickcom/tcpdfsetasign/fpdismalot/pdfparser[...]

libpng warning: iccp: known incorrect sRGB profile
type: item
date: 2024-10-24T10:54:00+08:00
description: libpng警告 iCCP: known incorrect sRGB profile 通常出现在处理PNG图像时，这个警告表明在PNG文件中存在一个已知的不正确的sRGB配置文件（iCCP）。原因分析图像编辑工具问题：一些图像编辑工具可能会错误地添加或修改sRGB配置文件，导致libpng无法正确识别。PNG规格要求：根据PNG规格，只有灰度图像可以有颜色类型为0或4的配置文件，而RGB图像只能有颜色类型为2、3或6的配置文件。如果不符合这些规则，就会出现警告。特定场景下的应用：例如，在使用pygame开发游戏时，调用PNG格式图片会触发此警告。[...]

关于秒杀系统的几点记录
type: item
date: 2024-06-13T17:20:00+08:00
description: 校验请求是否合法活动是否开始校验参数是否合法校验用户是否合法验证码等防止机器人校验用户是否重复购买校验库存库存需实时获取[...]

NanoID - 轻量、安全的 Unique ID 生成器
type: item
date: 2024-04-10T19:00:00+08:00
description: NanoID一个小巧、安全、URL友好、唯一的 JavaScript 字符串 ID 生成器。小巧：130 bytes (已压缩和 gzipped)， 没有依赖，Size Limit 控制大小；快速：它比 UUID 快 60%；安全：它使用加密的强随机 API，可在集群中使用；紧凑：它使用比 UUID（A-Za-z0-9_-）更大的字母表，因此，ID 大小从 36 个符号减少到 21 个符号；易用：Nano ID 已被移植到 20种编程语言。php版：https://github.com/hidehalo/nanoid-php[...]

wampserver升级phpMyAdmin版本
type: item
date: 2023-09-26T16:05:00+08:00
description: php8与phpMyAdmin5.0存在兼容性问题，需升级到最新版。1.下载最新版phpMyAdmin：https://www.phpmyadmin.net/ 并移动到wampserver安装目录下的apps目录；2.修改alias\phpmyadmin.conf文件中的路径为新版路径；3.复制或参考原phpMyAdmin目录下的config.inc.php到新版本目录；4.修改根目录下wampmanager.conf文件中对应的版本号；（无效）5.重启wamp

php国密sm4加解密
type: item
date: 2023-09-08T11:03:08+08:00
description: 国密算法sm4对应的php加解密代码<?php Class SM4Util { const SM4_CK = [ 0x00070e15, 0x1c232a31, 0x383f464d, 0x545b6269, 0x70777e85, 0x8c939aa1, 0xa8afb6bd, 0xc4cbd2d9, 0xe0e7eef5, 0xfc030a11, 0x181f262d, 0x343b4249, 0x50575e65, 0x6c737a81, 0x888f969d, 0xa4abb2b9, 0xc0c7ced5, 0xdce3eaf1, 0xf8ff060d, 0x141b2229, 0x30373e45, 0x4c535a61, 0x686f767d, 0x848b9299, 0xa0a7aeb5, 0xbcc3cad1, 0xd8dfe6ed, 0xf4fb0209, 0x10171e25, 0x2c333a41, 0x484f565d, 0x646b7279 ]; const SM4_Sbox = [ 0xd6, 0x90, 0xe9, 0xfe, 0xcc, 0xe1, 0x3d, 0xb7, 0x16, 0xb6, 0x14, 0xc2, 0x28, 0xfb, 0x2c, 0x05, 0x2b, 0x67, 0x9a, 0x76, 0x2a, 0xbe, 0x04, 0xc3, 0xaa, 0x44, 0x13, 0x26, 0x49, 0x86, 0x06, 0x99, 0x9c, 0x42, 0x50, 0xf4, 0x91, 0xef, 0x98, 0x7a, 0x33, 0x54, 0x0b, 0x43, 0xed, 0xcf, 0xac, 0x62, 0xe4, 0xb3, 0x1c, 0xa9, 0xc9, 0x08, 0xe8, 0x95, 0x80, 0xdf, 0x94, 0xfa, 0x75, 0x8f, 0x3f, 0xa6, 0x47, 0x07, 0xa7, 0xfc, 0xf3, 0x73, 0x17, 0xba, 0x83, 0x59, 0x3c, 0x19, 0xe6, 0x85, 0x4f, 0xa8, 0x68, 0x6b, 0x81, 0xb2, 0x71, 0x64, 0xda, 0x8b, 0xf8, 0xeb, 0x0f, 0x4b, 0x70, 0x56, 0x9d, 0x35, 0x1e, 0x24, 0x0e, 0x5e, 0x63, 0x58, 0xd1, 0xa2, 0x25, 0x22, 0x7c, 0x3b, 0x01, 0x21, 0x78, 0x87, 0xd4, 0x00, 0x46, 0x57, 0x9f, 0xd3, 0x27, 0x52, 0x4c, 0x36, 0x02, 0xe7, 0xa0, 0xc4, 0xc8, 0x9e, 0xea, 0xbf, 0x8a, 0xd2, 0x40, 0xc7, 0x38, 0xb5, 0xa3, 0xf7, 0xf2, 0xce, 0xf9, 0x61, 0x15, 0xa1, 0xe0, 0xae, 0x5d, 0xa4, 0x9b, 0x34, 0x1a, 0x55, 0xad, 0x93, 0x32, 0x30, 0xf5, 0x8c, 0xb1, 0xe3, 0x1d, 0xf6, 0xe2, 0x2e, 0x82, 0x66, 0xca, 0x60, 0xc0, 0x29, 0x23, 0xab, 0x0d, 0x53, 0x4e, 0x6f, 0xd5, 0xdb, 0x37, 0x45, 0xde, 0xfd, 0x8e, 0x2f, 0x03, 0xff, 0x6a, 0x72, 0x6d, 0x6c, 0x5b, 0x51, 0x8d, 0x1b, 0xaf, 0x92, 0xbb, 0xdd, 0xbc, 0x7f, 0x11, 0xd9, 0x5c, 0x41, 0x1f, 0x10, 0x5a, 0xd8, 0x0a, 0xc1, 0x31, 0x88, 0xa5, 0xcd, 0x7b, 0xbd, 0x2d, 0x74, 0xd0, 0x12, 0xb8, 0xe5, 0xb4, 0xb0, 0x89, 0x69, 0x97, 0x4a, 0x0c, 0x96, 0x77, 0x7e, 0x65, 0xb9, 0xf1, 0x09, 0xc5, 0x6e, 0xc6, 0x84, 0x18, 0xf0, 0x7d, 0xec, 0x3a, 0xdc, 0x4d, 0x20, 0x79, 0xee, 0x5f, 0x3e, 0xd7, 0xcb, 0x39, 0x48 ]; …

利用DatePeriod 类获取两个日期之间的所有日期
type: item
date: 2023-03-07T11:33:00+08:00
description: 官方文档：https://www.php.net/manual/zh/class.dateperiod.phpDatePeriod 类表示一个时间周期，时间周期内允许对一组日期和时间进行迭代，在指定的时间间隔内定期重复。注意：8.2 新增 DatePeriod::INCLUDE_END_DATE/** * 获取两个日期间的所有日期 * @param $startDate 2023-04-01 * @param $endDate 2023-04-19 * @param $format * @param $last 是否包含最后一天 * @return array * @throws Exception */ function getDateRange($startDate, $endDate, $format = "Y-m-d", $last=true, $first=true) { $begin = new DateTime($startDate); $end = new DateTime($endDate); if($last){ $end->modify('+1 day'); } $interval = new DateInterval('P1D'); // 1 Day $exclude = 0; if(!$first){ $exclude = DatePeriod::EXCLUDE_START_DATE; } $dateRange = new DatePeriod($begin, $interval, $end, $exclude); $range = []; foreach ($dateRange as $date) { $range[] = $date->format($format); } return $range; }