public function fetchFields($query) { $statement = $this->pdo->prepare($query); $statement->execute(); $fields = array(); for ($i = 0; $i < $statement->columnCount(); $i++) { $fields[$statement->getColumnMeta($i)['name']] = $statement->getColumnMeta($i); // echo $stmt->getColumnMeta($i)['name'], PHP_EOL; //php5.4适使用,之前的版本需拆成两句 } return $fields; }
/** * Performs sql sequence * * @param string $sql * @param mixed $inputs_parameters Simple input parameter or array of inputs * @return PDOStatement */ public function query($sql, $inputs_parameters = array()) { $this->connect(); if (!is_array($inputs_parameters)) { $inputs_parameters = array($inputs_parameters); } $query = $this->pdo->prepare($sql); $query->execute($inputs_parameters); return $query; }