TP5小知識點錦集（長期更新） · 個人博客

? **SQL清空數據表，并重置主鍵為1** ~~~sql truncate table 表名 ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") **分頁查詢不丟失條件** ~~~php Db::name("table")->where("XXXX")->paginate(10,false,['query'=>request()->param()]); ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") **獲取最新插入的id** ~~~php $userId = Db::name('user')->getLastInsID(); ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") ~~~html Fastadmin后臺列表點擊刷新 ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") ~~~php $(".fa-refresh").trigger("click"); ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") **thinkphp tp5 模板引擎字符串截取函數省略顯示** ~~~php {$d['title']|mb_substr=0,10,'utf-8'} ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") **模版時間截轉換** ~~~php {$time|date='Y-m-d H:i:s',###} ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") **測試數據打印** ~~~php error_log(time().'顯示設置'.print_r(array(),true),3,dirname(__FILE__).'/error_log.php'); ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") **TP5 url鏈接(帶參數)的寫法** ~~~php window.location.href="{:url('Index/index')}>"+"/ID/"+ID; //這樣可以生成，但url模式改變則不能用 window.location.href="{:url('Index/index','ID=" + ID+ "')}" //解析不成功。 window.location.href="{:url('Index/detail',['id' => "+iD+"])}";//解析不成功 window.location.href='{:url("Index/detail")}?id='+ iD ;//解析成功 ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") **php 正則替換圖片url內容（這里是將URL路徑改寫了）** ~~~php $suffix="http://q8adminx.keai8l.com"; $pregRule = "/<[img|IMG].*?src=[\'|\"](.*?(?:[\.jpg|\.jpeg|\.png|\.gif|\.bmp]))[\'|\"].*?[\/]?>/"; $content = preg_replace($pregRule, '<img src="'.$suffix.'${1}" data-filename="filename"', $articleinfo['content']); $articleinfo['content']=$content; ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") **tp5 自定義命令腳本執行在寶塔** ~~~php cd /www/wwwroot/xw.njagdl.com/xw/ php think task_wxcatch_all_history ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") **一旦寶塔后臺顯示Inode占用比較大的時候刪除 /root/.anyproxy/cache 以及tp5的runtime里面的目錄** **TP5輸出HTML原樣輸出怎么處理？** ~~~php {$content|raw|htmlspecialchars_decode} ~~~ ![](data:image/gif;base64,R0lGODlhAQABAPABAP///wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw== "點擊并拖拽以移動") 點擊鏈接加入群聊【ThinkPHP56小功能】：[正在跳轉](https://jq.qq.com/?_wv=1027&k=Z0c641WP "正在跳轉")? ?