<?php
/*
* error_reporting ( E_ALL );
* ini_set ( 'display_errors', '1' );
*/
extract($_REQUEST);
if (isset($_POST['submit'])) {
include 'includes/connection.php';
$db = new connection();
include 'controller/systemUserController.php';
$sys_user_ob = new SystemUserConrtoller();
$resContent = $sys_user_ob->loginAction($_REQUEST);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Login</title>
<link href="css/bootstrap.css" rel="stylesheet">
<!-- Custom CSS -->
<?php
/*
* error_reporting(E_ALL);
* ini_set('display_errors', '1');
*/
include 'includes/connection.php';
include 'controller/systemUserController.php';
include 'controller/systemRoleController.php';
extract($_REQUEST);
$db = new connection();
$sys_user_ob = new SystemUserConrtoller();
$sys_role_ob = new SystemRoleConrtoller();
/**
* Action Declare
* default action 0=add,1=edit,2=delete
*/
if (isset($_POST['submit'])) {
if ($action == 0) {
$resContent = $sys_user_ob->insertAction($_REQUEST);
}
if ($action == 1) {
$resContent = $sys_user_ob->updateAction($_REQUEST);
}
}
if (isset($_REQUEST['pk']) && $pk != "") {
$action = 1;
$tableDataRes = $sys_user_ob->selectAction("sys_user_id={$pk}");
$tableDatas = $tableDataRes[0];
} else {
$pk = "";
<?php
ob_start();
session_start();
include 'includes/connection.php';
include 'controller/systemUserController.php';
include 'controller/systemRoleController.php';
extract($_REQUEST);
$sys_user_ob = new SystemUserConrtoller();
if (isset($_REQUEST['pk']) && $pk != "") {
$db->deleteData($sys_user_ob->table_name, " sys_user_id={$pk}");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Exam Admin-Panel</title>
<?php
include 'includes/header_tag.php';
?>
</head>
public function loginAction($params)
{
$db = new connection();
$user_name = $params['user_name'];
$tableName = $this->table_name;
$password = $db->encodeData($params['password']);
$rawQry = "SELECT * FROM `system_user` WHERE 1 and `flag`=0 and `user_name`='{$user_name}' and `password`='{$password}'";
$res = $db->rawQry($rawQry);
if ($res == true) {
$sys_user = new SystemUserConrtoller();
$user_data = $sys_user->selectAction($where = " `flag`=0 and `user_name`='{$user_name}' and `password`='{$password}'");
$_SESSION['sys_user_id'] = $user_data[0]['sys_user_id'];
$_SESSION['sys_user_name'] = $user_data[0]['sys_name'];
$_SESSION['sys_role_id'] = $user_data[0]['sys_role_id'];
header("Location:index.php");
} else {
$msg = "Invalid Username and Password!";
return $msg;
}
}
