PHP DBHelp::buildWhereの例

コード例 #1

ファイル: ScoreService.php プロジェクト: hexcode007/yfcms

 public function getSearchCount($where = array())
 {
     $white_list = array('productCatId', 'productCatId2');
     $where = DBHelp::getWhiteItem($where, $white_list);
     $condition = DBHelp::buildWhere($where);
     $sql = "select count(0) from {tbname} where {$condition} ";
     return $this->mScoreDetail->getSingle($sql, $where);
 }

コード例 #2

ファイル: PushDetailService.php プロジェクト: hexcode007/yfcms

 public function getSearchCount($push_id, $where)
 {
     $white_list = array();
     $where = DBHelp::getWhiteItem($where, $white_list);
     $condition = DBHelp::buildWhere($where);
     $sql = "select count(0) from {tbname} where pushId='{$push_id}' and {$condition} ";
     return $this->mPushDetail->getSingle($sql, $where);
 }