- 20.7.8 Mysqlnd user handler plugin (mysqlnd_uh)
- 20.7.8.1 Security considerations
- 20.7.8.2 Documentation note
- 20.7.8.3 On the name
- 20.7.8.4 Quickstart and Examples
- 20.7.8.5 Installing/Configuring
- 20.7.8.6 Predefined Constants
- 20.7.8.7 The MysqlndUhConnection class (MysqlndUhConnection)
- 20.7.8.8 The MysqlndUhPreparedStatement class (MysqlndUhPreparedStatement)
- 20.7.8.9 Mysqlnd_uh Functions
- 20.7.8.10 Change History
Copyright 1997-2012 the PHP Documentation Group.
MysqlndUhPreparedStatement {
MysqlndUhPreparedStatement Methodspublic MysqlndUhPreparedStatement::__construct();public bool MysqlndUhPreparedStatement::execute(mysqlnd_prepared_statement statement);public bool MysqlndUhPreparedStatement::prepare(mysqlnd_prepared_statement statement,
string query);
}
Copyright 1997-2012 the PHP Documentation Group.
MysqlndUhPreparedStatement::__constructThe __construct purpose
Description
public MysqlndUhPreparedStatement::__construct();
This function is currently not documented; only its argument list is available.
Parameters
This function has no parameters.
Return Values
Copyright 1997-2012 the PHP Documentation Group.
MysqlndUhPreparedStatement::executeExecutes a prepared Query
Description
public bool MysqlndUhPreparedStatement::execute(mysqlnd_prepared_statement statement);Executes a prepared Query.
Parameters
-
statement Mysqlnd prepared statement handle. Do not modify! Resource of type
Mysqlnd Prepared Statement (internal only - you must not modify it!).
Return Values
Returns
TRUE
on success. Otherwise, returns
FALSE
Examples
Example 20.386. MysqlndUhPreparedStatement::execute
example
<?php
class stmt_proxy extends MysqlndUhPreparedStatement {
public function execute($res) {
printf("%s(", __METHOD__);
var_dump($res);
printf(")\n");
$ret = parent::execute($res);
printf("%s returns %s\n", __METHOD__, var_export($ret, true));
var_dump($ret);
return $ret;
}
}
mysqlnd_uh_set_statement_proxy(new stmt_proxy());
$mysqli = new mysqli("localhost", "root", "", "test");
$stmt = $mysqli->prepare("SELECT 'Labskaus' AS _msg FROM DUAL");
$stmt->execute();
$msg = NULL;
$stmt->bind_result($msg);
$stmt->fetch();
var_dump($msg);
?>
The above example will output:
stmt_proxy::execute(resource(256) of type (Mysqlnd Prepared Statement (internal only - you must not modify it!)) ) stmt_proxy::execute returns true bool(true) string(8) "Labskaus"
See Also
mysqlnd_uh_set_statement_proxy
|
mysqli_stmt_execute
|
Copyright 1997-2012 the PHP Documentation Group.
MysqlndUhPreparedStatement::preparePrepare an SQL statement for execution
Description
public bool MysqlndUhPreparedStatement::prepare(mysqlnd_prepared_statement statement,
string query);Prepare an SQL statement for execution.
Parameters
-
statement Mysqlnd prepared statement handle. Do not modify! Resource of type
Mysqlnd Prepared Statement (internal only - you must not modify it!).-
query The query to be prepared.
Return Values
Returns
TRUE
on success. Otherwise, returns
FALSE
Examples
Example 20.387. MysqlndUhPreparedStatement::prepare
example
<?php
class stmt_proxy extends MysqlndUhPreparedStatement {
public function prepare($res, $query) {
printf("%s(%s)\n", __METHOD__, var_export(func_get_args(), true));
$query = "SELECT 'No more you-know-what-I-mean for lunch, please' AS _msg FROM DUAL";
$ret = parent::prepare($res, $query);
printf("%s returns %s\n", __METHOD__, var_export($ret, true));
var_dump($ret);
return $ret;
}
}
mysqlnd_uh_set_statement_proxy(new stmt_proxy());
$mysqli = new mysqli("localhost", "root", "", "test");
$stmt = $mysqli->prepare("SELECT 'Labskaus' AS _msg FROM DUAL");
$stmt->execute();
$msg = NULL;
$stmt->bind_result($msg);
$stmt->fetch();
var_dump($msg);
?>
The above example will output:
stmt_proxy::prepare(array ( 0 => NULL, 1 => 'SELECT \'Labskaus\' AS _msg FROM DUAL', )) stmt_proxy::prepare returns true bool(true) string(46) "No more you-know-what-I-mean for lunch, please"
See Also
mysqlnd_uh_set_statement_proxy
|
mysqli_stmt_prepare
|
mysqli_prepare
|
User Comments
Add your own comment.