文章来源于网络收集而来，版权归原创者所有，如有侵权请及时联系！

replace 替换

发布于 2019-11-08 06:36:51 字数 1832 浏览 964 评论 0 收藏 0

replace

将新的数据替换旧的数据

replace($table, $column, $search, $replace, $where)

table [string]
表名.
columns [string/array]
The target columns of data will be replaced.
search [string]
The value being searched for.
replace [string]
The replacement value that replaces found search values.
where (optional) [array]
The WHERE clause to filter records.

replace($table, $column, $replacement, $where)

table [String]
表名.
columns [string/array]
The target columns of data will be replaced.
replacement [array]
The replacement array value that contained search value as key and replace string as value.
where (optional) [array]
The WHERE clause to filter records.

replace($table, $columns, $where)

table [string]
表名.
columns [array]
The target columns of data will be replaced.
where (optional) [array]
The WHERE clause to filter records.

Return: [number] 返回受影响的行数

$database->replace("account", "type", "user", "new_user", [
    "user_id[>]" => 1000]
);
$database->replace("account", "type", [
    "user" => "new_user",
    "business" => "new_business"], [
    "user_id[>]" => 1000]
);
$database->replace("account", [
    "type" => [
        "user" => "new_user",
        "business" => "new_business"
    ],
    "group" => [
        "groupA" => "groupB"
    ]], [
    "user_id[>]" => 1000]
);