(PHP 5, PHP 7, PECL OCI8 >= 1.1.0)
oci_define_by_name — 锟斤拷 SELECT 锟斤拷使锟斤拷 PHP 锟斤拷锟斤拷锟斤拷为锟斤拷锟斤拷牟锟斤拷锟�
$statement
, string $column_name
, mixed &$variable
[, int $type
] ) : bool
oci_define_by_name() 锟斤拷 PHP 锟斤拷锟斤拷取锟斤拷
SQL 锟叫★拷 锟斤拷要注锟斤拷锟斤拷牵锟絆racle 使锟矫达拷写锟斤拷母锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫伙拷锟斤拷
select 锟斤拷也锟斤拷锟斤拷锟斤拷小写锟斤拷母锟斤拷oci_define_by_name()
锟斤拷锟斤拷 column_name 锟角达拷写锟斤拷母锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
select 锟斤拷锟斤拷校锟斤拷锟矫伙拷写锟斤拷蟊桓锟斤拷锟斤拷锟�
锟斤拷锟斤拷锟揭拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷停锟絃OB/ROWID/BFILE锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 oci_new_descriptor() 锟斤拷锟斤拷占洹ｏ拷渭锟� oci_bind_by_name() 锟斤拷锟斤拷锟斤拷
Example #1 oci_define_by_name() 锟斤拷锟斤拷
<?php
/* oci_define_by_name example - thies at thieso dot net (980219) */
$conn = oci_connect("scott", "tiger");
$stmt = oci_parse($conn, "SELECT empno, ename FROM emp");
/* the define MUST be done BEFORE oci_execute! */
oci_define_by_name($stmt, "EMPNO", $empno);
oci_define_by_name($stmt, "ENAME", $ename);
oci_execute($stmt);
while (oci_fetch($stmt)) {
echo "empno:" . $empno . "\n";
echo "ename:" . $ename . "\n";
}
oci_free_statement($stmt);
oci_close($conn);
?>
Note:
锟斤拷 PHP 5.0.0 之前锟侥版本锟斤拷锟斤拷使锟斤拷 ocidefinebyname() 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷煤锟斤拷锟斤拷锟斤拷锟饺伙拷锟斤拷茫锟轿拷锟斤拷录锟斤拷锟斤拷锟轿� oci_define_by_name() 锟侥憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟窖憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟狡硷拷使锟矫★拷