這篇文章給大家介紹的內容是關於thinkphp如何?分組擷取滿足條件的資料,有一定的參考價值,有需要的朋友可以參考一下,希望對你有所協助。
thinkphp分組擷取滿足條件的資料:
<?php//分組擷取滿足條件的一畝地ID$cinema_id = $this->getCunIdById($change_num); //cun_use表(cun_id分組),擷取要換取的大於該cun_use剩餘的數量 private function getCunIdById($change_num){ $f="cu.cun_id,count(cu.id) as receive_num"; $c=" and cu.cun_id != 0 and cu.cun_id= 2 and cu.user_id = 0 and cu.use_status = 0"; $groupCunUse = $this->getExchageByCunId($c,$f); foreach ($groupCunUse as $gk => $gv) { if($gv['receive_num'] >= $change_num){ $cinema_id =$gv['cinema_id']; break; } } return $cinema_id; } //cun_use表(cun_id分組),擷取要換取的大於該cun_use剩餘的數量public function getExchageByCunId($condition,$field){if (!$condition) {return false;}else{return M('cun_use')->table('cun_use cu,cun_piao cp')->where(' cu.cun_id = cp.cun_id'.$condition)->field($field)->group('tu.cun_id')->select();}}
相關文章推薦:
什麼是php引用變數?PHP中引用是如何?
memcache(記憶體緩衝技術)對php頁面訪問的速度影響(圖文)