Forum und email
ora_bind
Podręcznik PHP
PoprzedniNastępny

ora_bind

(PHP 3, PHP 4, PHP 5 <= 5.1.0RC1)

ora_bind -- Binds a PHP variable to an Oracle parameter

Opis

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.

Parametry

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:

ConstantValue
ORA_BIND_INOUT0
ORA_BIND_IN1
ORA_BIND_OUT2

Zwracane wartości

Zwraca TRUE w przypadku sukcesu, FALSE w przypadku porażki. Details about the error can be retrieved using the ora_error() and ora_errorcode() functions.

Rejestr zmian

WersjaOpis
5.1.0

The oracle extension is deprecated in favor of oci8.

3.0.1 The constants for the type were added. In previous versions, you should use the numerical values.

Przykłady

Przykład 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";
?>

Notatki

When using oci8 as a replacement for the deprecated oracle extension, consider using:

oci_bind_by_name()
oci_bind_array_by_name()

PoprzedniSpis treściNastępny
Oracle Functions [deprecated]Początek rozdziału<