Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

PHP & ADODB - Trouble connecting

2:01 pm on Mar 20, 2013 (gmt 0)

New User

joined:Mar 20, 2013
posts: 2
votes: 0

Hello! I am rather new to PHP and I'm to connect to an oracle database. I managed the connection using OCI8 directly but I've decided ADODB would help me simplify matters. I've been trying to connect using it to no avail, would anybody mind taking a look to my code?

This one works

$conn = oci_connect('NAME', 'PASSWORD', '');

$stid = oci_parse($conn, 'select table_name from user_tables');

This one prints nothing at all though it doesn't really show the connection failed message


$conn = &ADONewConnection('oci8');
$conn->PConnect('','NAME','PASSWORD', 'XE');
if (!$conn) die("Connection failed");



$recordSet = $conn->Execute('select * from ld_autos');


Any ideas on what I may be doing wrong? Thanks in advance!
10:46 am on Mar 22, 2013 (gmt 0)


WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
votes: 2

Welcome to WebmasterWorld, AlexMagic.

ADOdb is not a standard PHP extension. I'm not saying that means it is bad or not popular, just that you may find less folks in the forum familiar with it. PDO is standard in PHP >= 5.1 and may be a viable alternative to try as well.

That said, am since I am also unfamiliar with ADOdb, the first place I guess I would look would be the error logs. That is, assuming ADOdb has hooks written in to write to your error logs. And have you tried to var_dump your $conn variable directly after attempting to create the new object?

$conn = &ADONewConnection('oci8'); 
11:22 am on Mar 25, 2013 (gmt 0)

New User

joined:Mar 20, 2013
posts: 2
votes: 0

Thnks for your quick reply and sorry for my late one!
I did try it and it did create the class. I have, hoever, given up and just used oci8. I still really appreciate you took the time to answer, you're awfully sweet! Thanks a lot!