-
Notifications
You must be signed in to change notification settings - Fork 0
/
_resetPassWord.php
21 lines (19 loc) · 886 Bytes
/
_resetPassWord.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?php
$userid=$_POST['userid'];
$passWord=$_POST['password'];
include("_func_info.php");
echo $passWord;
echo $userid;
$stmt=mysqli_prepare($dbcon,"UPDATE user SET password=PASSWORD(?) WHERE id=?;") or die("wan yi zhou - prepare");
mysqli_stmt_bind_param($stmt, 'si', $passWord, $userid) or die("wan yi zhou - bind");
mysqli_stmt_execute($stmt) or die("wan yi zhou - execute");
$row_affect=mysqli_stmt_affected_rows($stmt);
mysqli_stmt_close($stmt);
$stmt2=mysqli_prepare($dobcon,"DELETE FROM setpassword WHERE id=?");
mysqli_stmt_bind_param($stmt2, 'i', $userid);
mysqli_stmt_execute($stmt2);
//$result=mysqli_query($dbcon,"UPDATE user SET password=PASSWORD($passWord) WHERE id='$userid';DELETE FROM setpassword WHERE id='$userid'");
//$row=mysqli_affected_rows($dbcon);
if($row_affect!=0)
echo "<script>alert('change password success');location.href='index.php';</script>";
?>