hi, I am brand new on PHP MySql please I need your help,
I make login page and it need to redirect if login member (member type in mysql data base) is admin to admin.php page or if login member is normal member it should redirect to member.php.
here is code.
<?php
session_start();
//Database Information
$dbhost = "localhost";
$dbname = "library";
$dbuser = "root";
$dbpass = "";
//Connect to database
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
//Checks if there is a login cookie
if(isset($_COOKIE['ID_my_site']))
//if there is, it logs you in and directes you to the members page
{
$username = $_COOKIE['ID_my_site'];
$pass = $_COOKIE['Key_my_site'];
$check = mysql_query("SELECT * FROM member WHERE mid = '$mid'")or die(mysql_error());
while($info = mysql_fetch_array( $check ))
{
if ($pass != $info['pass'])
{
}
else
{
}
}
}
//if the login form is submitted
if (isset($_POST['submit'])) { // if form has been submitted
// makes sure they filled it in
if(!$_POST['mid'] | !$_POST['pass']) {
die('You did not fill in a required field.');
}
// checks it against the database
if (!get_magic_quotes_gpc()) {
$_POST['email'] = addslashes($_POST['email']);
}
$check = mysql_query("SELECT * FROM member WHERE mid = '".$_POST['mid']."'")or die(mysql_error());
//Gives error if user dosen't exist
$check2 = mysql_num_rows($check);
if ($check2 == 0) {
die('That user does not exist in our database. <a target=_blank href=add.php>Click Here to Register</a>');
}
while($info = mysql_fetch_array( $check ))
{
$_POST['pass'] = stripslashes($_POST['pass']);
$info['pass'] = stripslashes($info['pass']);
$_POST['pass'] = md5($_POST['pass']);
//gives error if the password is wrong
if ($_POST['pass'] != $info['pass']) {
die('Incorrect password, please try again.');
}
else
{
// if login is ok then we add a cookie
$_POST['mid'] = stripslashes($_POST['mid']);
$hour = time() + 3600;
setcookie(ID_my_site, $_POST['mid'], $hour);
setcookie(Key_my_site, $_POST['pass'], $hour);
//then redirect them to the members area
header("Location: member.php");
}
}
}
else
{
// if they are not logged in
?>
<?php
}
?>
Last edited: 04-May-11 02:56 PM