Just thought this would be of extreme help to those who are planning to migrate to php5 and still continue using MySQL same way as before:....
to get mysql work with the php 5 copy /dll/libmySQL.dll to the directory where php 5 resides and copy the /extensions/php_mysql.dll to the directory where php.exe resides.(if you can't find the two above files probably you are using an old release of php 5.you should check for latest at :http://snaps.php.net/)
in additon uncomment extension line in php.ini
and add the following code to a gnereal database file(dbcon.php) in my case and include it in each file which needs access to datanase.
if (!class_exists('mysql')) {
if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN')
dl('php_mysql.dll');
else
dl('php_mysql.so');
}
I tried to eliminate above code and leave php_mysql.dll in extensions directory. But it didn't work shouting the familiar dialouge: Unable to load ......
By the way the other way isusung ODBC for MySQL using MyODBC Driver from :
http://www.mysql.com/downloads/api-myodbc-3.52.html
So good luck coding..
Suneel Kanuri
sun4php@coolguide.net
07/08/2003