here i am providing u the code.....for login page i have created..!!! provide the same code with using sessions...so that multiple logins with same user shouldnt happen...!!
1st is Login.php
<html>
<head>
<script language="JavaScript">
function echeck(str) {
var at="@"
var dot="."
var lat=str.indexOf(at)
var lstr=str.length
var ldot=str.indexOf(dot)
if (str.indexOf(at)==-1){
alert("Invalid ID")
return (false);
}
if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){
alert("Invalid ID")
return (false);
}
if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr){
alert("Invalid ID")
return (false);
}
if (str.indexOf(at,(lat+1))!=-1){
alert("Invalid ID")
return (false);
}
if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot){
alert("Invalid ID")
return (false);
}
if (str.indexOf(dot,(lat+2))==-1){
alert("Invalid ID")
return (false);
}
if (str.indexOf(" ")!=-1){
alert("Invalid ID")
return (false);
}
return (true);
}
function validation(){
if ((form.emailid.value == null)||(form.emailid.value == "")){
alert("Please Enter your Email ID (eg. name@abc.com)")
form.emailid.focus()
return (false);
}
if (echeck(form.emailid.value) == false){
form.emailid.value=""
form.emailid.focus()
return (false);
}
if (form.password.value == "")
{
alert ("please enter the password");
form.password.focus();
return (false);
}
return (true);
}
</script>
</head>
<body>
<form name="form" action="enter1.php" method="post" >
Email Id: <input type="text" name="emailid" tabindex="1" > <br><br>
Password: <input type="password" name="password" tabindex="2" ><br><br>
<input type="submit" value="Sign-In" name="submit" tabindex="3" onClick="return validation(this);">
</form>
<form action="password.php" method="post" name="pwd" >
<a href="http://localhost/vamsi/password.php" >Forget your Password? </a>
</form>
</body>
</html>
2nd page isss....checking whether valid id or not....n passing the message
<html>
<body>
<?php
$username=$_POST["emailid"];
$password=$_POST["password"];
$MYSQLCon=mysql_connect("localhost:3307","root","123");
if (!$MYSQLCon)
{
echo ("Connection not connected:".mysql_error())."<br>";
}
/*else
{
echo ("MYSQL Connection Connected"."<br>");
}
*/
if (!mysql_select_db("db_login", $MYSQLCon))
echo "Database not connected"."<br>";
/*
else
{
echo "Database connected"."<br>";
}
*/
/*
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
*/
//$result = $MYSQLCon->mysql_query("Select * from usernames where UserName = '$username' and Password = '$password' ");
//if(!$result)
$sql="Select * from sign where emailid = '$emailid' and password = '$password' ";
$result=mysql_query($sql);
if(!$result)
{
echo (" The query couldn\'t be run"."<br>");
exit;
}
/*else
{
echo "Query executed"."<br>";
}
*/
if(mysql_affected_rows()==0){
print "Email Id/password pair is invalid. Please try again."."<br>";
}
/*if($result->num_rows() >= 0)
{
//Everything went ok!
echo ("You can now see the secret message!");
echo ("You are the chosen one :D");
}
*/
else
{
//The password or/and username was not correct!
echo ("Congrats u really rocked the mailbox!"."<br>");
// echo ("You are not the chosen one ");
}
//$result = $MYSQLCon->query
/*if (!mysql_query($sqlquery,$MYSQLCon))
{
die('Error: ' . mysql_error());
}
else
{
echo "Successfully logged in!";
}
*/
mysql_close(MYSQLCon);
?>
</body>
</html>
.....
so please use the sessions n provide me the code...so that i will check with in time n submit it to my team leader:(