Oracle 5.0, Reference Manual

Page: 2460 / 3232

MySQL Improved Extension (
Mysqli
)
2440
mode
The value to assign to the attribute.
20.7.3.10.4.
mysqli_stmt::bind_param
,
mysqli_stmt_bind_param
Copyright 1997-2012 the PHP Documentation Group. [2230]
•
mysqli_stmt::bind_param
mysqli_stmt_bind_param
Binds variables to a prepared statement as parameters
Description
Object oriented style
bool mysqli_stmt::bind_param(
string types,
mixed var1,
mixed ...);
Procedural style
bool mysqli_stmt_bind_param(
mysqli_stmt stmt,
string types,
mixed var1,
mixed ...);
Bind variables for the parameter markers in the SQL statement that was passed to
mysqli_prepare
.
Note
If data size of a variable exceeds max. allowed packet size
(max_allowed_packet), you have to specify
b
in
types
and use
mysqli_stmt_send_long_data
to send the data in packets.
Note
Care must be taken when using
mysqli_stmt_bind_param
in conjunction
with
call_user_func_array
. Note that
mysqli_stmt_bind_param
requires parameters to be passed by reference, whereas
call_user_func_array
can accept as a parameter a list of variables that
can represent references or values.
Parameters
stmt
Procedural style only: A statement identifier returned by
mysqli_stmt_init
.
types
A string that contains one or more characters which specify the
types for the corresponding bind variables:
Table 20.48. Type specification chars
Character Description
i corresponding variable has type
integer
d corresponding variable has type
double
s corresponding variable has type
string