w3 Tutorial, Web Tutorial
<?php
session_start();
//db connection
$nameserv = "localhost";
$username = "root";
$pass = "";
$dbname = "daniweb";
$conn = mysql_connect($nameserv,$username,$pass)or die(mysql_error());
$selectdb = mysql_select_db($dbname, $conn);
$login = $_POST['login'];
if(isset($login)){
$usrname = $_POST['username'];
$password = $_POST['password'];
$upass = MD5($password);
//validate input
if(empty($usrname)){
$msg = "Empty Username!<br />";
$a = 1;
}
if(empty($password)){
$msg .= "Empty Password!<br />";
$a = 1;
}
if($a != 1){
$sql = "SELECT *FROM login WHERE username = '".$usrname."' AND password = '".$upass."'";
$exec = mysql_query ($sql, $conn);
$count = mysql_num_rows($exec);
$data_login = mysql_fetch_array($exec);
echo mysql_error();
if($count == 0){
$msg .= "Login failed!";
}else{
session_register ($usrname);
$_SESSION['user'] = $usrname;
$msg .= "<span style='color : #0000FF'>Login Success!</span>";
}
}
}
?>
<!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>
<title>Login Form</title>
</head>
<body>
<h2>Login Form Example</h2>
<div style="margin : 10px; font-style : italic; color : #FF0000"><?php echo $msg;?></div>
<form method="POST" action="<?php $_SERVER['PHP_SELF'];?>">
<table>
<tr>
<td>Username</td>
<td>:</td>
<td><input type="text" name="username" value="<?php echo $usrname;?>" /></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input type="password" name="password"></input></td>
</tr>
<tr>
<td></td><td></td><td>
<input type="submit" name="login" class="button" value="Login" />
</td>
</tr>
</table>
</form>
</body>
</html>
Download