Tja , håller just nu på med att fixa ett Settings page för mitt system fast den vill inte uppdatera ett nuvarande lösenordet?
PHP-kod:
<html>
<head>
<style type="text/css">
body
{
color:White;
}
</style>
</head>
<body>
<form name="form1" method="post" action="Settings.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="black">
<tr>
<td colspan="3"><strong>Settings </strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input name="myusername" type="text" id="myusername"></td>
</tr>
<tr>
<td>Old Password</td>
<td>:</td>
<td><input name="mypassword" type="password" id="mypassword"></td>
</tr>
<tr>
<td width="78">New password</td>
<td width="6">:</td>
<td width="294"><input name="myusername" type="text" id="newpw"></td>
<td> </td>
<td> </td>
</tr>
<td><input type="submit" name="Submit" value="Make change!">
</form>
</body>
</html>
<?php
If (isset($_POST['newpw'])){
$host="XXXXXXXXXXXXXX"; // Host name
$username="XXXXXXXXXXXX"; // Mysql username
$password="XXXXXXXXXXXXX"; // Mysql password
$db_name="XXXXXXXXXXXXXXXX"; // Database name
$tbl_name="XXXXXXXXXXXXX"; // Table name
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
$newpw=$_POST['newpw'];
$newpw = stripslashes($newpw);
$newpw = mysql_real_escape_string($newpw);
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count==1){
$sql="UPDATE $tbl_name
SET password='$newpw' WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
Echo "Successfully changed your password!".$myusername."<br/>";
}
else {
echo "Wrong Username or Password";
}
}
?>
tackar på förhand!
2011-10-09, 15:13
Svara med citat
Problem med Update i Mysql Query?
Trådad visning