thinkphp自用知识点整理

• 数据库操作where in的用法 和分页功能

$res=Db::name(\'drugs_new\')->where(array(\'id\'=>array(\'in\', $arr)))->paginate($req[\'row\'],false, [\'page\' => $req[\'page\']]);

• 伪静态 需要和入口目录同级

<IfModule mod_rewrite.c>Options +FollowSymlinks -MultiviewsRewriteEngine OnRewriteCond %{REQUEST_FILENAME} !-dRewriteCond %{REQUEST_FILENAME} !-fRewriteRule ^(.*)$ index.php?/$1 [QSA,PT,L]</IfModule>

• where的区间查询

where(array(\'counter_id\' => $req[\'counterid\'],\'drugs_id\'=>array(\'gt\',0),\'ishot\'=>1))