MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
TableSelect::bind
Bind select query parameters
public mysql_xdevapi\TableSelect mysql_xdevapi\TableSelect::bind(array placeholder_values);
Binds a value to a specific placeholder.
placeholder_values
The name of the placeholder, and the value to bind.
A TableSelect object.
Example 5.172 mysql_xdevapi\TableSelect::bind
example
<?php $session = mysql_xdevapi\getSession("mysqlx://user:password@localhost"); $schema = $session->getSchema("addressbook"); $table = $schema->getTable("names"); $result = $table->select('name','age') ->where('name like :name and age > :age') ->bind(['name' => 'John', 'age' => 42]) ->execute(); $row = $result->fetchAll(); print_r($row); ?>
The above example will output something similar to:
Array ( [0] => Array ( [name] => John [age] => 42 ) )