TableUpdate::bind
PHP function
Edit on GitHub ✎
Bind update query parameters
Description
mysql_xdevapi\TableUpdate::bind(array $placeholder_values): mysql_xdevapi\TableUpdate
Binds a value to a specific placeholder.
Parameters
placeholder_valuesThe name of the placeholder, and the value to bind, defined as a JSON array.
Return Values
A TableUpdate object.
Examples
mysql_xdevapi\TableUpdate::bind() example
php
<?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();
?>