- 3.10 The mysqli_stmt class (mysqli_stmt)
- 3.10.1 mysqli_stmt::$affected_rows, mysqli_stmt_affected_rows
- 3.10.2 mysqli_stmt::attr_get, mysqli_stmt_attr_get
- 3.10.3 mysqli_stmt::attr_set, mysqli_stmt_attr_set
- 3.10.4 mysqli_stmt::bind_param, mysqli_stmt_bind_param
- 3.10.5 mysqli_stmt::bind_result, mysqli_stmt_bind_result
- 3.10.6 mysqli_stmt::close, mysqli_stmt_close
- 3.10.7 mysqli_stmt::data_seek, mysqli_stmt_data_seek
- 3.10.8 mysqli_stmt::$errno, mysqli_stmt_errno
- 3.10.9 mysqli_stmt::$error_list, mysqli_stmt_error_list
- 3.10.10 mysqli_stmt::$error, mysqli_stmt_error
- 3.10.11 mysqli_stmt::execute, mysqli_stmt_execute
- 3.10.12 mysqli_stmt::fetch, mysqli_stmt_fetch
- 3.10.13 mysqli_stmt::$field_count, mysqli_stmt_field_count
- 3.10.14 mysqli_stmt::free_result, mysqli_stmt_free_result
- 3.10.15 mysqli_stmt::get_result, mysqli_stmt_get_result
- 3.10.16 mysqli_stmt::get_warnings, mysqli_stmt_get_warnings
- 3.10.17 mysqli_stmt::$insert_id, mysqli_stmt_insert_id
- 3.10.18 mysqli_stmt::more_results, mysqli_stmt_more_results
- 3.10.19 mysqli_stmt::next_result, mysqli_stmt_next_result
- 3.10.20 mysqli_stmt::$num_rows, mysqli_stmt_num_rows
- 3.10.21 mysqli_stmt::$param_count, mysqli_stmt_param_count
- 3.10.22 mysqli_stmt::prepare, mysqli_stmt_prepare
- 3.10.23 mysqli_stmt::reset, mysqli_stmt_reset
- 3.10.24 mysqli_stmt::result_metadata, mysqli_stmt_result_metadata
- 3.10.25 mysqli_stmt::send_long_data, mysqli_stmt_send_long_data
- 3.10.26 mysqli_stmt::$sqlstate, mysqli_stmt_sqlstate
- 3.10.27 mysqli_stmt::store_result, mysqli_stmt_store_result
Copyright 1997-2012 the PHP Documentation Group.
mysqli_stmt::executemysqli_stmt_executeExecutes 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.
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 3.87. 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';
$val2 = 'DEU';
$val3 = 'Baden-Wuerttemberg';
/* Execute the statement */
$stmt->execute();
$val1 = 'Bordeaux';
$val2 = 'FRA';
$val3 = 'Aquitaine';
/* Execute the statement */
$stmt->execute();
/* close statement */
$stmt->close();
/* retrieve all rows from myCity */
$query = "SELECT Name, CountryCode, District FROM myCity";
if ($result = $mysqli->query($query)) {
while ($row = $result->fetch_row()) {
printf("%s (%s,%s)\n", $row[0], $row[1], $row[2]);
}
/* free result set */
$result->close();
}
/* remove table */
$mysqli->query("DROP TABLE myCity");
/* close connection */
$mysqli->close();
?>
Example 3.88. Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
mysqli_query($link, "CREATE TABLE myCity LIKE City");
/* Prepare an insert statement */
$query = "INSERT INTO myCity (Name, CountryCode, District) VALUES (?,?,?)";
$stmt = mysqli_prepare($link, $query);
mysqli_stmt_bind_param($stmt, "sss", $val1, $val2, $val3);
$val1 = 'Stuttgart';
$val2 = 'DEU';
$val3 = 'Baden-Wuerttemberg';
/* Execute the statement */
mysqli_stmt_execute($stmt);
$val1 = 'Bordeaux';
$val2 = 'FRA';
$val3 = 'Aquitaine';
/* Execute the statement */
mysqli_stmt_execute($stmt);
/* close statement */
mysqli_stmt_close($stmt);
/* retrieve all rows from myCity */
$query = "SELECT Name, CountryCode, District FROM myCity";
if ($result = mysqli_query($link, $query)) {
while ($row = mysqli_fetch_row($result)) {
printf("%s (%s,%s)\n", $row[0], $row[1], $row[2]);
}
/* free result set */
mysqli_free_result($result);
}
/* remove table */
mysqli_query($link, "DROP TABLE myCity");
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Stuttgart (DEU,Baden-Wuerttemberg) Bordeaux (FRA,Aquitaine)
See Also
mysqli_prepare
|
mysqli_stmt_bind_param
|
User Comments
Add your own comment.