Ejemplo n.º 1
0
 public function selectCount($table, $where)
 {
     $sql = SqlBuilder::buildSelectCountSql($table, $where);
     $stmt = $this->_dao->prepare($sql);
     $params = $this->buildParams($where);
     $this->bindParams($stmt, $params);
     if ($stmt->execute()) {
         $result = $stmt->get_result();
         if ($result) {
             return $result->fetch_assoc()['total'];
         }
     }
     return false;
 }
Ejemplo n.º 2
0
 public function selectCount($table, $where = '')
 {
     $sql = SqlBuilder::buildSelectCountSql($table, $where);
     $params = null;
     if (is_array($where)) {
         $params = array_values($where);
     }
     $stmt = $this->_dao->prepare($sql);
     if ($stmt->execute($params)) {
         $result = $stmt->fetch();
         return $result['total'];
     }
     return false;
 }