Fatal error: Call to undefined function mysql_connect()

Fatal error: Call to undefined function mysql_connect()

 

This means that you are using an Updated version of PHP, which is greater than PHP version 7.x. In PHP versions 7.x and above, the function, ‘mysql_connect()‘ is depreciated and was removed.

 

To fix this fatal error, use the function;

mysqli_connect(“host”, “username”, “password”)’

 

You can also use the MySQL function;

‘new mysqli->(“host”,”username”,”password”,”database”),

which should be assigned to a $variable for reuse purposes.

 

 

CORRECT METHOD:

 

$mysqli = mysqli_connect(“host”, “user”, “password”, “database”);
$res = mysqli_query($mysqli, “SELECT * FROM table WHERE column LIKE ‘condition’ “);
$row = mysqli_fetch_assoc($res);

 

&&

 

$mysqli = new mysqli(“localhost”, “user”, “password”, “database”);
if ($mysqli->connect_errno) {
echo “Connection unsuccessful: . $mysqli->connect_error”;
}
$res = mysqli->query($mysqli, “SELECT * FROM table WHERE column LIKE ‘condition’ “);
$row = $res->fetch_assoc();

 

 

WRONG METHOD:

 

$mysql = mysql_connect(“host”, “user”, “password”);
mysql_select_db(“test”);
$res = mysql_query(“SELECT * FROM table WHERE column LIKE ‘condition’ “, $mysql);
$row = mysql_fetch_assoc($res);

 

 

 

 

MySQL Errors
Forum | thetqweb