Code: Select all
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form name="form1" method="post" action="checklogin.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong>Student Login </strong></td>
</tr>
<tr>
<td width="78">Student ID</td>
<td width="6">:</td>
<td width="294"><input name="myid" type="text" id="myid"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input name="mypassword" type="password" id="mypassword"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr></table></td></form></tr></table>
Code: Select all
<?php
$host="localhost";
$username="root";
$password="";
$db_name="assignment_db1";
$tbl_name="student";
mysql_connect("$host", "$username", "$password")or die("Can't Connect");
mysql_select_db("$db_name")or die("Can't Select DataBase");
$myusername=$_POST['myid'];
$mypassword=$_POST['mypassword'];
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE Id='$myusername' and Password='$mypassword'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count==1){
session_register("myid");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Student ID or Password";
}
?>
Code: Select all
<?session_start();
if(!session_is_registered("myid")){
header("location:main_login.php");
}
?>
<html>
<body>
Login Successful<br>
<? echo "Welcome" ?????????? ?> <==how do i display the user id here??
<p>
<a href="logout.php">Log Out!</a></p>
</body>
</html>