function pageController($dbc)
{
var_dump($_POST);
$error = '';
$errors = NULL;
$limit = 2;
$pageNumber = Input::has('pageNumber') ? Input::get('pageNumber') : 1;
$pageNumber = $pageNumber > 0 ? $pageNumber : 1;
$pageNumber = is_numeric($pageNumber) ? $pageNumber : 1;
$offset = $limit * $pageNumber - $limit;
if (!empty($_POST)) {
if (checkValues()) {
$errors = insertPark($dbc);
}
}
deletePark($dbc);
$stmt = $dbc->prepare("SELECT * FROM national_parks LIMIT :limit OFFSET :offset");
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->execute();
$parks = $stmt->fetchAll(PDO::FETCH_ASSOC);
$count = $dbc->query('SELECT COUNT(*) FROM national_parks;')->fetchColumn();
$maxPage = ceil($count / $limit);
$next = $pageNumber + 1;
$previous = $pageNumber - 1;
if ($pageNumber > $maxPage) {
$pageNumber = 1;
header("Location: national_parks.php?pageNumber=1");
die;
}
return array('pageNumber' => $pageNumber, 'previous' => $previous, 'next' => $next, 'parks' => $parks, 'maxPage' => $maxPage, 'error' => $error, 'errors' => $errors);
}
function pageController($dbc)
{
$errors = null;
if (!empty($_POST)) {
if (checkValues()) {
$errors = insertPark($dbc);
} else {
$message = "Invalid format. Please try again.";
$javascript = "<script type='text/javascript'>alert('{$message}');</script>";
echo $javascript;
}
}
deletePark($dbc);
// Count
$countAll = 'SELECT count(*) FROM national_parks';
$count_stmt = $dbc->query($countAll);
$count = $count_stmt->fetchColumn();
$limit = 2;
$max_page = ceil($count / $limit);
// Sanitizing
$page = Input::has('page') ? Input::get('page') : 1;
// grabs url value if exists, if not set to 1
$page = is_numeric($page) ? $page : 1;
// is value numeric, if not set to 1
$page = $page > 0 ? $page : 1;
// is value greater than zero, if not set to 1
$page = $page <= $max_page ? $page : $max_page;
// is value less than or equal maximum amount of pages, if not set to max page
// Offset
$offset = $page * $limit - $limit;
$selectAll = 'SELECT * FROM national_parks LIMIT :limit OFFSET :offset';
$stmt = $dbc->prepare($selectAll);
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$parks = $stmt->fetchAll(PDO::FETCH_ASSOC);
return array('page' => $page, 'parks' => $parks, 'errors' => $errors, 'max_page' => $max_page);
}
function pageController($dbc)
{
$errors = null;
if (!empty($_POST)) {
if (checkValues()) {
$errors = insertPark($dbc);
} else {
$message = "Invalid format. Do over!";
$javascript = "<script type='text/javascript'>alert('{$message}');<?script>";
echo $javascript;
}
}
deletePark($dbc);
// Count
$countAll = 'SELECT count(*) FROM national_parks';
$count_stmt = $dbc->query($countAll);
$count = $count_stmt->fetchColumn();
$limit = 2;
$max_page = ceil($count / $limit);
// Sanitizing
$page = Input::has('page') ? Input::get('page') : 1;
$page = $page > 1 ? $page : 1;
// Is value greater than 0 if not set to 1.
$page = is_numeric($page) ? $page : 1;
// If input not numeric then return 1.
$page = $page <= $max_page ? $page : $max_page;
// Offset
$offset = $page * $limit - $limit;
$selectAll = "SELECT * FROM national_parks LIMIT {$limit} OFFSET {$offset}";
$stmt = $dbc->query($selectAll);
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$parks = $stmt->fetchAll(PDO::FETCH_ASSOC);
return array('page' => $page, 'parks' => $parks, 'errors' => $errors, 'max_page' => $max_page, 'limit' => $limit);
}
} catch (Exception $e) {
$error = $e->getMessage();
array_push($errorsArray, $error);
}
$query = "DELETE FROM national_parks WHERE id = :delete_park";
$query = $dbc->prepare($query);
$query->bindValue(':delete_park', $delete_park, PDO::PARAM_INT);
$query->execute();
return $errorsArray;
}
var_dump($_POST);
if (Input::notEmpty('name') && Input::notEmpty('location') && Input::notEmpty('date_established') && Input::notEmpty('area') && Input::notEmpty('visitors') && Input::notEmpty('description')) {
var_dump($errorsArray);
$errorsArray = insertPark($dbc, $parks);
} elseif (Input::notEmpty('delete_park')) {
$errorsArray = deletePark($dbc);
}
var_dump($errorsArray);
var_dump($parks);
?>
<script type="text/javascript">
$(document).ready(function() {
"use strict";
$(".deletePark").click(function(a) {
var parkName = $(this).data('name');
var parkId = $(this).data('id');
if(confirm("Are you sure you want to delete "+parkName+"?")){
$("#delete-id").val(parkId);
$add_basket = $_POST["basket_number"];
}
if ($add_name_error == "" && $add_basket_error == "") {
$mysqli = new mysqli($GLOBALS["servername"], $GLOBALS["server_username"], $GLOBALS["server_password"], $GLOBALS["database"]);
$stmt = $mysqli->prepare("INSERT INTO parks_php (park_name, nr_of_baskets) VALUES (?, ?)");
$stmt->bind_param("si", $add_name, $add_basket);
$stmt->execute();
echo "Pargi lisamine õnnestus!";
$stmt->close();
$mysqli->close();
}
}
$park_list = getParkData();
//pargi kustutamiseks
if (isset($_GET["delete"])) {
deletePark($_GET["delete"]);
}
//PARide sisestamiseks
if (isset($_POST["pars"])) {
$park_id = $_GET["id"];
$nr_of_baskets = $_GET["nr"];
insertPars($park_id, $nr_of_baskets);
header("Location: insert_pars.php");
}
?>
<h2>Please, insert new disc golf park</h2>
<table class="center" border= 1>
<tr>
function pageController()
{
// Login information for db_connect.php.
require '../park_login.php';
// How we call to connect to the db via an outside file.
require '../db_connect.php';
// Calling file of functions for Input aka $_GET.
require '../Input.php';
// "&& is_numeric" prevents letter inputs into browser query string.
// "round(abs())" prevents decimals and negative numbers as input to browser query string.
$page = Input::has('page') && is_numeric(Input::get('page')) ? round(abs(Input::get('page'))) : 1;
// Prevents page numbers less than 1. 0 causes problems by making a negative $offset.
if ($page < 1) {
$page = 1;
}
// Prevents changes to browser query string for limit value. 'newlimit' is tied to the Change Rows button.
$limit = Input::has('newlimit') && is_numeric(Input::get('newlimit')) ? abs(intval(Input::get('newlimit'))) : 3;
$offset = $page * $limit - $limit;
// Gets the total number of rows of data.
function getNumRows($dbc)
{
$stmt = $dbc->prepare('SELECT * FROM national_parks');
$stmt->execute();
$rowTotal = $stmt->rowCount();
return $rowTotal;
}
$rowTotal = getNumRows($dbc);
// Dividing $rowTotal by $limit gives us the number of pages to hold the data.
$numOfPages = ceil($rowTotal / $limit);
// Prevents page numbers more than the total number of pages.
if ($page > $numOfPages) {
$page = $numOfPages;
$offset = $page * $limit - $limit;
}
// Uses variables of $limit and $offset to run the SELECT query in a scalable way.
function getAllParks($dbc, $limit, $offset)
{
$stmt = $dbc->prepare('SELECT * FROM national_parks ORDER BY name LIMIT :limit OFFSET :offset');
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$parksArray = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $parksArray;
}
function getAllAllParks($dbc)
{
$stmt = $dbc->prepare('SELECT * FROM national_parks ORDER BY name');
$stmt->execute();
$parksAllArray = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $parksAllArray;
}
$parksArray = getAllParks($dbc, $limit, $offset);
$parksAllArray = getAllAllParks($dbc);
// Uses the 'Submit A National Park' form to insert new values to the table and database.
function insertParks($dbc)
{
// Now calls on the Input class's getString and getDate methods with try catches.
// Try catch create an array of errors for passing to the user in the HTML.
$errorArray = [];
try {
$name = Input::getString('name', 0, 50);
} catch (Exception $e) {
$error = $e->getMessage();
$errorArray['errName'] = $error;
}
try {
$location = Input::getString('location', 0, 50);
} catch (Exception $e) {
$error = $e->getMessage();
$errorArray['errLoc'] = $error;
}
try {
$date_established = Input::getDate('date_established', '1776-07-04', 'next month');
$date_established = $date_established->format('Y-m-d');
} catch (Exception $e) {
$error = $e->getMessage();
$errorArray['errDate'] = $error;
}
try {
$area_in_acres = Input::getNumber('area_in_acres', 0, 375000000);
} catch (Exception $e) {
$error = $e->getMessage();
$errorArray['errArea'] = $error;
}
try {
$description = Input::getString('description', 0, 500);
} catch (Exception $e) {
$error = $e->getMessage();
$errorArray['errDes'] = $error;
}
// If the $errorArray is not empty, this will return out of the method before binding values and executing below. The $errorArray returns with an array of strings.
if (!empty($errorArray)) {
return $errorArray;
}
$stmt = $dbc->prepare('INSERT INTO national_parks (name, location, date_established, area_in_acres, description) VALUES (:name, :location, :date_established, :area_in_acres, :description)');
$stmt->bindValue(':name', $name, PDO::PARAM_STR);
$stmt->bindValue(':location', $location, PDO::PARAM_STR);
$stmt->bindValue(':date_established', $date_established, PDO::PARAM_STR);
$stmt->bindValue(':area_in_acres', $area_in_acres, PDO::PARAM_STR);
$stmt->bindValue(':description', $description, PDO::PARAM_STR);
$stmt->execute();
}
// Uses the 'Delete A Park' form to delete a row of data from the table and database.
function deletePark($dbc)
{
$park_to_delete = Input::get('park_to_delete');
$stmt = $dbc->prepare('DELETE FROM national_parks WHERE id = :park_to_delete');
$stmt->bindValue(':park_to_delete', $park_to_delete, PDO::PARAM_INT);
$stmt->execute();
}
// Logic that checks for $_POST values and empty string before running the functions to insert or delete.
// Additionally, saves a different $noteToUser variable and $errorArray to show the user in the HTML.
$noteToUser = '';
$errorArray = [''];
$formName = '';
$formLoc = '';
$formDate = '';
$formArea = '';
$formDes = '';
if (!empty($_POST)) {
if (Input::notEmpty('name') && Input::notEmpty('location') && Input::notEmpty('date_established') && Input::notEmpty('area_in_acres') && Input::notEmpty('description')) {
// If insertsParks() throws exceptions, it returns an array of strings. If no exceptions thrown, null.
$errorArray = insertParks($dbc);
$parksArray = getAllParks($dbc, $limit, $offset);
$parksAllArray = getAllAllParks($dbc);
$rowTotal = getNumRows($dbc);
// This if checks the $errorArray, if empty insertParks() did not throw exception and it worked.
if ($errorArray == []) {
$noteToUser = '******';
$errorArray = [''];
} else {
$formName = Input::get('name');
$formLoc = Input::get('location');
$formDate = Input::get('date_established');
$formArea = Input::get('area_in_acres');
$formDes = Input::get('description');
}
} elseif (Input::notEmpty('park_to_delete')) {
deletePark($dbc);
$parksArray = getAllParks($dbc, $limit, $offset);
$parksAllArray = getAllAllParks($dbc);
$rowTotal = getNumRows($dbc);
$noteToUser = '******';
} else {
$noteToUser = '******';
}
}
return array('parksArray' => $parksArray, 'parksAllArray' => $parksAllArray, 'page' => $page, 'limit' => $limit, 'offset' => $offset, 'rowTotal' => $rowTotal, 'numOfPages' => $numOfPages, 'noteToUser' => $noteToUser, 'errorArray' => $errorArray, 'formName' => $formName, 'formLoc' => $formLoc, 'formDate' => $formDate, 'formArea' => $formArea, 'formDes' => $formDes);
}
