undefined function mysql_connect() in php

Question

I have mysql-installer-web-community-5.6.25.0, apache_2.4.2-x86-no-ssl and php-5.4.42-Win32-VC9-x86 installed.

php is working with apache server but not with mysql. I have enabled extension=php_mysql.dll and extension=php_mysqli.dll in php.ini and restarted my pc.I have tried adding libmysql.dll and php_mysql.dll to system32.But mysql is not displayed in phpinfo().

My phpinfo() is as follows http://192.168.1.104/test.php

Also i tried with the following php code

$continued = mysql_connect("localhost","sonetonix","sonetonix");

if($continued) {
    echo("Connection is succeed");
} else {
    echo("Connection is fail");
}

when i run the code i am getting error as Call to undefined function mysql_connect().

How can i make php and mysql work.

There is no more support for mysql_* functions, they are officially deprecated, no longer maintained and will be removed in the future. You should update your code with PDO or MySQLi to ensure the functionality of your project in the future. — Ben
What php version do you use? Latest version of PHP are removed mysql_ extension. so use PDO or mysqli_ extension — Nahid Bin Azhar
if you don't know anything about webserver and technologies, install xamp to start your learning — donald123
Mark as duplicate of stackoverflow.com/questions/12859942/… ? — Roland

M1ke M1ke · Accepted Answer · 2015-06-29T10:31:35

Alter the function from mysql_connect() to mysqli_connect(). You'll need to subsequently use the MySQLi function library for further SQL queries and processing.

Using MySQLi instead of MySQL functions is very similar. The main difference is that you need to return a connection object and then use that in future queries:

$db_connection = mysqli_connect("localhost","sonetonix","sonetonix");
if (empty($db_connection)){
    die('Database connection error');
}
$result = mysqli_query($db_connection, "SELECT * FROM users");

If you are running PHP 5.3 or higher this will be enabled by default. If you are not running PHP 5.3 or higher you need to updgrade, as older versions of PHP are no longer secure and have outdated functionality. From your question it would appear you are using PHP 5.4 so all this should work.

undefined function mysql_connect() in php

1 Answers