Jump to content

Creating different username's for the same login to enter different pages

dami

By dami
in PHP Coding Help

Recommended Posts

dami Newbie

dami

Posted
Posted

Hi,

I'm trying to create a separate usernames with the same login page using php and MySQL. I have tried adding different things to my login code for it to work but no progress. Basically i want to create something like this:

A staff would be able to have a username and password and be directed to the staff page and the student would be able to have a username and password and be directed to the student page and the admin would be able to have a username and password and be directed to the admin page. But what i'm getting right now is everyone that is a staff, admin or student is being directed to only the admin page.

 

This is my code if anyone can help me out please that would be really nice..

 

checklogin.php

<?php
ob_start();
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="amy"; // Mysql password
$db_name="pa"; // Database name
$tbl_name="user"; // Table name
// Get info from the session

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Define $myusername and $mypassword and $myusertype
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
$myusertype=$_POST['myusertype'];


//$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and //password='$mypassword'";
//$result=mysql_query($sql);


$sql="SELECT user_type FROM $tbl_name WHERE username='$myusername' and password='$mypassword' and user_type ='$myusertype'");

//$result2=mysql_query($sql);


// Mysql_num_row is counting table row
$count=mysql_num_rows($result2);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1 ){
Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
session_register("myusertype");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}

//ob_end_flush();
?>

login_success.php

<?
// Check if session is not registered , redirect back to main page.
// Put this code in first line of web page.
session_start();
if(!session_is_registered(myusername)){
header("location:http://www.yahoo.com");
}
else  {
header("location:admin/index.php");
}
?>

<html>
<body>
Login Successful
</body>
</html>

 

main_login.php

<BODY BGCOLOR="Teal">
<table width="900" border="20" align="center" cellpadding="3" cellspacing="6" bgcolor="BLACK">
<tr>
<form name="form1" method="post" action="checklogin.php">
<td>
<table width="100%" border="0" cellpadding="30" cellspacing="5" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong>Member Login </strong></td>
</tr>
<tr>
<td width="10">Username</td>
<td width="10">:</td>
<td width="600"><input name="myusername" type="text" id="myusername"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input name="mypassword" type="text" id="mypassword"></td>

<tr>
<td width="10">Usertype</td>
<td width="10">:</td>
<td width="600"><input name="myusertype" type="text" id="myusertype"></td>
</tr>

</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr>
</BODY>
</table>
</td>
</form>
</tr>
</table>

 

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.