"Call to undefined function mysql_connect()" error on PHP 7+

[Vanderburg]

If you're receiving the following error:

Code: Select all

Uncaught Error: Call to undefined function mysql_connect() in /usr/www/identifier/public/forums/functions/db.php:324

...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.

1. Download the PHP 7 mysql shim.
2. 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.
3. Locate a common file that is included everywhere in your software. Often this file is called "config.php" or "Settings.php" or similar.
4. Make a backup copy of that config file before editing.
5. Edit the config file to add this before other PHP statements:

   Code: Select all

   include_once('./mysql.php');

   1. 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'.
   2. If you do not have a common config file, the line above will need to be included in all files using MySQL.