Online Tutorials & Training Materials | STechies.com
Register Login

Call To Undefined Function Mysql_connect() error in PHP 7

|| 0

Call To Undefined Function Mysql_connect() error in PHP 7
Stechies

After upgrading  to  PHP 7 from PHP 5, I start getting  error

PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect()

This is because mysql_* functions are completely removed from PHP 7, it was get deprecated in PHP 5.5 but now it is completely removed.

The older mysql function are removed due to following reasons

  1. Not work on Object Oriented concept
  2. Wont support  transactions and prepared statements
  3. Insecure

How to fix Undefined Function Mysql_connect() error

1. use MySQLi or PDO

mysqli_connect()
PDO::__construct()

2. Connecting to MySQL with the PDO object is actually pretty straight forward:

$user = 'root'; // Mysql User
$password = ''; // Mysql Password
$server = 'localhost'; // Mysql Host
$database = 'my_database'; // Mysql Databse
// PDO Connection string
$pdo = new PDO("mysql:host=$server;dbname=$database", $user, $password);

3 Connecting to MySQL with MySqli connection object

$con = mysqli_connect('localhost', 'username', 'password', 'database');

4. Roll back to Older PHP 5, update your code to mysqli or PDO and then upgrade to PHP7

Best Practice

Use MySQLi wrapper and object mapper with prepared statements.

Example: User PHP-MySQLi-Database-Class https://github.com/ThingEngineer/PHP-MySQLi-Database-Class

By using MySQLi with prepare statement will totally secure your database connection  & in future if need to upgrade your Database to some other version you wont have to update all you mysql connection string in all pages.

This package is totally free and customizable you can upgrade by creating your own Class & functions.