MySQL Improved Extension (
Mysqli
)
2401
Procedural style
mysqli_stmt mysqli_prepare(
mysqli link,
string query);
Prepares the SQL query, and returns a statement handle to be used for further operations on the
statement. The query must consist of a single SQL statement.
The parameter markers must be bound to application variables using
mysqli_stmt_bind_param
and/or
mysqli_stmt_bind_result
before executing the statement or fetching rows.
Parameters
link
Procedural style only: A link identifier returned by
mysqli_connect
or
mysqli_init
query
The query, as a string.
Note
You should not add a terminating semicolon
or
\g
to the statement.
This parameter can include one or more parameter markers in the
SQL statement by embedding question mark (
?
) characters at the
appropriate positions.
Note
The markers are legal only in certain places
in SQL statements. For example, they are
allowed in the
VALUES()
list of an
INSERT
statement (to specify column values for a
row), or in a comparison with a column in a
WHERE
clause to specify a comparison value.
However, they are not allowed for identifiers
(such as table or column names), in
the select list that names the columns
to be returned by a
SELECT
statement,
or to specify both operands of a binary
operator such as the
=
equal sign. The latter
restriction is necessary because it would be
impossible to determine the parameter type.
It's not allowed to compare marker with
NULL
by
? IS NULL
too. In general, parameters
are legal only in Data Manipulation Language
(DML) statements, and not in Data Definition
Language (DDL) statements.
Return Values
mysqli_prepare
returns a statement object or
FALSE
if an error occurred.
Examples
Example 20.136.
mysqli::prepare
example
Object oriented style
Содержание 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 ...