MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
TableUpdate::bind
Bind update query parameters
public mysql_xdevapi\TableUpdate mysql_xdevapi\TableUpdate::bind(array placeholder_values);
Binds a value to a specific placeholder.
placeholder_values
The name of the placeholder, and the value to bind, defined as a JSON array.
A TableUpdate object.
Example 5.183 mysql_xdevapi\TableUpdate::bind
example
<?php $session = mysql_xdevapi\getSession("mysqlx://user:password@localhost"); $schema = $session->getSchema("addressbook"); $table = $schema->getTable("names"); $table->update() ->set('status', 'admin') ->where('name = :name and age > :age') ->bind(['name' => 'Bernie', 'age' => 2000]) ->execute(); ?>