i got a new host, they enabled mysqli for me after i asked them now i get errors? i can connect but not query or is something wrong with my code?
I get this error
Fatal error: Call to undefined function: mysqli_query() in /home/sites/wow-manager.co.cc/public_html/includes/class/userAuth.php on line 19
when i run this script
<?php
class userAuth {
var $cxn; //Connection String
var $user; //Username String
var $pass; //Password String
function login(){
$sql="SELECT * FROM `users` WHERE `username`='".$this->user."' AND `password`='".$this->pass."'";
$result = mysqli_query($this->cxn, $sql);
if(mysqli_num_rows($result)){
return true;
}else{ return false; }
}
function fpass(){
$sql="SELECT * FROM `users` WHERE `username`='".$this->user."'";
$result = @mysqli_query($this->cxn, $sql);
if(@mysqli_num_rows($result)){
$row = @mysqli_fetch_assoc($result);
$subject = "Forgotten Password, WoWAccount Management.";
$msg = "
Dear ".$this->user." \n
Your username is: ".$row['username']." \n
Your passowrd is: ".$row['password']." \n
Please login at http://wow-manager.co.cc
";
if(@mail($row['email'], "Subject: $subject", $msg, "From: support@wow-manager.co.cc" )){
return true;
}else{return false;}
}else{ return false; }
}
function logout(){
session_destroy();
session_unset();
return true;
}
}
$userAuth = new userAuth;
?>
Thanks in advanced
