ora_bind
(PHP 4, PHP 5 <= 5.0.5)
ora_bind — Binds a PHP variable to an Oracle parameter
說明
bool ora_bind
( resource $cursor
, string $phpvar
, string $sqlparam
, int $length
[, int $type
] )
Binds the named PHP variable with a SQL parameter.
ora_bind() must be called after ora_parse() and before ora_exec(). Input values can be given by assignment to the bound PHP variables, after calling ora_exec() the bound PHP variables contain the output values if available.
參數
- cursor
-
An Oracle cursor, opened with ora_open().
- phpvar
-
The PHP variable to be bound.
- sqlparam
-
The SQL parameter. Must be in the form :name.
- length
-
- type
-
Defines the type of the parameter. It defaults to ORA_BIND_INOUT. Possible values are listed below:
Constant Value ORA_BIND_INOUT 0 ORA_BIND_IN 1 ORA_BIND_OUT 2
Return值
如果成功則回傳 TRUE，失敗則回傳 FALSE。 Details about the error can be retrieved using the ora_error() and ora_errorcode() functions.
更新日誌
| 版本 | 說明 |
|---|---|
| 5.1.0 | |
| 3.0.1 | The constants for the type were added. In previous versions, you should use the numerical values. |
範例
Example#1 ora_bind() example
<?php
ora_parse($curs, "declare tmp INTEGER; begin tmp := :in; :out := tmp; :x := 7.77; end;");
ora_bind($curs, "result", ":x", $len, 2);
ora_bind($curs, "input", ":in", 5, 1);
ora_bind($curs, "output", ":out", 5, 2);
$input = 765;
ora_exec($curs);
echo "Result: $result<br />Out: $output<br />In: $input";
?>