MySQL Query Problem
Posted
by
user559744
on Stack Overflow
See other posts from Stack Overflow
or by user559744
Published on 2011-02-20T06:58:55Z
Indexed on
2011/02/20
7:24 UTC
Read the original article
Hit count: 100
Hello guys, I'm getting following error message. Please help me. Thanks
Notice: Trying to get property of non-object in
C:\xampp\htdocs\my\include\user_functions.php on line 34
Here is my Code
$conn = db_connection();
if($conn == false) {
user_error('Unable to connect to database');
return false;
}
$query = "UPDATE user SET passwd = '".$new_passwd."'
WHERE username = '".$username."' ";
$result=$conn->query($query);
if($result == false) {
user_error('Query Error'.$conn->error);
return false;
}
if($result->num_rows == 1) {
echo 'Password changed';
} else {
echo 'Failed ';
}
here is my db_connection
function db_connection() {
$db = new mysqli('localhost','root','','php_login');
if(!$db) {
echo 'Could not connect to database server';
} else {
return $db;
}
}
© Stack Overflow or respective owner