MySQL Improved Extension (
Mysqli
)
2453
20.7.3.10.11.
mysqli_stmt::execute
,
mysqli_stmt_execute
Copyright 1997-2012 the PHP Documentation Group. [2230]
•
mysqli_stmt::execute
mysqli_stmt_execute
Executes a prepared Query
Description
Object oriented style
bool mysqli_stmt::execute();
Procedural style
bool mysqli_stmt_execute(
mysqli_stmt stmt);
Executes a query that has been previously prepared using the
mysqli_prepare
function. When
executed any parameter markers which exist will automatically be replaced with the appropriate data.
If the statement is
UPDATE
,
DELETE
, or
INSERT
, the total number of affected rows can be determined
by using the
mysqli_stmt_affected_rows
function. Likewise, if the query yields a result set the
mysqli_stmt_fetch
function is used.
Note
When using
mysqli_stmt_execute
, the
mysqli_stmt_fetch
function
must be used to fetch the data prior to performing any additional queries.
Parameters
stmt
Procedural style only: A statement identifier returned by
mysqli_stmt_init
.
Return Values
Returns
TRUE
on success or
FALSE
on failure.
Examples
Example 20.163. Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$mysqli->query("CREATE TABLE myCity LIKE City");
/* Prepare an insert statement */
$query = "INSERT INTO myCity (Name, CountryCode, District) VALUES (?,?,?)";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("sss", $val1, $val2, $val3);
$val1 = 'Stuttgart';
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...