oci_connect

PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0

oci_connect - Connect to an Oracle database

Code Examples

Example #1 Basic oci_connect using Easy Connect syntax

1
2
<?php
// Connects to the XE service (i.e. database) on the "localhost" machine
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Edit/Test in Sandbox

PHP Version:

Example #2 Basic oci_connect using a Network Connect name

1
2
<?php
// Connects to the MYDB database described in tnsnames.ora file,
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Edit/Test in Sandbox

PHP Version:

Example #3 oci_connect with an explicit character set

1
2
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE', 'AL32UTF8');
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Edit/Test in Sandbox

PHP Version:

Example #4 Using multiple calls to oci_connect

<?php
$c1 = oci_connect("hr", "welcome", 'localhost/XE');
$c2 = oci_connect("hr", "welcome", 'localhost/XE');
// Both $c1 and $c2 show the same PHP resource id meaning they use the
// same underlying database connection
echo "c1 is $c1 \n";
echo "c2 is $c2 \n";
function create_table($conn)
{
 $stmt = oci_parse($conn, "create table hallo (test varchar2(64))");
 oci_execute($stmt);
 echo "Created table \n";
}
function drop_table($conn)
{
 $stmt = oci_parse($conn, "drop table hallo");
 oci_execute($stmt);
 echo "Dropped table \n";
}
function insert_data($connname, $conn)
{
 $stmt = oci_parse($conn, "insert into hallo
 values(to_char(sysdate,'DD-MON-YY HH24:MI:SS'))");
 oci_execute($stmt, OCI_DEFAULT);
 echo "$connname inserted row without committing \n";
}
function rollback($connname, $conn)
{
 oci_rollback($conn);
 echo "$connname rollback \n";
}
function select_data($connname, $conn)
{
 $stmt = oci_parse($conn, "select * from hallo");
 oci_execute($stmt, OCI_DEFAULT);
 echo "$connname ----selecting \n";
 while (oci_fetch($stmt)) {
 echo " " . oci_result($stmt, "TEST") . " \n";
 }
 echo "$connname ----done \n";
}
create_table($c1);
insert_data('c1', $c1); // Insert a row using c1
sleep(2); // sleep to show a different timestamp for the 2nd row
insert_data('c2', $c2); // Insert a row using c2
select_data('c1', $c1); // Results of both inserts are returned
select_data('c2', $c2); // Results of both inserts are returned
rollback('c1', $c1); // Rollback using c1
select_data('c1', $c1); // Both inserts have been rolled back
select_data('c2', $c2);
drop_table($c1);
// Closing one of the connections makes the PHP variable unusable, but
// the other could be used
oci_close($c1);
echo "c1 is $c1 \n";
echo "c2 is $c2 \n";
// Output is:
// c1 is Resource id #5
// c2 is Resource id #5
// Created table
// c1 inserted row without committing
// c2 inserted row without committing
// c1 ----selecting
// 09-DEC-09 12:14:43
// 09-DEC-09 12:14:45
// c1 ----done
// c2 ----selecting
// 09-DEC-09 12:14:43
// 09-DEC-09 12:14:45
// c2 ----done
// c1 rollback
// c1 ----selecting
// c1 ----done
// c2 ----selecting
// c2 ----done
// Dropped table
// c1 is
// c2 is Resource id #5

1
2
<?php
$c1 = oci_connect("hr", "welcome", 'localhost/XE');
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Edit/Test in Sandbox

PHP Version:

oci_connect

Example #1 Basic oci_connect using Easy Connect syntax

Example #2 Basic oci_connect using a Network Connect name

Example #3 oci_connect with an explicit character set

Example #4 Using multiple calls to oci_connect

Function oci_connect:

Oracle OCI8 Functions

Most used PHP functions