[RESOLVED] PHP and MySQL: error on first connect

ArmanIc

Hi,

My first trial to use a database with PHP fails on the very first command:

$db = mysql_connect("localhost", "myuser", "mypassword") or die("Could not connect: " . mysql_error());

PHP reports: Fatal error: Call to undefined function mysql_connect() in ...etc.

I'm running MySQL 4.1.12a, PHP 5.0.4, Apache 2.0.53 on Windows XP and phpMyAdmin 2.6.3.pl1 works OK.

What the hell did I forgot?

Any help is appreciated.

Arman

drew010

in your php.ini you have to uncomment the line that says
;extension php_mysql.dll
also make sure the file libmysql.dll is in your system32 directory.

ArmanIc

Somewhere I read that for MySQL 4.1 and higher a special PHP-MySQL library package must be used.
So I have the following command in php.ini: extension=php_mysqli.dll.
Furthermore, libmysql.dll is in c:\PHP and this folder is in the system path.

If these were wrong, I assumed that phpMyAdmin cannot work.
Or am I mistaken?

drew010

if you are using mysqli then you must use the mysqli functions, mysql_connect is not part of that. see www.php.net/mysqli

ArmanIc

Yes, I see. It now works, thanks!

In fact, I prefer the mysql functions (there are a lot of predefined scripts available) rather than the mysqli ones. But I had to change to mysqli since phpMyAdmin needed these to handle the new MySQL 4.1 password handling.
My question is: is this correct? Or can I use both?