Binds the PHP variable to the Oracle placeholder
bool oci_bind_by_name ( resource stmt, string ph_name, mixed &variable [, int maxlength [, int type]] )
oci_bind_by_name() binds the PHP variable
variable to the Oracle placeholder
ph_name. Whether it will be used for
input or output will be determined at run-time and the necessary
storage space will be allocated. The length
parameter sets the maximum length for the bind. If you set
length to -1
oci_bind_by_name() will use the current length of
variable to set the maximum length.
If you need to bind an abstract datatype (LOB/ROWID/BFILE) you
need to allocate it first using the
oci_new_descriptor() function. The
length is not used for abstract datatypes
and should be set to -1. The type parameter
tells Oracle which descriptor is used. Possible
$statement = oci_parse($query); oci_bind_by_name($statement, ":id", 1); oci_execute($statement); /* And this code will add 'trailing spaces follow ', preserving trailing whitespaces */ ?>
Do not use magic_quotes_gpc or
addslashes() and oci_bind_by_name()
simultaneously as no quoting is needed and any magically applied quotes
will be written into your database as oci_bind_by_name()
is not able to distinguish magically added quotings from those added
Returns TRUE on success or FALSE on failure.
In PHP versions before 5.0.0 you must use ocibindbyname() instead.
This name still can be used, it was left as alias of
oci_bind_by_name() for downwards compatability.
This, however, is deprecated and not recommended.