怎样用PHP和MYSQL制作一简单的登录界面网站
2021 - 3 - 23 TAG :
软件: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 "创建数据库失败
";}else{ echo "创建数据库功
";}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 "创建数据表失败
";}else{ echo "创建数据表功
";}$sql = "Insert INTO `user` ( `name`, `password`) VALUES ( 'php-fish', '123');";if(mysql_query($sql))echo "插入用户功
";elseecho "插入失败
";mysql_close($db);?>前台登陆文件login.php程序代码
用户名: | |
密码: | |
密码: 123
验证文件check.php程序代码<?phpif ($_POST['name'] == ""){ echo "请填写用户名
返";}elseif($_POST['password'] == ""){ echo "请填写密码返";}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 "验证功
"; }else echo "密码错误
"; echo "返";}?>
19 人围观 / 0 条评论 ↓快速评论↓