目录

replace 替换

优质
小牛编辑
138浏览
2023-12-01

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]);