<?php require_once 'includes/database_master.inc.php'; require_once 'includes/page_master.inc.php'; require_once 'includes/session_master.inc.php'; $database_master = new DatabaseMaster(); $page_master = new PageMaster(); $session_master = new SessionMaster(); $query = "DELETE FROM users WHERE idNo=" . $_GET['idNo']; if ($database_master->queryUpdate($query)) { $page_master->redirectUser('index.php?user_delete=success&user='******'idNo']); } else { $page_master->redirectUser('index.php?user_delete=failed'); }
<?php require_once 'includes/database_master.inc.php'; require_once 'includes/page_master.inc.php'; require_once 'includes/session_master.inc.php'; $database_master = new DatabaseMaster(); $page_master = new PageMaster(); $idNo = $_POST['idNo']; $idNo = $database_master->escapeString($idNo); $password = $_POST['password']; $password = $database_master->escapeString($password); $query = "SELECT idNo FROM users WHERE idNo = '{$idNo}' AND password = SHA('{$password}')"; $queryResult = $database_master->querySelect($query); if (is_array($queryResult) && count($queryResult)) { $session_master = new SessionMaster(); $session_master->logUserIn($idNo); $page_master->redirectUser("index.php"); } else { $page_master->redirectUser('index.php?error=login'); }
<?php require_once 'includes/database_master.inc.php'; require_once 'includes/session_master.inc.php'; require_once 'includes/page_master.inc.php'; $database_master = new DatabaseMaster(); $page_master = new PageMaster(); $session_master = new SessionMaster(); $cabinetNo = $_POST['cabinetNo']; $nodeName = $_POST['nodeName']; $nodeType = $_POST['nodeType']; $sinNumber = $_POST['sinNumber']; $ElectricMeterNo = $_POST['ElectricMeterNo']; $office = $_POST['office']; $nodeLocation = $_POST['nodelocation']; $cabinetNo = $database_master->escapeString($cabinetNo); $nodeName = $database_master->escapeString($nodeName); $sinNumber = $database_master->escapeString($sinNumber); $ElectricMeterNo = $database_master->escapeString($ElectricMeterNo); $office = $database_master->escapeString($office); $nodeLocation = $database_master->escapeString($nodeLocation); $nodeName = $database_master->escapeString($nodeName); $query = "INSERT INTO node (nodeName, sinNo, electricMeterNo, node_type, cabinetNo, central_officeName, nodeLocation)\n\t\t\t VALUES ('{$nodeName}','{$sinNumber}', '{$ElectricMeterNo}','{$node_type}','{$cabinetNo}','{$office}','{$nodeLocation}')"; if ($database_master->queryUpdate($query)) { $page_master->redirectUser('index.php?add_node=success'); } else { $page_master->redirectUser('index.php?add_node=failed'); }
<?php require_once 'includes/database_master.inc.php'; require_once 'includes/page_master.inc.php'; require_once 'includes/session_master.inc.php'; $database_master = new DatabaseMaster(); $page_master = new PageMaster(); $session_master = new SessionMaster(); $query = "DELETE FROM node WHERE nodeName='" . $_GET['node'] . "'"; if ($database_master->queryUpdate($query)) { $page_master->redirectUser('index.php?node_delete=success'); } else { $page_master->redirectUser('index.php?node_delete=failed'); }
$nodeName = 'null'; } $faultDescription = $_POST['faultDescription']; $faultDescription = $database_master->escapeString($faultDescription); $redirectPage = 'index.php?'; if ($database_master->checkIdNo($idNo)) { $errors['idNo'] = $idNo; $redirectPage .= 'id=' . $idNo; } if (isset($_POST['nodeName']) && $database_master->checkNodeName($nodeName)) { $errors['nodeName'] = $nodeName; $redirectPage .= 'nodeName=' . $nodeName; } if (isset($_POST['cabinetNo']) && $database_master->checkCabinetNo($cabinetNo)) { $errors['cabinetNo'] = $cabinetNo; $redirectPage .= 'cabinetNo=' . $cabinetNo; } if (empty($title) || empty($nodeName) && empty($cabinetNo)) { $errors['empty'] = "true"; $redirectPage .= '&error=empty'; } if (empty($errors)) { $query = "INSERT INTO reports VALUES((SELECT MAX(reportId)+1 FROM reports as r),\n\t\t '{$title}',\n\t\t {$idNo}, \n\t\t {$idNoFrom}, \n\t\t {$nodeName}, \n\t\t {$cabinetNo}, '{$faultDescription}', now(), 'pending')"; if ($database_master->queryUpdate($query)) { $page_master->redirectUser('index.php?add_report=success'); } else { $page_master->redirectUser('index.php?add_report=failed'); } } else { $page_master->redirectUser($redirectPage); }
<?php require_once 'includes/database_master.inc.php'; require_once 'includes/page_master.inc.php'; require_once 'includes/session_master.inc.php'; $database_master = new DatabaseMaster(); $session_master = new SessionMaster(); $session_master->logUserOut(); $page_master = new PageMaster(); $page_master->redirectUser();
$redirectPage = 'index.php?'; if (!$database_master->checkIdNo($idNo)) { $errors['idNo'] = $idNo; $redirectPage .= 'id=' . $idNo; } if ($password != $repass) { $errors['password'] = "******"; $redirectPage .= '&password=nomatch'; } if (empty($idNo) || empty($password) || empty($repass) || empty($user_type) || empty($position)) { $errors['empty'] = "true"; $redirectPage .= '&error=empty'; } if (!$database_master->checkUser_type($user_type)) { $errors['user_type'] = $user_type; $redirectPage .= '&user_type=' . $user_type; } if (!$database_master->checkOffice($office)) { $errors['office'] = $office; $redirectPage .= '&office=' . $office; } if (empty($errors)) { $query = "INSERT INTO users VALUES ('{$idNo}', '{$user_type}', SHA('{$password}'), '{$firstName}', '{$lastName}', \n\t\t\t'{$position}', '{$office}')"; if ($database_master->queryUpdate($query)) { $page_master->redirectUser('index.php?register=success&new_user='******'index.php?register=failed'); } } else { $page_master->redirectUser($redirectPage); }
<?php require_once 'includes/database_master.inc.php'; require_once 'includes/session_master.inc.php'; require_once 'includes/page_master.inc.php'; $database_master = new DatabaseMaster(); $page_master = new PageMaster(); $session_master = new SessionMaster(); $cabinetNo = $_POST['cabinetNo']; $cabinetType = $_POST['cabinetType']; $cabinetNo = $database_master->escapeString($cabinetNo); $cabinetType = $database_master->escapeString($cabinetType); $query = "INSERT INTO cabinet (cabinetNo, cabinet_type) VALUES ('{$cabinetNo}', '{$cabinetType}')"; if ($database_master->queryUpdate($query)) { $page_master->redirectUser('index.php?cab_add=success'); } else { $page_master->redirectUser('index.php?cab_add=failed'); }