This error or warning is occurred when we use the latest version of wamp or lamp servers. Normally we use the function mysql_connect() in order to establish the connection with the MySql Database server in PHP. We can call this function if the mysql extension is enabled by the PHP.
The problem with the latest version of PHP and wamp , they forces us to use latest and improved version of mysql database connectivity function that is mysqli (MySql Improved). It support many more features compared to mysqls default extension for database connectivity.
Now let us examine the code that raises this warning.
<?php
//Establish the connection to the database
$con
= mysql_connect(‘localhost’,’root’,’password’);
//Select
the database
mysql_select_db(‘dbname’);
//Query
to be executed
$sql
= “SELECT * FROM Table1”;
//Assigns
the query results to a variable
$result
= mysql_query($sql);
If(mysql_affected_rows()>0){
echo
“Query Executed”;
}
?>
Even though there are number of ways to solve this problem, we will be looking at a simple solution.It is given below
<?php
$db
= new mysqli('localhost', 'user', 'pass', 'demo');
if($db->connect_errno > 0){
die('Unable to connect to database [' . $db->connect_error . ']');
}
$sql = “
SELECT *
FROM `users`
WHERE `live` = 1
“;
if(!$result = $db->query($sql)){
die('There was an error running the query [' . $db->error . ']');
}
while($row = $result->fetch_assoc()){
echo $row['username'] . '<br />';
}
?>
You can note that we established and selected the database
in a single line by just creating an object of the MySqli class. It provides us
various methods for querying the database. Also it provides a structures method
for accessing the data from the database.
If you are facing problems with the mysqli extension, you can enable or disable that in the following way.
 |
| Steps to enable or disable the mysqli extension |
if you still can't solve the problem please make your comment below.