PHP connect to database with mysqli but not with mysql, please help

[roshanajaml]

hi, install php 5.2 mysql 5.1 and apache 2.2 phpmyadmin3.4.5 everything works perfect but when I try to connect mysql with mysql_connect it doesnt connect to mysql but when i try "$conn = new mysqli" it connects to the database, and I cant connect to mysql using phpmyadmin as well

please help me I am stuck for 2wheeks
please any clues would be much appreciated

Kind Regards

[bradgrafelman]

Sounds like you simply don't have the [man]mysql[/man] extension enabled. However, note that the mysql extension has been replaced with [man]MySQLi[/man] ("MySQL Improved"), so you would be advised to use that (or something like [man]PDO[/man]) instead. Otherwise, you'll need to enable the 'mysql' extension in your php.ini file.

roshanajaml wrote:

I cant connect to mysql using phpmyadmin as well

Well then that's a configuration issue on your part, because phpMyAdmin is perfectly capable of using the MySQLi extension as well.

[roshanajaml]

thanks for the reply, to to honest I have uncommented the both mysql and mysqli lines in my phpini file, i am using win 7 64 it does it has to do anything with this problem

Kind Regards

[roshanajaml]

any help please

[sneakyimp]

check the output of this script and see if there's a section for both mysqli and mysql:

phpinfo();

If not, you don't have them enabled. Also, simply uncommenting the lines for mysql doesn't necessarily get them installed. It depends on how you installed php on our system.