login.php

邮箱加即时聊天

<?php ob_start(); ?>
<?php
	include "Sysconf.php";//连接数据库
	$userName=$_POST["userName"];//获取用户名
	$pass=$_POST["password"];//获取密码
	$rem=$_POST["checkbox"];//是否记住密码？
	$login=$_POST["submit"];
	
	if($_POST['enter']<>''){
		if($userName==""){
			echo "<script>alert('请输入用户名!')</script>";
			echo "<script>javascript:history.back()</script>";   
		}elseif($pass==""){
			echo "<script>alert('请输入密码!')</script>";
			echo "<script>javascript:history.back()</script>";   
			}
		else{
	    //查询数据库
			
			$sql="select * from user_base_information where user_name ='$userName' and password='$pass';";
			$result=mysql_query($sql);
			if(mysql_fetch_row($result)==true){
				$sql="select * from online where user='$userName';";
                $result=mysql_query($sql);
				
				if(mysql_num_rows($result) == 0){
                	$t =time();
                	$sql="insert into online values('$userName','$t')";
                	mysql_query($sql);
					
					$sql="select * from user_base_information where user_name='$userName';";
					$res=mysql_query($sql);
					
					$time=mysql_result($res,0,'near_login_date');
					setcookie("near_login_date",$time);
					 
						
					mysql_query("update user_base_information set near_login_date=NOW() where user_name='$userName'");
						
					setcookie("username", $userName);
					if($rem=="checkbox")
 						setcookie("passwd", $pass);
					header("refresh:0; url=main.php");
				}else{
					echo "<script>alert('用户已经登录!')</script>"; 
					echo "<script>javascript:history.back()</script>";
				}
			}else{
					echo "<script>alert('用户或密码不正确!')</script>";    
	       			echo "<script>javascript:history.back()</script>";
				}
		}
	}
	
?>