Tony Aldemir wrote:
Hi There,
I am trying to connect to MySQL using ADODB library for PHP using the
following code with no success. What am I doing wrong?
<?php
include('/php/adodb.inc.php');
$db = &ADONewConnection('mysql'); # eg. 'mysql' or 'oci8'
$db->debug = true;
$db->Connect('localhost', 'tony', 'mypassword', 'test');
$rs = $db->Execute('select * from users');
print "<pre>";
print_r($rs->GetRows());
print "</pre>";
?>
Notes:
1) After unzipping the downloaded ADODB file into a directory, I copied the
adodb.inc.php file by itself into my c:\PHP directory. The ADODB
documentation says "Unpack all the files into a directory accessible by your
webserver". What does this mean? Is there a setting somewhere in the
Apache Server that I need to tweak (e.g. some sort of setting in the
httpd.conf)?
2) By the way, I CAN connect to MySQL using PHP directly (i.e. without the
use of ADODB) just fine and work with the 'test' database's 'users' table.
"Unpack all the files into a directory accessible by your webserver" means placing those files either in the htdocs folder or a folder below that one. ie Unless you have fiddled with Apache settings in httpd.conf Apache controls what folders browsers can see on your server and the default is as I have stated above.
An example would be my setup which is http://localhost/Kiosk/debug.html and it finds my adodb files in c:\Pogram Files\Apache Group\Apache2\htdocs\Kiosk\adodb. From that you can see, if I have explained clearly enough, that a browser looking at http://localhost/Kiosk/debug.html cannot "see" anything below c:\Program Files\Apache Group\Apache2\htdocs\Kiosk and for that matter I could place the debug.html in htdocs rather than Kiosk and the browser command would be http://localhost/debug.html in other words Apache defaults to htdocs as the root.
--
Regards,
Alf Stockton www.stockton.co.za
You will be the last person to buy a Chrysler.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
