config.php
========================
$dbHost = “localhost”;
$dbUser = “root”;
$dbPassword = “”;
$dbName= “hanzala”;
$con = mysql_connect($dbHost, $dbUser, $dbPassword);
mysql_select_db($dbName, $con);
session_start();
// echo “
”; print_r($_SESSION);
exit;
?>
action.php
=======================================================================
include “config.php”;
if(isset($_POST['submit']) &&
$_POST['submit'] == ‘Register’)
{
$name = $_POST['name'];
$password = $_POST['password'];
$city = $_POST['city'];
$state = $_POST['state'];
$sex = $_POST['sex'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$insert = “INSERT INTO test02 SET empName =
‘$name’, empPass = ‘$password’, empCity = ‘$city’, empState = ‘$state’,
empSex = ‘$sex’ empEmail = ‘$email’, empPhone = ‘$phone’”;
$result = mysql_query($insert);
if($result)
{
header(“Location:newpage.php?msg =
Registration Completed”);
exit;
}
}
if(isset($_POST['submit']) &&
$_POST['submit'] == ‘Update’)
{
$name = $_POST['name'];
$password = $_POST['password'];
$city = $_POST['city'];
$state = $_POST['state'];
$sex = $_POST['sex'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$queryupdate = “UPDATE test02 SET empName =
‘$name’, empPass = ‘$password’, empCity = ‘$city’, empState = ‘$state’,
empSex = ‘$sex’, empEmail = ‘$email’, empPhone = ‘$phone’”;
$result = mysql_query($queryupdate);
if($result)
{
header(“Location:newpage.php?msg = Update
Succefully”);
exit;
}
}
if(isset($_POST['submit']) &&
$_POST['submit'] == ‘Login’)
{
$name = $_POST['name'];
$password = $_POST['password'];
$queryLogin = “SELECT * FROM test02 WHERE
empName = ‘$name’ AND empPass = ‘$password’ “;
$resultLogin = mysql_query($queryLogin);
if(mysql_num_rows($resultLogin) > 0)
{
$row = mysql_fetch_assoc($resultLogin);
$_SESSION['empId'] = $row['empId'];
$_SESSION['empName'] = $row['empName'];
header(“Location: log_success.php”);
exit;
}
else
{
header(“Location: login.php?msg=Login
Failed”);
}
}
if(isset($_GET['submit']) &&
$_GET['submit'] == ‘logout’)
{
session_destroy();
header(“Location: login.php”);
}
?>
config.php
========================
$dbHost = “localhost”;
$dbUser = “root”;
$dbPassword = “”;
$dbName= “hanzala”;
$con = mysql_connect($dbHost, $dbUser, $dbPassword);
mysql_select_db($dbName, $con);
session_start();
// echo “
========================
$dbHost = “localhost”;
$dbUser = “root”;
$dbPassword = “”;
$dbName= “hanzala”;
$con = mysql_connect($dbHost, $dbUser, $dbPassword);
mysql_select_db($dbName, $con);
session_start();
// echo “
”; print_r($_SESSION); exit; ?> action.php ======================================================================= include “config.php”; if(isset($_POST['submit']) && $_POST['submit'] == ‘Register’) { $name = $_POST['name']; $password = $_POST['password']; $city = $_POST['city']; $state = $_POST['state']; $sex = $_POST['sex']; $email = $_POST['email']; $phone = $_POST['phone']; $insert = “INSERT INTO test02 SET empName = ‘$name’, empPass = ‘$password’, empCity = ‘$city’, empState = ‘$state’, empSex = ‘$sex’ empEmail = ‘$email’, empPhone = ‘$phone’”; $result = mysql_query($insert); if($result) { header(“Location:newpage.php?msg = Registration Completed”); exit; } } if(isset($_POST['submit']) && $_POST['submit'] == ‘Update’) { $name = $_POST['name']; $password = $_POST['password']; $city = $_POST['city']; $state = $_POST['state']; $sex = $_POST['sex']; $email = $_POST['email']; $phone = $_POST['phone']; $queryupdate = “UPDATE test02 SET empName = ‘$name’, empPass = ‘$password’, empCity = ‘$city’, empState = ‘$state’, empSex = ‘$sex’, empEmail = ‘$email’, empPhone = ‘$phone’”; $result = mysql_query($queryupdate); if($result) { header(“Location:newpage.php?msg = Update Succefully”); exit; } } if(isset($_POST['submit']) && $_POST['submit'] == ‘Login’) { $name = $_POST['name']; $password = $_POST['password']; $queryLogin = “SELECT * FROM test02 WHERE empName = ‘$name’ AND empPass = ‘$password’ “; $resultLogin = mysql_query($queryLogin); if(mysql_num_rows($resultLogin) > 0) { $row = mysql_fetch_assoc($resultLogin); $_SESSION['empId'] = $row['empId']; $_SESSION['empName'] = $row['empName']; header(“Location: log_success.php”); exit; } else { header(“Location: login.php?msg=Login Failed”); } } if(isset($_GET['submit']) && $_GET['submit'] == ‘logout’) { session_destroy(); header(“Location: login.php”); } ?>