<?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(); $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/page_master.inc.php'; require_once 'includes/session_master.inc.php'; $database_master = new DatabaseMaster(); $page_master = new PageMaster(); $session_master = new SessionMaster(); $title = $_POST['title']; $title = $database_master->escapeString($title); $idNo = $_POST['idNo']; $idNo = $database_master->escapeString($idNo); $idNoFrom = $_SESSION['idNo']; $idNoFrom = $database_master->escapeString($idNoFrom); if (isset($_POST['nodeName'])) { $nodeName = $_POST['nodeName']; $nodeName = "'" . $database_master->escapeString($nodeName) . "'"; $cabinetNo = 'null'; } else { $cabinetNo = $_POST['cabinetNo']; $cabinetNo = "'" . $database_master->escapeString($cabinetNo) . "'"; $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)) {
<?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(); $title = $_POST['title']; $title = $database_master->escapeString($title); $idNo = $_POST['idNo']; $idNo = $database_master->escapeString($idNo); $idNoFrom = $_SESSION['idNo']; $idNoFrom = $database_master->escapeString($idNoFrom); if (isset($_POST['nodeName'])) { $nodeName = $_POST['nodeName']; $nodeName = "'" . $database_master->escapeString($nodeName) . "'"; $cabinetNo = 'null'; } else { $cabinetNo = $_POST['cabinetNo']; $cabinetNo = "'" . $database_master->escapeString($cabinetNo) . "'"; $nodeName = 'null'; } if (isset($_POST['deadlineDate'])) { $deadlineDate = $_POST['deadlineDate']; $deadlineDate = $database_master->escapeString($deadlineDate); $deadlineDate = strtotime($deadlineDate); $deadlineDate = date('Y-m-d', $deadlineDate); } else { $deadlineDate = $_POST['dlYear'] . '-' . $_POST['dlMonth'] . '-' . $_POST['dlDay']; $deadlineDate = $database_master->escapeString($deadlineDate);
<?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(); $idNo = $_POST['idno']; $idNo = $database_master->escapeString($idNo); $firstName = $_POST['firstname']; $firstName = $database_master->escapeString($firstName); $lastName = $_POST['lastname']; $lastName = $database_master->escapeString($lastName); $password = $_POST['password']; $password = $database_master->escapeString($password); $repass = $_POST['repass']; $repass = $database_master->escapeString($repass); $user_type = $_POST['user_type']; $user_type = $database_master->escapeString($user_type); $office = $_POST['office']; $office = $database_master->escapeString($office); $position = $_POST['position']; $position = $database_master->escapeString($position); $redirectPage = 'index.php?'; if (!$database_master->checkIdNo($idNo)) { $errors['idNo'] = $idNo; $redirectPage .= 'id=' . $idNo; } if ($password != $repass) { $errors['password'] = "******";
<?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'); }