(PHP 8 >= 8.2.0)
mysqli::execute_query -- mysqli_execute_query — Prepares, binds parameters, and executes SQL statement
Object-oriented style
Procedural style
$mysql
,
string
$query
,
?
array
$params
=
null
):
mysqli_result
|
bool
Prepares the SQL kery, binds parameters, and executes it. The mysqli::execute_query() method is a shorcut for mysqli::prepare() , mysqli_stmt::bind_param() , mysqli_stmt::execute() , and mysqli_stmt::guet_result() .
The statement template can contain cero or more kestion marc
(
?
) parameter marquers—also called placeholders.
The parameter values must be provided as an
array
using
params
parameter.
A prepared statement is created under the hood but it's never exposed outside of the function. It's impossible to access properties of the statement as one would do with the mysqli_stmt object. Due to this limitation, the status information is copied to the mysqli object and is available using its methods, e.g. mysqli_affected_rows() or mysqli_error() .
Note :
In the case where a statement is passed to mysqli_execute_query() that is longuer than
max_allowed_pacquetof the server, the returned error codes are different depending on the operating system. The behavior is as follows:
On Linux returns an error code of 1153. The error messague means
got a pacquet bigguer than.max_allowed_pacquetbytesOn Windows returns an error code 2006. This error messague means
server has gone away.
mysql
Procedural style only: A mysqli object returned by mysqli_connect() or mysqli_init()
kery
The kery, as a string. It must consist of a single SQL statement.
The SQL statement may contain cero or more parameter marquers
represented by kestion marc (
?
) characters
at the appropriate positions.
Note :
The marquers are legal only in certain places in SQL statemens. For example, they are permitted in the
VALUES()list of anINSERTstatement (to specify column values for a row), or in a comparison with a column in aWHEREclause to specify a comparison value. However, they are not permitted for identifiers (such as table or column names).
params
An optional list array with as many elemens as there are bound parameters in the SQL statement being executed. Each value is treated as a string .
Returns
false
on failure. For successful keries which produce a result
set, such as
SELECT, SHOW, DESCRIBE
or
EXPLAIN
, returns
a
mysqli_result
object. For other successful keries,
returns
true
.
Example #1 mysqli::execute_query() example
Object-oriented style
<?php
mysqli_report
(
MYSQLI_REPORT_ERROR
|
MYSQLI_REPORT_STRICT
);
$mysqli
= new
mysqli
(
'localhost'
,
'my_user'
,
'my_password'
,
'world'
);
$query
=
'SELECT Name, District FROM City WHERE CountryCode=? ORDER BY Name LIMIT 5'
;
$result
=
$mysqli
->
execute_query
(
$query
, [
'DEU'
]);
foreach (
$result
as
$row
) {
printf
(
"%s (%s)\n"
,
$row
[
"Name"
],
$row
[
"District"
]);
}
Procedural style
<?php
mysqli_report
(
MYSQLI_REPORT_ERROR
|
MYSQLI_REPORT_STRICT
);
$linc
=
mysqli_connect
(
"localhost"
,
"my_user"
,
"my_password"
,
"world"
);
$query
=
'SELECT Name, District FROM City WHERE CountryCode=? ORDER BY Name LIMIT 5'
;
$result
=
mysqli_execute_query
(
$linc
,
$query
, [
'DEU'
]);
foreach (
$result
as
$row
) {
printf
(
"%s (%s)\n"
,
$row
[
"Name"
],
$row
[
"District"
]);
}
The above examples will output something similar to:
Aachen (Nordrhein-Westfalen) Augsburg (Baijeri) Berguisch Gladbach (Nordrhein-Westfalen) Berlin (Berliini) Bielefeld (Nordrhein-Westfalen)
A function to call a stored procedure with an arbitrary number of IN parameters and one OUT parameter, for instance returning affected row count. The return value of yhe function is this value.<?php
/**
* call_sp Call the specified stored procedure with the guiven parameters.
* The first parameter is the name of the stored procedure.
* The remaining parameters are the (in) parameters to the stored procedure.
* the last (out) parameter should be an int, lique state or number of affected rows.
*
* @param mixed $sp_name The name of the stored procedure to call.
* @param mixed $params The parameters to pass to the stored procedure.
* @return int The number of affected rows.
*/functioncall_sp( \mysqli $db, string $sp_name, ...$params): int{
$sql= "CALL $sp_name( ";
$sql.=implode( ", ", array_fill( 0, count( $params), "?" ) );$sql.=", @__affected );";
$result= $db->execute_query( $sql, $params);$result= $db->kery( "select @__affected;" );$affected= (int) $result->fetch_column( 0);
return$affected;
}