₦airaland Forum

Good day house, i update my locallhost/wampserver, after importing my database into my phpadmin i tried login in buh i got this error "mysql depricated, use mysqli or pdo blablabla... in connection.php"
This the code bello

<?php
session_start();
$hostname = "localhost";
$database = "db_crimemanager";
$username = "root";
$password = "";
$conn = mysql_connect($hostname, $username, $password) or die(mysql_error());
$db = mysql_select_db($database, $conn) or die(mysql_error());
if (!$db) {
die("Unable to select database";
}
?>
Pls i need sme1 to help me out with this as soon as posible, thnkx

dapaiks:
Good day house, i update my locallhost/wampserver, after importing my database into my phpadmin i tried login in buh i got this error "mysql depricated, use mysqli or pdo blablabla... in connection.php"
This the code bello

<?php
session_start();
$hostname = "localhost";
$database = "db_crimemanager";
$username = "root";
$password = "";
$conn = mysql_connect($hostname, $username, $password) or die(mysql_error());
$db = mysql_select_db($database, $conn) or die(mysql_error());
if (!$db) {
die("Unable to select database";
}
?>
Pls i need sme1 to help me out with this as soon as posible, thnkx

You need to write your codes in mysqli mysql is no more in use. Mysqli and PDO is the new normal. Read more on it.

Mysql is no more secured from sql injection attack, that's the reason for having to upgrade to mysqli.

Luminee:
You need to write your codes in mysqli mysql is no more in use. Mysqli and PDO is the new normal. Read more on it.

Mysql is no more secured from sql injection attack, that's the reason for having to upgrade to mysqli.

I will definately read abt it, buh ryt nw i dnt hv tym on my side, i jst need a way to handle this situation like imediately.

dapaiks:
Good day house, i update my locallhost/wampserver, after importing my database into my phpadmin i tried login in buh i got this error "mysql depricated, use mysqli or pdo blablabla... in connection.php"
This the code bello

<?php
session_start();
$hostname = "localhost";
$database = "db_crimemanager";
$username = "root";
$password = "";
$conn = mysql_connect($hostname, $username, $password) or die(mysql_error());
$db = mysql_select_db($database, $conn) or die(mysql_error());
if (!$db) {
die("Unable to select database";
}
?>
Pls i need sme1 to help me out with this as soon as posible, thnkx

use it this way but you will still have to change all your MySQL to MySQLi in all your codes. MySQL is outdated.

<?php

//Connect to database
$db_connect = mysqli_connect("localhost", "root", "", "db_crimemanager" ;

// check the connection
if (mysqli_connect_error()) {
echo 'Unable to select database';
exit();
}

dapaiks:
I will definately read abt it, buh ryt nw i dnt hv tym on my side, i jst need a way to handle this situation like imediately.

The issue just doesn't affect only your php login code, as affects all your codes. There is a slight difference in the syntax of mysqli, so even if I help you with the login code, how do you solve all other pending issues?

Read on it bro

Boss, this is a safer method so you won't waste time
In your connection.php,
write
$mysql=new mysqli("localhost", "root", "", "db_crimemanager" ;
Then in your functions and classes
make $mysql a GLOBAL variable
If you have the old mysql_query(), change it to $query=$mysql->query()
if you have the old mysql_num_rows(), change it to $num_rows=query->num_rows
Don't forget to always make the $mysql variable a global in all your functions or classes else it won't work