"Call to undefined function mysql_connect()" error on PHP 7+
Posted: Fri Sep 08, 2017 11:40 am
If you're receiving the following error:
...this is due to the deprecated mysql extension no longer being included, breaking all "mysql_" functions. Update or convert your software to use mysqli or PDO. If those aren't options in the short term, apply a shim that recreates the functions.
Code: Select all
Uncaught Error: Call to undefined function mysql_connect() in /usr/www/identifier/public/forums/functions/db.php:324- Download the PHP 7 mysql shim.
- Upload the mysql.php file to your webhosting. Place it in the includes folder for your website, or a directory where typical config files can be found, if available.
- Locate a common file that is included everywhere in your software. Often this file is called "config.php" or "Settings.php" or similar.
- Make a backup copy of that config file before editing.
- Edit the config file to add this before other PHP statements:
Code: Select all
include_once('./mysql.php');- This assumes the shim is in the same directory as the config file. If it's one directory up, use '../mysql.php' and if it's one directory down, use './folder_name/mysql.php'.
- If you do not have a common config file, the line above will need to be included in all files using MySQL.