Hello,
I have one table with user information contain unique ID and password. When user enters the ID and password in php login form, my php code should check that ID is already present or not. If it is present, my php code should check that the password is same as password for that ID in database. If it is same then "welcome.php" page should be open or "Invalid user ID or password " msg should be display.
It is my live project, so please reply as soon as possible.
Thanks,
Pooja.
Jump to PostPooja,
This is a simple login script you are asking for. Why don't you try few lines of code and post your errors here?
Jump to Post<? ob_start(); extract($_POST); extract($_REQUEST); session_start(); $con=mysql_connect('localhost','root',''); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("databasename", $con); if($_POST['username']!='' && $_POST['password']!='') { //echo $url;exit; $select=mysql_query("select * from user_registration where username='$username' and password='$password'"); $count=mysql_num_rows($select); if($count>0) { $fetch=mysql_fetch_array($select); $_SESSION['user_id']=$fetch['auto_id']; header("location:my_account.php"); } else { $exists=1; } } ?> <!DOCTYPE html …
Pooja,
This is a simple login script you are asking for. Why don't you try few lines of code and post your errors here?
<?
ob_start();
extract($_POST);
extract($_REQUEST);
session_start();
$con=mysql_connect('localhost','root','');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("databasename", $con);
if($_POST['username']!='' && $_POST['password']!='')
{
//echo $url;exit;
$select=mysql_query("select * from user_registration where username='$username' and password='$password'");
$count=mysql_num_rows($select);
if($count>0)
{
$fetch=mysql_fetch_array($select);
$_SESSION['user_id']=$fetch['auto_id'];
header("location:my_account.php");
}
else
{
$exists=1;
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script language="javascript">
function validate()
{
var uname=window.document.login.username.value;
if(window.document.login.username.value=='')
{
alert("enter username");
window.document.login.username.focus();
return false;
}
if(window.document.login.password.value=='')
{
alert("enter password");
window.document.login.password.focus();
return false;
}
else
{
return true;
}
}
</script>
</head>
<body>
<form name="login" action="" method="post" onsubmit="return validate();">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" >
<? if($exists==1)
{
?>
<tr height="30">
<td colspan="2"><span>Invalid Username or password<span></td>
</tr>
<?
}
?>
<tr height="30">
<td colspan="2"><input type="text" name="username" value="" /></td>
</tr>
<tr height="30">
<td colspan="2"><input type="passowrd" name="password" value="" /></td>
</tr>
<tr>
<td height="50"><br />
</td>
<td ><input type="submit" value="submit" name="submit"/></td>
</tr>
</table>
</form>
</body>
</html>change the connection settings and try it
Thanks, but where is your code.
Pooja,
This is a simple login script you are asking for. Why don't you try few lines of code and post your errors here?
Thanks, but where is your code.
He meant YOUR code. Guidelines ask that you provide your own code first as opposed to asking others to do all the work for you. It is unfortunate that somebody has felt it necessary to provide a complete solution, thereby circumventing the learning process. Oh well.
Actually, at the first sight I didnt understand his meaning.Thats why I am asking such question.
Second, I tried it form two days ,but i m fail to do it.Thats why I want fresh code.I am not expecting that members should do all work for me.
Thank,
Pooja.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.