$strSQL="select count(*) from pwtable where user='$_REQUEST['user']' and password='$_REQUEST['oldpw']'";
$row = mysql_fetch_array(mysql_query($strSQL));
if ($row[0] == 1)
mysql_query("update pwtable set password='$_REQUEST['newpwl']' where user='$_REQUEST['user']'");
$row = mysql_fetch_array(mysql_query($strSQL));
if ($row[0] == 1)
mysql_query("update pwtable set password='$_REQUEST['newpwl']' where user='$_REQUEST['user']'");
www.phpe.net有下载
用途:修改密码数据库中有一密码表(pwtable)
user password
-------------------
kenko 123
mike 789page 1:(HTML)
填写用户名称(user),旧密码(Oldpw),新密码(Newpw1),
确认新密码(Newpw)。page 2:(PHP)
怎么样才能将数据库中的user 、password字段提取出来分别赋给两个字符串变量$uername, $pw ???本贴加20分,共60分。
$result = mysql_query($sql);
$arr = mysql_fetch_array($result);
$username = $arr[0];
$pw = $arr[1];
mysql_free_result($result);
echo "username=".$username;
echo "<br>";
echo "password=".$pw;