Mysql_query to mysqli_query – PHP

Here are some good examples of how you can adapt your code.

Old config, connecting to the database:

1
2
3
4
5
6
7
8
9
10
11
12
<?php
 
$dbadress = "localhost";
$dbname = "db";
$dbusername = "root";
$dbpass ="";
 
$connection = mysql_connect($dbadress, $dbusername, $dbpass);
mysql_query($sql, $connection);
}
 
?>

becomes

2
3
4
5
6
7
8
9
10
11
<?php
 
$dbadress = "localhost";
$dbname = "db";
$dbusername = "root";
$dbpass ="";
 
$connection = mysqli_connect($dbaddress, $dbusername, $dbpass, $dbname) or die ('cannot connect to the SQL server');
 
?>

Just notice that the first variable from the parenthesis is the $dbaddress (localhost) and the last is the name of the database.

Another example with the old mysql_fetch_array.

Old version:

3
4
5
6
7
8
9
10
11
<?php
 
require ('config.php');
 
$requestSQL = mysql_query("SELECT * FROM table where id = 1 order by id ASC LIMIT 500", $connection);
while ($row = mysql_fetch_array($requestSQL))
	{
        }
?>

New version with mysqli:

4
5
6
7
8
9
10
11
12
<?php
 
require ('config.php');
 
$requestSQL = mysqli_query($connection, "SELECT * FROM table where id = 1 order by id ASC LIMIT 500");
while ($row = mysqli_fetch_array($requestSQL))
	{
        }
?>

So just change the location of the $connection variable and put mysqli instead of mysql.

Leave in the comments if you have questions or anything to add.

ADD A COMMENT: