### insert
插入數據到表中
insert($table, $data)
* ##### table [string]
表名.
* ##### data [array]
插入到表里的數據.
Return: [number] 返回插入的id
~~~
$last_user_id = $database->insert("account", [
"user_name" => "foo",
"email" => "foo@bar.com",
"age" => 25
]);
~~~
#### 序列化數組
默認情況下,你要將數組插入會被序列化`serialize()`, 也可以使用 JSON `json_encode()`.
~~~
$last_user_id = $database->insert("account", [
"user_name" => "foo",
"email" => "foo@bar.com",
"age" => 25,
"lang" => ["en", "fr", "jp", "cn"] // => 'a:4:{i:0;s:2:"en";i:1;s:2:"fr";i:2;s:2:"jp";i:3;s:2:"cn";}'
]);
$last_user_id = $database->insert("account", [
"user_name" => "foo",
"email" => "foo@bar.com",
"age" => 25,
"(JSON) lang" => ["en", "fr", "jp", "cn"] // => '["en","fr","jp","cn"]'
]);
~~~
#### 多條數據插入
可以同時插入多條數據.
~~~
$last_user_id = $database->insert("account", [
[
"user_name" => "foo",
"email" => "foo@bar.com",
"age" => 25,
"city" => "New York",
"(JSON) lang" => ["en", "fr", "jp", "cn"]
],
[
"user_name" => "bar",
"email" => "bar@foo.com",
"age" => 14,
"city" => "Hong Kong",
"(JSON) lang" => ["en", "jp", "cn"]
]
]);
~~~
#### 使用 SQL 函數
在一些特殊的情況下,您可能需要使用SQL函數來處理數據。在字段前加入#號即可
~~~
$last_user_id = $database->insert("account", [
"user_name" => "bar",
"#uid" => "UUID()"
]);
~~~