登陆界面 login.php
<form action="logincheck.php" method="post">
用户名:<input type="text" name="username">
<br/>
密码:<input type="password" name="password">
<br/>
<input type="submit" name="submit" value="登录">
<a href="register.php">注册</a>
</form>
登录处理界面
<?php
if(isset($_POST['submit'])&&$_POST['submit']=='登录'){
$user = $_POST["username"];
$psw = $_POST["password"];
if($user==""||$psw==""){
echo "<script> alert('请输入用户或密码!');history.go(-1);</script>"
}else{
mysql_connect("localhost","root","sixx");
mysql_select_db("vt");
mysql_query('set names 'gbk'');
$sql="select username,password from user where username='$_POST[username]'and password = '$_POST[password]'";
$result=mysql_query($sql);
$num=mysql_num_rows($result);
if($num){
$row=mysql_fetch_array($result);//将数据以索引方式存在数组中
echo $row[0];
}else{
echo "<script> alert('用户名或密码不正确!');history.go(-1);</script>";
}
}else{
echo "<script>alert('提交成功!');history.go(-1);</script>";
}
注册界面 register.php
<?php
if(isset($_POST['Submit'])&&$_POST['Submit']=='注册'){
$user=$_POST["username"];
$psw=$_POST['password'];
$psw_confirm=$_POST['confirm'];
if($user==""||$psw==""||$psw_confirm==""){
echo "<script>alert('请确定信息完整性!');history.go(-1)</script>"
}else{
if($psw==$psw_confirm){
mysql_connect("localhost","root","sixx"){ //链接数据库
mysql_select_db("vt");//选择数据库
mysql_query("set names 'gdk'") //设定字符集
$sql="select username from user where username='$_POST[username]'";//SQL语句
$result=mysql_query($sql);//执行SQL语句
$num=mysql_num_rows($result)//统计执行结果影响的行数
if($num){
echo "<script>alert('用户名已存在');history.go(-1);</script>"
}else{
//不存在当前用户名称
$sql_insert="insert into user (username,password,phone,address) values('$_post[name]','$_post[password]','','')";
$res_insert=mysql_query($sql_insert);
//$num_insert=mysql_num_rows($res_insert);
if($res_insert){
echo "<script>alert('注册成功');history.go(-1);</script>"
}else{
echo "<script>alert('系统繁忙,请稍后!');history.go(-1);</script>"
}
}
}
}
}
}