# thinkphp常用判斷語句 運算符： **eq\*\*\*\*相等** **ne、neq\*\*\*\*不相等** **gt\*\*\*\*大于** **lt\*\*\*\*小于** \*\*egt\*\*\*\*大于等于 \*\* **elt\*\*\*\*小于等于** **not\*\*\*\*非** **mod\*\*\*\*求模** 數據庫的加減： thinkphp中setInc、setDec方法 可用于統計字段（通常是數字類型的字段）的更新，例如積分，等級，登陸次數等 必須配合連貫操作where一起使用 ``` <pre class="calibre13">``` <span class="token5">1</span> $User <span class="token">=</span> <span class="token5">M</span><span class="token1">(</span><span class="token4">"User"</span><span class="token1">)</span><span class="token1">;</span> <span class="token6">// 實例化User對象</span> <span class="token5">2</span> $User<span class="token">-</span><span class="token">></span><span class="token3">where</span><span class="token1">(</span><span class="token4">'id=5'</span><span class="token1">)</span><span class="token">-</span><span class="token">></span><span class="token3">setInc</span><span class="token1">(</span><span class="token4">'score'</span><span class="token1">,</span><span class="token5">3</span><span class="token1">)</span><span class="token1">;</span> <span class="token6">// 用戶的積分加3</span> <span class="token5">3</span> $User<span class="token">-</span><span class="token">></span><span class="token3">where</span><span class="token1">(</span><span class="token4">'id=5'</span><span class="token1">)</span><span class="token">-</span><span class="token">></span><span class="token3">setInc</span><span class="token1">(</span><span class="token4">'score'</span><span class="token1">)</span><span class="token1">;</span> <span class="token6">// 用戶的積分加1</span> <span class="token5">4</span> $User<span class="token">-</span><span class="token">></span><span class="token3">where</span><span class="token1">(</span><span class="token4">'id=5'</span><span class="token1">)</span><span class="token">-</span><span class="token">></span><span class="token3">setDec</span><span class="token1">(</span><span class="token4">'score'</span><span class="token1">,</span><span class="token5">5</span><span class="token1">)</span><span class="token1">;</span> <span class="token6">// 用戶的積分減5</span> <span class="token5">5</span> $User<span class="token">-</span><span class="token">></span><span class="token3">where</span><span class="token1">(</span><span class="token4">'id=5'</span><span class="token1">)</span><span class="token">-</span><span class="token">></span><span class="token3">setDec</span><span class="token1">(</span><span class="token4">'score'</span><span class="token1">)</span><span class="token1">;</span> <span class="token6">// 用戶的積分減1</span> ``` ``` 添加數據后如果需要返回新增數據的自增主鍵，可以使用`getLastInsID`方法： ``` <pre class="calibre13">``` Db<span class="token1">:</span><span class="token1">:</span><span class="token3">name</span><span class="token1">(</span><span class="token4">'user'</span><span class="token1">)</span><span class="token">-</span><span class="token">></span><span class="token3">insert</span><span class="token1">(</span>$data<span class="token1">)</span><span class="token1">;</span> $userId <span class="token">=</span> Db<span class="token1">:</span><span class="token1">:</span><span class="token3">name</span><span class="token1">(</span><span class="token4">'user'</span><span class="token1">)</span><span class="token">-</span><span class="token">></span><span class="token3">getLastInsID</span><span class="token1">(</span><span class="token1">)</span><span class="token1">;</span> ``` ``` 或者直接使用`insertGetId`方法新增數據并返回主鍵值： ``` <pre class="calibre14">``` Db<span class="token1">:</span><span class="token1">:</span><span class="token3">name</span><span class="token1">(</span><span class="token4">'user'</span><span class="token1">)</span><span class="token">-</span><span class="token">></span><span class="token3">insertGetId</span><span class="token1">(</span>$data<span class="token1">)</span><span class="token1">;</span> ``` ```