newphpcoder
12-07-2011, 11:34 AM
Hi
I have a login page from login.php login.tpl
and after i login it will redirected to index.php which has a four templates.
I want to happen is to merge the login and index.php I mean the index.php looks like a backgound or greyed out color..I mean the login form looks like a pop up...they could not insert data in index.php if he did not login.
this is my login.php
<?php
include 'config.php';
session_start();
//if (isset($_SESSION['logged_in'])) {
// header('Location:index.php');
// die();
// }
if (isset($_POST['submit'])) {
$username=$_POST['username'];
$password=($_POST['password']);
$sql = "SELECT username, password FROM pay_login WHERE username='$username' AND password='$password'";
$rs = $conn2->Execute($sql);
if($rs==1){
$_SESSION['logged_in'] = true;
header("location:index.php");
}
else {
echo "<center>";
echo "Wrong Username or Password";
echo "</center>";
}
}
$smarty->display('login.tpl');
?>
login.tpl
<!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=utf-8" />
<title>Log In Page</title>
<style type="text/css">
#form1 h2 strong {
color: #06F;
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
}
#form1 p label {
color: #009;
}
</style>
</head>
<body onload="document.form1.username.focus()">
<table width="300" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" style="position: absolute; margin-left: 350px; top: 150px;">
<tr>
<form name="form1" method="post" action="">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong> Login Page</strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input name="username" type="text" id="username" size="23"></td>
</tr>
<tr>
<td width="78">Password</td>
<td width="6">:</td>
<td width="294"><input name="password" type="password" id="password" size="25"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> <input type="submit" name="submit" value="Login"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</div>
</body>
</html>
and here is the index.php
<?php
session_regenerate_id(true);
include 'config.php';
$currentEmpID = $_SESSION['empID'];
if (!isset($_SESSION['empID'])) {
$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ' , FNAME, ' ', MI) AS FULLNAME FROM PERSONAL ORDER BY LNAME ASC";
$recPersonal = $conn->Execute($sql);
session_register('empID');
$_SESSION['empID'] = $recPersonal->fields['EMP_ID'];
}
$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ' , FNAME, ' ', MI) AS FULLNAME FROM PERSONAL ORDER BY LNAME ASC";
$recPersonalNav = $conn->GetAll($sql);
$smarty->assign('personalAll', $recPersonalNav);
$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ', FNAME, ' ', MI, '.') AS FULLNAME FROM PERSONAL
WHERE EMP_ID='$currentEmpID'";
$recPersonalHead = $conn->Execute($sql);
$fullName = $recPersonalHead->fields["FULLNAME"];
$smarty->assign('empid', $currentEmpID);
$smarty->assign('fullname', $fullName);
session_write_close();
$smarty->display('header.tpl');
$smarty->display('left.tpl');
$smarty->display('empPayroll.tpl');
$smarty->display('footer.tpl');
exit();
?>
I don't know if my idea is possible..
Thank you
I have a login page from login.php login.tpl
and after i login it will redirected to index.php which has a four templates.
I want to happen is to merge the login and index.php I mean the index.php looks like a backgound or greyed out color..I mean the login form looks like a pop up...they could not insert data in index.php if he did not login.
this is my login.php
<?php
include 'config.php';
session_start();
//if (isset($_SESSION['logged_in'])) {
// header('Location:index.php');
// die();
// }
if (isset($_POST['submit'])) {
$username=$_POST['username'];
$password=($_POST['password']);
$sql = "SELECT username, password FROM pay_login WHERE username='$username' AND password='$password'";
$rs = $conn2->Execute($sql);
if($rs==1){
$_SESSION['logged_in'] = true;
header("location:index.php");
}
else {
echo "<center>";
echo "Wrong Username or Password";
echo "</center>";
}
}
$smarty->display('login.tpl');
?>
login.tpl
<!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=utf-8" />
<title>Log In Page</title>
<style type="text/css">
#form1 h2 strong {
color: #06F;
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
}
#form1 p label {
color: #009;
}
</style>
</head>
<body onload="document.form1.username.focus()">
<table width="300" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" style="position: absolute; margin-left: 350px; top: 150px;">
<tr>
<form name="form1" method="post" action="">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong> Login Page</strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input name="username" type="text" id="username" size="23"></td>
</tr>
<tr>
<td width="78">Password</td>
<td width="6">:</td>
<td width="294"><input name="password" type="password" id="password" size="25"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> <input type="submit" name="submit" value="Login"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</div>
</body>
</html>
and here is the index.php
<?php
session_regenerate_id(true);
include 'config.php';
$currentEmpID = $_SESSION['empID'];
if (!isset($_SESSION['empID'])) {
$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ' , FNAME, ' ', MI) AS FULLNAME FROM PERSONAL ORDER BY LNAME ASC";
$recPersonal = $conn->Execute($sql);
session_register('empID');
$_SESSION['empID'] = $recPersonal->fields['EMP_ID'];
}
$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ' , FNAME, ' ', MI) AS FULLNAME FROM PERSONAL ORDER BY LNAME ASC";
$recPersonalNav = $conn->GetAll($sql);
$smarty->assign('personalAll', $recPersonalNav);
$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ', FNAME, ' ', MI, '.') AS FULLNAME FROM PERSONAL
WHERE EMP_ID='$currentEmpID'";
$recPersonalHead = $conn->Execute($sql);
$fullName = $recPersonalHead->fields["FULLNAME"];
$smarty->assign('empid', $currentEmpID);
$smarty->assign('fullname', $fullName);
session_write_close();
$smarty->display('header.tpl');
$smarty->display('left.tpl');
$smarty->display('empPayroll.tpl');
$smarty->display('footer.tpl');
exit();
?>
I don't know if my idea is possible..
Thank you