20141229 作業十三 - 身分認證 check.php
<?php
$link=mysql_connect("localhost","root","123456") or die("無法連接資料庫");
mysql_select_db("account") or die("無法選擇資料庫");
mysql_query("SET NAMES 'utf8'");
$sql="select*from student where name='$acc' and password='$pass'";
$result = mysql_query($sql);
if(mysql_num_rows($result)==0){
echo "登入失敗，帳號或密碼錯誤";
}
else{
$row=mysql_fetch_array($result);
echo "<form action=stupdate.php method=post name=myform>";
echo "<p>";
echo "登入成功，可修改密碼<p>";
echo "帳號:<input name=acc type=text value=$row[name] readonly></p>";
echo "<p>";
echo "密碼:<input name=pass type=text value=$row[password]></p>";
echo "<p>";
echo "<input name=key type=submit value=修改><input name=key type=reset value=重設></p>";
echo "</form>";
}
?>
20141229 作業十三 - 身分認證 index.htm
<p>
<form action="check.php" method="post" name="myform">
<p>
帳號 : <input name="acc" type="text" /></p>
<p>
密碼 : <input name="pass" type="password" /></p>
<p>
<input name="key" type="submit" value="送出" /><input name="key" type="reset" value="重設" /></p>
</form>
<p>
20141229 作業十三 - 身分認證 stupdate.php
<?php
$link=mysql_connect("localhost","root","123456") or die("無法連接資料庫");
mysql_select_db("account") or die("無法選擇資料庫");
mysql_query("SET NAMES 'utf8'");
$sql="update student set password='$pass' where name='$acc'";
mysql_query($sql) or die("更新失敗");
header('Location: index.htm');
?>
