TableSelect::bind

(No version information available, might only be in Git)

TableSelect::bind — Bind select query parameters

说明

public mysql_xdevapi\TableSelect::bind ( array $placeholder_values ) : mysql_xdevapi\TableSelect

Binds a value to a specific placeholder.

参数

placeholder_values

The name of the placeholder, and the value to bind.

返回值

A TableSelect object.

范例

Example #1 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);
?>

以上例程的输出类似于：

Array
(
    [0] => Array
        (
            [name] => John
            [age] => 42
        )
)
相关文章
php mysql xdevapi 函数 bind prepared statement variables as parametersphp mysql xdevapi collectionfind bind value to query placeholderphp mysql xdevapi collectionmodify bind value to query placeholderphp mysql xdevapi crudoperationbindable bind value to placeholderphp mysql xdevapi sqlstatement bind statement parametersphp mysql xdevapi tabledelete bind delete query parametersphp mysql xdevapi tabledelete execute delete queryphp mysql xdevapi tableinsert execute insert queryphp mysql xdevapi tableselect bind select query parametersphp mysql xdevapi tableselect execute select statementphp mysql xdevapi tableselect set select grouping criteriaphp mysql xdevapi tableselect set select having conditionphp mysql xdevapi tableselect limit selected rowsphp mysql xdevapi tableselect execute exclusive lockphp mysql xdevapi tableselect execute shared lockphp mysql xdevapi tableselect set limit offsetphp mysql xdevapi tableselect set select sort criteriaphp mysql xdevapi tableselect set select search conditionphp mysql xdevapi tableupdate bind update query parametersphp mysql xdevapi tableupdate execute update query
关注编程学问公众号