PHP用户登录注册连接MYSQL

Login.php（代码）：

include('conn.php');

session_start(); //开启session对象,用于存放用户会话信息 $s_name=$_SESSION['name']; $s_pwd=$_SESSION['pwd']; $p_name=$_POST['username']; $p_pwd=$_POST['possword'];

//将提交的值赋值为session储存保存于session对象中 $s_name=$p_name; $s_pwd=$p_pwd;

if(!empty($p_name)||!empty($p_pwd)){

$sql=\$rs=mysql_query($sql);

if($rs=mysql_query($sql)){ echo \type='text/javascript'> alert('登陆成功！');location.href='list.php';\ }else{ echo \type='text/javascript'> alert('用户名或密码错误！');location.href='login.html';\ } }else{

echo \tpye='text/javascripts'>alert('用户名或密码为空！');location.href='login.html';\} ?>

list.php代码

显示已经注册的用户

循环显示，已注册的用户


while($row=mysql_fetch_array($rs)){

echo \用户\：\} ?>

User.sql代码

SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS `user1`; CREATE TABLE `user1` (

`id` int(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `possword` varchar(255) NOT NULL, PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8; INSERT INTO user1 VALUES ('1', '123456', '123456');