怎样用PHP和MYSQL制作一简单的登录界面网站(网站制作php,关键词优化)

软件：dreamwaver 记事本 mysql.php----数据库创建文件；login.php----前台用户登陆文件；check.php----连接数据库验证文件；mysql.php文件代码：程序代码<?php$db = mysql_connect("localhost","root","") or die("连接数据库失败");if(!mysql_query("create database if not exists user")){ echo "创建数据库失败<br>";}else{ echo "创建数据库功<br>";}mysql_query("use user;");$sql ="Create TABLE if not exists user (" ." id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," ." name VARCHAR(10) NOT NULL," ." password VARCHAR(16) NOT NULL" ." )";if(!mysql_query($sql)){ echo "创建数据表失败<br>";}else{ echo "创建数据表功<br>";}$sql = "Insert INTO user ( name, password) VALUES ( 'php-fish', '123');";if(mysql_query($sql))echo "插入用户功<br>";elseecho "插入失败<br>";mysql_close($db);?>前台登陆文件login.php程序代码<form method="post" action="check.php"><table cellpadding="0" cellspacing="0" border="0" width="25%"><tr> <td>用户名:</td> <td><input type="text" name="name"></td></tr><tr> <td>密码:</td> <td><input type="password" name="password"></td></tr><tr> <td><input type="submit" value="提交"></td> <td><input type="reset" value="清除"></td></tr></table></form>用户名：<b>php-fish</b><br>密码：<b>123<br>验证文件check.php程序代码<?phpif($_POST['name'] == ""){ echo "请填写用户名<br><a href='login.php'>返</a>";}elseif($_POST['password'] == ""){ echo "请填写密码<br><a href='login.php'>返</a>";}else{ $conn = mysql_connect("localhost","root","") or die("能连接数据库".mysql_error()); mysql_select_db("user") or die ("能连接user".mysql_error()); $sql = "select * from user where id=3"; $result = mysql_query($sql); $query = mysql_fetch_array($result); mysql_close($conn); if(($query['name'] == $_POST['name']) && ($query['password'] == $_POST['password'])) { echo "验证功<br>"; }else echo "密码错误<br>"; echo "<a href='login.php'>返</a>";}?>