/**
* 插入一条数据
* @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;
}
