Problem in login session
I have a sample code of session condition if the user is already login and i have a separate code for login page.. I don't know how can i add the code of seesion to my login code
here is the code for session:
code in loginv05.phpCode://Checks if user is already logged in if(isset($_SESSION['USER_ID'])){ //CHECK IF USERS_ID DOES EXIST IN THE DATABASE $session = $_SESSION['USER_ID']; $user_query = mysql_query("SELECT tbllogin FROM $db_name WHERE ID = '$session'"); //Checks if user exists, if it does, echo you are already logged in, else destroy session if(mysql_num_rows($user_query) != 0){ echo "You can not log in if you are already!\n"; }else { session_destroy(); //echo the login form as well or just do a page refresh as their ID didn't exist in database } else { // DO LOGIN FORM AND PROCESSING HERE ETC }
Code:<?php session_start(); //require_once 'conn.php'; $db_name="dspi"; mysql_connect("localhost", "root", "") or die("Cannot connect to server"); mysql_select_db("$db_name")or die("Cannot select DB"); $department = mysql_real_escape_string($_POST['department']); $username = mysql_real_escape_string($_POST['username']); $sql=mysql_query("SELECT `Department`, `Username` FROM `tbllogin` WHERE `Department` = '{$department}' AND Username = '{$username}'") or die(mysql_error()); $ct = mysql_num_rows($sql); if($ct == 1) { $row = mysql_fetch_assoc($sql); if($row['Department']=='Accounting') { header('location: accounting.php'); } elseif($row['Department']=='Engineering') { header('location: engineering.php'); } elseif($row['Department']=='Finishing_Goods') { header('location: finishing_goods.php'); } elseif($row['Department']=='HRAD') { header('location: HRAD.php'); } elseif($row['Department']=='MIS') { header('location: MIS.php'); } elseif($row['Department']=='Packaging_and_Design') { header('location:packaging_design.php'); } elseif($row['Department']=='Production') { header('location:production.php'); } elseif($row['Department']=='Purchasing_Logistic') { header('location:purchasing_logistic.php'); } elseif($row['Department']=='QA_and_Technical') { header('location:QA_technical.php'); } elseif($row['Department']=='Supply_Chain') { header('location:supply_chain.php'); } else { header('location:loginv01.php'); echo"Incorrect Username or Department"; } } ?> <!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> function searchKeyPress(e) { // look for window.event in case event isn't passed in if (window.event) { e = window.event; } if (e.keyCode == 13) { document.getElementById('submit').focus(); } } </script> <style type="text/css"> <!-- BODY { background-image: url(layout_image/bgroundv03.png); background-attachment: fixed; } #Layer1 { position:absolute; width:200px; height:115px; z-index:1; left: 82px; top: 95px; } #Layer2 { position:absolute; width:229px; height:49px; z-index:1; left: 441px; top: 262px; } #Layer3 { position:absolute; width:186px; height:32px; z-index:2; left: 452px; top: 275px; } #Layer4 { position:absolute; width:82px; height:35px; z-index:3; left: 516px; top: 320px; } #Layer5 { position:absolute; width:60px; height:29px; z-index:4; left: 524px; top: 328px; } #Layer6 { position:absolute; width:130px; height:55px; z-index:5; left: 319px; top: 208px; } #Layer7 { position:absolute; width:230px; height:46px; z-index:6; left: 441px; top: 216px; } #Layer8 { position:absolute; width:200px; height:115px; z-index:7; left: 45px; top: 100px; } #Layer9 { position:absolute; width:59px; height:28px; z-index:7; left: 70px; top: 96px; } #Layer10 { position:absolute; width:216px; height:30px; z-index:7; left: 453px; top: 228px; } --> </style> </head> <body> <form id="form1" name="form1" method="post" action=""> <div id="Layer3"> <select name="department" onkeypress="searchKeyPress(event);"> <option>Choose your Department. . . . . . </option> <option value="Accounting" <?php if($_POST['department'] == 'Accounting') echo "selected='selected'"; ?>>Accounting</option> <option value="Engineering" <?php if($_POST['department'] == 'Engineering') echo "selected='selected'"; ?>>Engineering</option> <option value="Finishing_Goods" <?php if($_POST['department'] == 'Finishing_Goods') echo "selected='selected'"; ?>>Finishing Goods</option> <option value="HRAD" <?php if($_POST['department'] == 'HRAD') echo "selected='selected'"; ?>>HRAD</option> <option value="MIS" <?php if($_POST['department'] == 'MIS') echo "selected='selected'"; ?>>MIS</option> <option value="Packaging_and_Design" <?php if($_POST['department'] == 'Packaging_and_Design') echo "selected='selected'"; ?>>Packaging and Design</option> <option value="Production" <?php if($_POST['department'] == 'Production') echo "selected='selected'"; ?>>Production</option> <option value="Purchasing_Logistic" <?php if($_POST['department'] == 'Purchasing_Logistic') echo "selected='selected'"; ?>>Purchasing and Logistics</option> <option value="QA_and_Technical" <?php if($_POST['department'] == 'QA_and_Technical') echo "selected='selected'"; ?>>QA and Technical</option> <option value="Supply_Chain" <?php if($_POST['department'] == 'Supply_Chain') echo "selected='selected'"; ?>>Supply Chain</option> </select> </div> <div id="Layer5"> <input type="Submit" name="submit" value="Submit" id="submit" onclick="doSomething();"/> </div> <div id="Layer2"><img src="layout_image/subframev02.png" width="229" height="50" /></div> <div id="Layer4"><img src="layout_image/subframev02.png" width="80" height="46" /></div> <div id="Layer6"><img src="layout_image/userv01.png" width="131" height="62" /></div> <div id="Layer7"><img src="layout_image/subframev02.png" width="229" height="50" /></div> <div id="Layer10"> <input name="username" type="text" size="30" /> </div> </form> </body> </html>
CSS Codes
Reply With Quote
Bookmarks