<?php include 'includes/admin-settings.php'; include '../includes/db.php'; include 'includes/global-admin-functions.php'; assessLogin($securityArrPublisher); $mysqli = new mysqli($DB_SERVER, $DB_USERNAME, $DB_PASSWORD, $DB_DATABASE); $stmt = $mysqli->prepare('SELECT DISTINCT(label) FROM route_geo WHERE is_waypoint = 1 OR is_destination = 1 order by label'); $stmt->execute(); //$result = $stmt->get_result(); $stmt->bind_result($label); $json = ''; $results = array(); $i = 0; while ($stmt->fetch()) { $results[$i]['label'] = $label; $i++; } $numRows = count($results); if ($numRows > 0) { $i = 0; $json .= '['; foreach ($results as $row) { $json .= '"' . $row["label"] . '"'; if ($i < $numRows - 1) { $json .= ','; } $i++; } $json .= ']'; }
<?php include 'includes/admin-settings.php'; include '../includes/db.php'; include 'includes/global-admin-functions.php'; assessLogin($securityArrAuthor); function getPages($DB_SERVER, $DB_USERNAME, $DB_PASSWORD, $DB_DATABASE) { $mysqli = new mysqli($DB_SERVER, $DB_USERNAME, $DB_PASSWORD, $DB_DATABASE); $stmt = $mysqli->prepare('SELECT pages.id, pages.title, is_live FROM pages ORDER BY pages.order'); $stmt->execute(); $stmt->bind_result($id, $title, $is_live); $results = array(); $i = 0; while ($stmt->fetch()) { $results[$i]['id'] = $id; $results[$i]['title'] = $title; $results[$i]['is_live'] = $is_live; $i++; } $stmt->close(); $mysqli->close(); return $results; } $pages = getPages($DB_SERVER, $DB_USERNAME, $DB_PASSWORD, $DB_DATABASE); ?> <html> <head> <title>List Pages</title> <?php include 'includes/head.php';
<?php include 'includes/admin-settings.php'; include '../includes/db.php'; include 'includes/global-admin-functions.php'; assessLogin($securityArr); ?> <html> <head> <?php include 'includes/head.php'; ?> </head> <body> <?php include 'includes/header.php'; ?> <section> <div class="row"> <div class="large-12 columns"> <h1> Home </h1> <?php if (in_array($_SESSION['adminRole'], $securityArrAuthor)) { ?> <p><a href="page-list.php">Pages</a></p>