/** * 插入一条数据 * @param string $table 要插入的表命 * @param array $data 要插入的数据 * @return boolean|string 插入成功或者失败 */ public function insert($table, array $params) { $columns = ''; $values = ''; foreach ($params as $column => $value) { $columns .= $this->quoteObj($column) . ','; $values .= \is_null($value) ? "NULL," : $this->quote($value) . ','; } $columns = \substr($columns, 0, \strlen($columns) - 1); $values = \substr($values, 0, \strlen($values) - 1); $table = $this->quoteObj($table); $sql = "INSERT INTO {$table} ({$columns}) VALUES ({$values})"; $ret = $this->exec($sql, false); if ($ret === false) { return false; } $id = $this->connection->lastInsertId(); if (!empty($id)) { return $id; } return !!$ret; }