login.php
<?php
if($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['submit']))
{
$response = validate_user($_POST['username'],$_POST['pass']);
}
?>
<form method="POST" action="login.php">
<fieldset>
<div id="log">
<?php
if(!empty($response)){
echo "<p id='login-header'>". $response."</p>";
} else {
echo "<p id='login-header'>You must login first!</p>";
}
?>
<p class="pad-top-bottom">
<label for = "login-username" id="username">Username</label>
<input type= "text" id = "login-username" name="username" class="round username-password">
<p class="hint">Input your company ID</p>
</p>
<p class="pad-top-bottom">
<label for = "login-password" id="password">Password</label>
<input type= "password" id = "login-password" name="pass" class="round username-password">
<p class="hint">Input your password</p>
</p>
<p class="pad-top-bottom">
<input type= "checkbox" id = "login-checkbox">
<label for = "login-checkbox" id="login-checkbox-label" class="text-pad">Keep me login</label>
</p>
<input type = "submit" class = "blue icon-left round" value = "Login" name = "submit">
</div>
</fieldset>
</form>
function validate_user()
function validate_user($username,$password){
$username = append_slash($username);
$password = append_slash($password);
$password = md5($password);
if(!$username | !$password){
clear_session_cookies();
return "Username/Password is blank.";
}
$sql = "SELECT ";
$sql .= " a.cUserID AS cUserID,";
$sql .= " CONCAT(b.cFirstName,' ',b.cLastName) AS cFullName,";
$sql .= " (SELECT cBranchDept FROM muti_tbl_genbranchdept WHERE cBranchDeptID = (SELECT cBranchDeptID FROM muti_tbl_empbranchdept ";
$sql .= " WHERE cEmpID = '{$username}' AND dDateEffect <= CURDATE() ORDER BY dDateEffect DESC LIMIT 1 )) AS cBranchDept,";
$sql .= " a.cAccessLevel,c.cBranchDeptID,";
$sql .= " (SELECT cBusUnit FROM muti_tbl_genbusinessunit WHERE cBuCode = ";
$sql .= " (SELECT cBuCode FROM muti_tbl_genbranchdept WHERE cBranchDeptID = ";
$sql .= " (SELECT cBranchDeptID FROM muti_tbl_empbranchdept WHERE cEmpID = '{$username}' AND dDateEffect <=CURDATE() ";
$sql .= " ORDER BY dDateEffect DESC LIMIT 1))) AS cBusinessUnit";
$sql .= " FROM muti_tbl_users a,";
$sql .= " muti_tbl_empinfo b, ";
$sql .= " muti_tbl_empbranchdept c WHERE a.cUserID = b.cEmpID AND c.cEmpID = b.cEmpID AND a.cUserID = '{$username}'";
$sql .= " AND a.cPassword = '{$password}' AND a.lEnabled = 0 LIMIT 1";
$result = mysql_query($sql) or die(mysql_error());
$a = mysql_num_rows($result);
if($a == 0){
//clear_session_cookies();
return 'Invalid username/password';
} else {
while($res = mysql_fetch_array($result)) {
session_start();
$_SESSION['userid'] = $res["cUserID"];
$_SESSION['cFullName'] = $res["cFullName"];
$_SESSION['cAccessLevel'] = $res["cAccessLevel"];
session_regenerate_id(true);
session_write_close();
[b]header("Location: controlpanel.php");
exit();[/b]
}
}
}
Whenever I successfully login it shows a blank page and still in login.php. I search the internet but still no luck.
Any help will be much appreciated!
Thanks,
Joery

New Topic/Question
Reply




MultiQuote






|