Esempi in PHP per core Db::getRow

Esempio n. 1

File: Model.php Progetto: saoyor/php-framework

 /**
  * 查询一行记录
  *
  * @param array $filter 过滤条件
  * @param array $fields 字段
  * @return array
  */
 public function getRow(array $filter = null, array $fields = array())
 {
     if ($fields) {
         $fields = '`' . implode('`,`', $fields) . '`';
     } else {
         $fields = '*';
     }
     $sql = "SELECT {$fields} FROM " . $this->db->table($this->tableName);
     if (!empty($filter)) {
         $sql .= " WHERE " . $this->parseFilter($filter);
     }
     $sql .= " LIMIT 1";
     return $this->db->getRow($sql);
 }