connect oracle database with php and execute sql?

Question

Hey guys im trying to connect to an oracle database with php. I tried it like i do it with mysql. How to do it like this:

$host="localhost";
$user="username";
$pass="password";
$db="database";

$link = mysql_connect($host, $user, $pass) or die ("Keine Verbindung zu der Datenbank moeglich.");

mysql_select_db($db, $link);

$sql = "SQL query goes here";

$result = mysql_query($sql);

How can i do exact this with an oracle database. I have the following connection details sid, ip, port, username, password.

You cannot use the MySQL extension to connect to Oracle. Period. As the name suggests, it's built for MySQL. — Álvaro González
– Álvaro González, Commented Jan 15, 2013 at 10:30
He just gave an example how he's doing it in mysql. Nothing wrong with that. — Alen Oblak
– Alen Oblak, Commented Jan 15, 2013 at 10:32

Alen Oblak · Accepted Answer · 2013-01-15 10:31:46Z

4

Simple script:

$DB = '//1.2.3.4:1521/XE';
$DB_USER = 'user';
$DB_PASS = 'pass';
$DB_CHAR = 'AL32UTF8';

$conn = oci_connect($DB_USER, $DB_PASS, $DB, $DB_CHAR);
$statement = oci_parse($conn, 'select 1 from dual');
oci_execute($statement);
$row = oci_fetch_array($statement, OCI_ASSOC+OCI_RETURN_NULLS);

answered Jan 15, 2013 at 10:31

Alen Oblak

3,32515 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Alesfatalis Over a year ago

And how to use the sid in the script without it i can't connect and for what stands the /xe for behind the ip

Álvaro González Over a year ago

This is the only recommended way to connect to Oracle. The PDO driver is tagged as experimental because it's basically abandoned.

Alen Oblak Over a year ago

The "xe" after the IP is the SID.

Alesfatalis Over a year ago

OK your script gives me this error: Fatal error: Call to undefined function oci_connect()

Alen Oblak Over a year ago

You need the OCI extension on your server. Check the documentation: si.php.net/manual/en/oci8.setup.php

kokx · Accepted Answer · 2013-01-15 10:30:59Z

1

To connect with an Oracle database, you don't use the mysql extension (since that is for MySQL). You should use PDO, with the OCI/Oracle adapter.

answered Jan 15, 2013 at 10:30

kokx

1,70613 silver badges20 bronze badges

Comments

RMcLeod · Accepted Answer · 2013-01-15 10:31:33Z

0

You'll want to use PDO to connect to Oracle here is the PHP manual page on creating a connection using PDO, the example given is for MySQL but it will work fine with Oracle. You will need to ensure the PDO:Oracle extension is installed and running on your PHP configuration.

answered Jan 15, 2013 at 10:31

RMcLeod

2,5821 gold badge22 silver badges38 bronze badges

Collectives™ on Stack Overflow

connect oracle database with php and execute sql?

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related