PHP PageMaster Examples

Example #1

File: delete_user.php Project: pandalion98/PLDT

<?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');
}

Example #2

File: session_login.php Project: pandalion98/PLDT

<?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');
}

Example #3

File: checkAddNode.php Project: pandalion98/PLDT

<?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');
}

Example #4

File: delete_node.php Project: pandalion98/PLDT

<?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');
}

Example #5

File: check_report.php Project: pandalion98/PLDT

<?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)) {

Example #6

File: session_logout.php Project: pandalion98/PLDT

<?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();

Example #7

File: check_register.php Project: pandalion98/PLDT

<?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'] = "******";

Example #8

File: checkAddCab.php Project: pandalion98/PLDT

<?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');
}