PHP - Error mysql_connect(): The mysql extension is deprecated and will be removed

<?php

/***************************************************************************

 *

 *

 *

 *   Link to eSyndiCat.com can not be removed from the software pages without

 *	 permission of eSyndiCat respective owners. It is the only requirement

 *	 for using this software.

 *

 *   Copyright 2005-2007 Intelliants LLC

 *   http://www.intelliants.com/

 *

 ***************************************************************************

 *

 *	 Implements class needed for work with database

 *

 ***************************************************************************/

class Database

{

	var $mConfig;

	var $mLink = null;

	// specific for every derived class

	var $mTable = '';

	// used in resetTable and setTable methods

	var $_tableNameBackup = '';

	/**

	* Connects to database

	*/

	function connect()

	{

		$this->mLink = mysql_connect($this->mConfig['dbhost'].":".$this->mConfig['dbport'], $this->mConfig['dbuser'], $this->mConfig['dbpass']);

		if (!$this->mLink)

		{

			if(DEBUG == 0)

			{

				$msg = "Could not connect";

			}

			else

			{

				$msg = "Could not connect to the database. For more information see error logs";

			}

			die($msg);

		}

		if(MYSQLVER > 40)

		{

			$this->query("SET NAMES 'utf8'");

		}

		if (!mysql_select_db($this->mConfig['dbname'],$this->mLink))

		{

			trigger_error("An error occured while selecting database: ".mysql_error($this->mLink), E_USER_ERROR);

			die ();

		}

	}

	/**

	* Used to set table to work with (almost always resetTable should be called after calling this method)

	*

	* @param str $tablename

	* @param str $prefix with or without prefix

	*

	* @return string

	*/

	function setTable($tablename,$prefix=true)

	{

		// store for further usage in resetTable

		$this->_tableNameBackup = $this->mTable;

		if($prefix)

		{

			$this->mTable = $this->mPrefix.$tablename;

		}

		else

		{

			$this->mTable = $tablename;

		}

	}

	/**

	* Reset previously changed table

	*/

	function resetTable()

	{

		if(empty($this->_tableNameBackup))

		{

			return false;

		}

		// store for further usage in resetTable

		$this->mTable = $this->_tableNameBackup;

		$this->_tableNameBackup = '';

	}

	/**

	* Executes sql query

	*

	* @param str $aSql sql query

	*

	* @return bool

	*/

	function query($aSql)

	{

		if(!$this->mLink)

		{

			$this->connect();

		}

		if(DEBUG===2)

		{

			$t = Debug::m();

		}

		$rs = mysql_query($aSql, $this->mLink);

		if(DEBUG===2)

		{

			$t = round(Debug::m() - $t,4);

			$t = "DB Query: |".$t." ".$aSql;

			trigger_error($t, E_USER_NOTICE);

		}

		if (!$rs)

		{

			$error = mysql_error();

			$esynConfig = new Config();

			$config = & $esynConfig->instance();

			$email = $config->get('bugs_email');

			if ($email)

			{

				$event 	= array(

				"type"		=> EMAIL_NOTIFY,

				"action" 	=> "site_error",

				"params" 	=> array(

					"rcpts"		=>	array($email),

					"subject"	=> " [database error]",

					"body"		=> "SQL Server's error: ".$error."\n \n SQL Query: ".$aSql

					)

				);

				//$config->notify($event);

			}

			ob_start();

			echo '<div style="border: 1px solid #F00; font: 12px verdana; width: 500px; margin: 0 auto; color: #F00; background-color: #EFEFEF; clear: both;font-weight:bold;">';

			echo "<div style=\"border-bottom: 1px solid #F00; padding: 10px;\"><strong>Error:</strong> ".$error."</div>";

			echo "<div style=\"background-color: #EAEAEA; padding: 10px;\">".$aSql."</div>";

			echo '</div>';

			echo "<PRE style=\"color:red;background-color:white;padding:5px;font-size:16px;font-weight:bold;\">";

			echo "\n\n<h3>Debug backtrace:</h3>\n";

			debug_print_backtrace();

			echo "<hr />";

			echo "</PRE>";

			$data = ob_get_clean();

			if(DEBUG)

			{

				echo $data;

			}

			trigger_error("Database query error: ".strip_tags($data), E_USER_ERROR);

			die("Fatal database error");

		}

		return $rs;

	}

	/**

	* Returns row of elements

	*

	* @param str $aSql sql query

	*

	* @return arr

	*/

	function getRow($aSql)

	{

		$out	= false;

		$r		= $this->query($aSql);

		if($this->getNumRows($r) > 0)

		{

			$out = mysql_fetch_assoc($r);

		}

		return $out;

	}

	/**

	* Returns array of rows

	*

	* @param str $aSql sql query

	*

	* @return arr|FALSE

	*/

	function getAll($aSql)

	{

		$out = false;

		$r = $this->query($aSql);

		if($this->getNumRows($r) > 0)

		{

			$out = array();

			while($temp = mysql_fetch_assoc($r))

			{

				$out[] = $temp;

			}

			return $out;

		}

	}

	/**

	* Returns recordset as associative array where the key is the first field

	*

	* @param str $aSql sql query

	*

	* @return arr

	*/

	function getAssoc($aSql)

	{

		$out = false;

		$r = $this->query($aSql);

		if($this->getNumRows($r))

		{

			$out = array();

			while ($temp = mysql_fetch_assoc($r))

			{

				$key = array_shift($temp);

				$out[$key][] = $temp;

			}

		}

		return $out;

	}

	/**

	* Returns recordset as associative array where the key is the first field

	*

	* @param str $aSql sql query

	*

	* @return arr

	*/

	function getKeyValue($aSql)

	{

		$out = false;

		$r = $this->query($aSql);

		if($this->getNumRows($r) > 0)

		{

			$out = array();

			while ($temp = mysql_fetch_row($r))

			{

				$out[$temp[0]] = $temp[1];

			}

		}

		return $out;

	}

	/**

	* Returns only one element or false!

	*

	* @param str $aSql sql query

	*

	* @return string

	*/

	function getOne($aSql)

	{

		$ret = false;

		$r = $this->query($aSql);

		if($this->getNumRows($r) > 0)

		{

			$ret = mysql_result($r,0,0);

		}

		return $ret;

	}

	/**

	* Returns true if at least 1 record exists

	*

	* @param str $aSql sql query

	*

	* @return bool

	*/

	function exists($aSql)

	{

		$r = $this->query($aSql);

		return $this->getNumRows($r) > 0;

	}

	function getInsertId()

	{

		return mysql_insert_id($this->mLink);

	}

	function getAffected()

	{

		return mysql_affected_rows($this->mLink);

	}

	function getNumRows($rs)

	{

		return mysql_num_rows($rs);

	}

	/**

	* Returns found rows of previous DQL with SQL_CALC_FOUND_ROWS

	* Note: this SQL function is MySQL specific!

	*/

	function foundRows()

	{

		return (int)$this->getOne("SELECT FOUND_ROWS()");

	}

	/**

	* Close connection to database

	*

	* @param $aConnection connection

	*

	* return bool

	*/

	function close($aConn=null)

	{

		if(null==$aConn)

		{

			$aConn = $this->mLink;

		}

		return mysql_close($aConn);

	}

	/*

	* get's ID from the string like

	* "`id`='123'" or

	* "id='123'" or

	* "id=123" or

	* "`id`=123" (123 in this case) or

	* false

	*/

	function scanForId($str)

	{

		$id = false;

		if(preg_match("/\bid[^=]?\s*=\s*'?(\d+)/", $str, $m))

		{

			$id = (int)$m[1];

		}

		return $id;

	}

	function describe($table = false)

	{

		if(!$table)

		{

			$table = $this->mTable;

		}

		return $this->getAll("DESC `".$table."`");

	}

}

http://php.net/manual/es/book.mysqli.php