PHP : Function Reference : Oracle Functions : oci_connect PHP Examples Tutorials References

Example 1637. oci_connect() example

<?php
echo "<pre>";
$db = "";

$c1 = oci_connect("scott", "tiger", $db);
$c2 = oci_connect("scott", "tiger", $db);


function create_table($conn)

{

  $stmt = oci_parse($conn, "create table scott.hallo (test varchar2(64))");

  oci_execute($stmt);

  echo $conn . " created table\n\n";

}


function drop_table($conn)

{

  $stmt = oci_parse($conn, "drop table scott.hallo");

  oci_execute($stmt);

  echo $conn . " dropped table\n\n";

}


function insert_data($conn)

{

  $stmt = oci_parse($conn, "insert into scott.hallo

            values('$conn' || ' ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'))");

  oci_execute($stmt, OCI_DEFAULT);

  echo $conn . " inserted hallo\n\n";

}


function delete_data($conn)

{

  $stmt = oci_parse($conn, "delete from scott.hallo");

  oci_execute($stmt, OCI_DEFAULT);

  echo $conn . " deleted hallo\n\n";

}


function commit($conn)

{

  oci_commit($conn);

  echo $conn . " committed\n\n";

}


function rollback($conn)

{

  oci_rollback($conn);

  echo $conn . " rollback\n\n";

}


function select_data($conn)

{

  $stmt = oci_parse($conn, "select * from scott.hallo");

  oci_execute($stmt, OCI_DEFAULT);

  echo $conn."----selecting\n\n";

  while (oci_fetch($stmt)) {

    echo $conn . " [" . oci_result($stmt, "TEST") . "]\n\n";

  }

  echo $conn . "----done\n\n";

}

create_table($c1);
insert_data($c1);   // Insert a row using c1
insert_data($c2);   // Insert a row using c2

select_data($c1);   // Results of both inserts are returned
select_data($c2);

rollback($c1);      // Rollback using c1

select_data($c1);   // Both inserts have been rolled back
select_data($c2);

insert_data($c2);   // Insert a row using c2
commit($c2);        // Commit using c2

select_data($c1);   // Result of c2 insert is returned

delete_data($c1);   // Delete all rows in table using c1
select_data($c1);   // No rows returned
select_data($c2);   // No rows returned
commit($c1);        // Commit using c1

select_data($c1);   // No rows returned
select_data($c2);   // No rows returned

drop_table($c1);

echo "</pre>";
?>

Examples ( Source code ) » oci_connect


<?

$c = oci_connect("hr", "hrpwd", "//localhost/XE");

$s = oci_parse($c, "select region_name,

           regions.region_id as myreg,

           country_name,

           countries.region_id

            from countries

            inner join regions

            on countries.region_id = regions.region_id");

     oci_execute($s);

while ($res = oci_fetch_array($s)) {

      echo $res["REGION_NAME"] . " " . $res["MYREG"] . " - " .

      $res["COUNTRY_NAME"] . " " . $res["REGION_ID"] . " " .

      "<br>\n";

}

?>

The query column alias MYREG is used as the index to the result array. The script output is:

Americas 2 - Argentina 2

Asia 3 - Australia 3

Europe 1 - Belgium 1

Americas 2 - Brazil 2

Americas 2 - Canada 2

Related Examples ( Source code ) » oci_connect

Code Examples / Notes » oci_connect

When you are using Oracle 9.2+ I would say that you MUST use the CHARSET parameter. Of course, you will not notice it until there is accented character... so just specify it and you will avoid a big headache. So for example here is our Oracle internal conf: select * from nls_database_parameters; PARAMETER VALUE ------------------------------ ---------------------------------------- â€¦ NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_ISO_CURRENCY AMERICA NLS_CHARACTERSET WE8ISO8859P15 â€¦ And there our oci_connect call: $dbch=ocilogon($user,$pass,$connectString,"WE8ISO8859P15"); Without that, you will get question mark (inversed), squaresâ€¦ instead of most accented character. Donâ€™t forget to use that for writing as well as for reading.

Using tnsnames.ora Apache 2 php 5.0.5 Oracle 10 IstantClient PHP half of times return this error: OCISessionBegin: ORA-24327: need explicit attach before authenticating a user in ... In Oracle manual I find: ORA-24327 need explicit attach before authenticating a user Cause: A server context must be initialized before creating a session. Action: Create and initialize a server handle. I resolved using Easy Connect Naming Method. Notice of this problem in bug#29779. --- Best Regards, Domenico

For use PHPv5 functions in PHPv4 i use simple script: <?php $funcs=array( 'oci_connect'=>'OCILogon', 'oci_parse'=>'OCIParse', 'oci_execute'=>'OCIExecute', 'oci_fetch'=>'OCIFetch', 'oci_num_fields'=>'OCINumCols', 'oci_field_name'=>'OCIColumnName', 'oci_result'=>'OCIResult', 'oci_free_statement'=>'OCIFreeStatement', ); // yoy can add yours pairs of funcs. foreach ($funcs as $k=>$v) { if (!function_exists($k)) { $arg_string='$p0'; for ($i=1;$i<20;$i++) { $arg_string.=',$p'.$i; } eval ('function '.$k.' () { list('.$arg_string.')=func_get_args(); return '.$v.'('.$arg_string.'); } '); } } ?> simple, but it work. :-)

oci_connect

Establishes a connection to the Oracle server (PHP 5, PECL oci8:1.1-1.2.4)
resource oci_connect ( string username, string password [, string db [, string charset [, int session_mode]]] )

Example 1637. oci_connect() example

Related Examples ( Source code ) » oci_connect

Code Examples / Notes » oci_connect

Change Language

oci_connect

Establishes a connection to the Oracle server (PHP 5, PECL oci8:1.1-1.2.4) resource oci_connect ( string username, string password [, string db [, string charset [, int session_mode]]] )

Example 1637. oci_connect() example

Related Examples ( Source code ) » oci_connect

Code Examples / Notes » oci_connect

Change Language

Establishes a connection to the Oracle server (PHP 5, PECL oci8:1.1-1.2.4)
resource oci_connect ( string username, string password [, string db [, string charset [, int session_mode]]] )