I need to convert the following connection and function from mysql to mysqli. I was reading about a conversion tool that was launched but The page where it should be doesnt exist any longer:
define('DBHOST','host');
define('DBUSER','database username');
define('DBPASS','password');
define('DBNAME','database name');
// make a connection to mysql here
$conn = @mysql_connect (localhost, user, pass);
$conn = @mysql_select_db (database);
if(!$conn){
die( "Sorry! There seems to be a problem connecting to our database.");
}
function login($user, $pass){
$user = strip_tags(mysql_real_escape_string($user));
$pass = strip_tags(mysql_real_escape_string($pass));
$pass = md5($pass);
$sql = "SELECT id, fname, lname, username, password
FROM users
WHERE username = '$user' AND password = '$pass'";
$result = mysql_query($sql) or die('Query failed. ' . mysql_error());
$user_data = mysql_fetch_assoc($result);
if (mysql_num_rows($result) == 1) {
// the username and password match,
// set the session
$_SESSION['authorized'] = true;
$_SESSION['user'] = $user_data['fname'];
// direct to admin
header('Location: '.DIRADMIN);
exit();
} else {
// define an error message
$_SESSION['error'] = 'Sorry, wrong username or password';
}
}
Can someone tell me where I can download that tool or give me some directions. Thank you in advance.