<post><?php
$dbc=mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD) or die ('Failed'.mysqli_error());
if(isset($_POST['submit'])):
extract($_POST);
if($old_password!="" && $password!="" && $confirm_pwd!="") :`enter code here`
$user_id = '1';
$old_pwd=md5(mysqli_real_escape_string($dbc,$_POST['old_password']));
$pwd=md5(mysqli_real_escape_string($dbc,$_POST['password']));
$c_pwd=md5(mysqli_real_escape_string($dbc,$_POST['confirm_pwd']));
if($pwd == $c_pwd) :
if($pwd!=$old_pwd) :
$db_check=$dbc->mysqli_query($dbc,"SELECT * FROM `users` WHERE `id`='$user_id' AND `password` ='$old_pwd'");
$count=mysqli_num_rows(mysqli_query($dbc,"SELECT * FROM `users` WHERE `id`='$user_id' AND `password` ='$old_pwd'"));
if($count==1) :
$fetch=$db->mysqli_query($dbc,"UPDATE `users` SET `password` = '$pwd' WHERE `id`='$user_id'");
$old_password=''; $password =''; $confirm_pwd = '';
$msg_sucess = "Your new password update successfully.";
else:
$error = "The password you gave is incorrect.";
endif;
else :
$error = "Old password new password same Please try again.";
endif;
else:
$error = "New password and confirm password do not matched";
endif;
else :
$error = "Please fil all the fields";
endif;
endif;
?> <code>
mysqli_query不是
对象的methot。 mysqli_query只是php函数。修复 $db_check=$dbc->mysqli_query($dbc, ...);to $db_check=$mysqli_query($dbc, ...);
如果要使用 OOP,则必须创建 mysqli 对象:$mysqli = new mysqli("localhost", "my_user", "my_password", "world");$result = $mysqli->query($sql);
您可以在此处阅读有关此内容 http://php.net/manual/en/class.mysqli.php。