Waga10:
i keep getting this message in my website since i migrated my new host{Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/u666995223/public_html/dbconfig.php on line 9}
please if anybody knows the solution for this help out so i can put my website back online thanks.

micodon:


PHP's mysql driver is no longer supported as from PHP 5.5. mayber your new host is running that or above. You should rewrite your queries using mysqli or PDO

Waga10:
if you can help me with somthing like this [<?php
//
$dbhost="mysql.host.com";
$dbname="12345";
$dbuser="12345";
$dbpass="123456";

//
$dbconnect=mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
?>] it will be much appreciated
thanks

// Connecting to database
$dbhost="mysql.host.com";
$dbname="12345";
$dbuser="12345";
$dbpass="123456";

try {
    $db_connection = new PDO('mysql:host=' . $dbhost . ';dbname=' . $dbname . ';charset=utf8', $dbuser, $dbpass);
    } 

catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
    }

enmacmedia:


The error message you are getting is telling you to use mysqli or PHP Data Objects (PDO) The example below is with PDO;

// Connecting to database
$dbhost="mysql.host.com";
$dbname="12345";
$dbuser="12345";
$dbpass="123456";

try {
    $db_connection = new PDO('mysql:host=' . $dbhost . ';dbname=' . $dbname . ';charset=utf8', $dbuser, $dbpass);
    } 

catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
    }

The above code will help you connect to you database if the variables provided are correct or else it will display an error message. Do more research on PHP Data Objects, so that you'll know how to run mysql queries using PHP Data Objects (PDO).

Waga10:
if you can help me with somthing like this [<?php
//
$dbhost="mysql.host.com";
$dbname="12345";
$dbuser="12345";
$dbpass="123456";[b][/b]

//
$dbconnect=mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
?>] it will be much appreciated
thanks

Waga10:
if you can help me with somthing like this [<?php
//
$dbhost="mysql.host.com";
$dbname="12345";
$dbuser="12345";
$dbpass="123456";[b][/b]

//
$dbconnect=mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
?>] it will be much appreciated
thanks

Waga10:
finally solved.
<?php

$dbhost="mysql.host.com";
$dbname="12345";
$dbuser="12345";
$dbpass="123456";

//Don't change the below 2 lines
$dbconnect=@mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
php?>
the above solved the problem. just put @ at the back of mysql
soursce
http://stackoverflow.com/users/3233927/rebirth

Waga10:
finally solved.
<?php

$dbhost="mysql.host.com";
$dbname="12345";
$dbuser="12345";
$dbpass="123456";

//Don't change the below 2 lines
$dbconnect=@mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
php?>

the above solved the problem. just put @ at the back of mysql
soursce
http://stackoverflow.com/users/3233927/rebirth

Adesege:
Waga10, while that may solve your problem, technically it is wrong to do so.

Mysql has been deprecated as of PHP 5.5 does not mean you cant use it on a server. Deprecated doesnt mean it has been removed.

The solution you got will suppress the error but what if you have a problem connecting ro your db, that means you wont be able to get the errors.

A more better approach is to suppress E_DEPRECATED errors using the php error reporting. With that, you will get every other errors expect for E_DEPRECATED errors.

Put this at the very top of your mysql_connect page.

<?php
error_reporting(E_ALL ^E_DEPRECATED);
?>

As a side note, it is advisable you migrate to mysqli or PDO. There is a tool you can use to migrate from mysql to mysqli online. You can check mysql official website.

Let me know if you get it

micodon:


Actually, deprecated functions will be removed entirely in future releases

Adesege:


Yah! Buh it's yet to be removed. So it can still be used. Just that he will be having cross platform issues