booking.php

<?php
	/**
	 * Author: Matthew Fan
	 * Student ID: 18040157
	 * Description of File:
     * This file connects to the database, and handle the user request from booking.html and booking.js
	 * This will establish database connection.
	 */

	//check to see if the input field are assigned
    
    //get mysqli connection to the databse
	require_once("../../conf/settings.php");
	require_once("./SQLfunction.php");
	
	date_default_timezone_set("Pacific/Auckland");
	$conn = @mysqli_connect($sql_host, $sql_user, $sql_pass, $sql_db)
		or die("<p>Unable to connect to database and server</p>");

	// get booking information from the user
	$customerName = $_POST['customerName'];
	$phoneNumber = $_POST['phoneNumber'];
	$unitNumber = $_POST['unitNumber'];
	$streetNumber = $_POST['streetNumber'];
	$streetName = $_POST['streetName'];
	$suburb = $_POST['suburb'];
	$destinationSuburb = $_POST['destinationSuburb'];
	$pickUpDate = $_POST['pickUpDate'];
	$pickUpTime = $_POST['pickUpTime'];
	$status = 'unassigned';
	//generate a Unique reference number based on time
	$referenceNumber = time() . rand(10*45, 100*98);
	$sql_table = "A2db";
	
	//check if the reference number is unique in the database
	while(!checkReference($conn, $sql_table, $referenceNumber)) {
		$referenceNumber = time() . rand(10*45, 100*98);
	}

	//format date and time to MySQL DATETIME
	$pickUpDate = date('Y-m-d', strtotime($pickUpDate));
	$pickUpTime = date('H:i:s', strtotime($pickUpTime));

	if(book(
		$conn, 
		$sql_table, 
		$referenceNumber, 
		$customerName, 
		$phoneNumber,
		$unitNumber, 
		$streetNumber,
		$streetName,
		$suburb,
		$destinationSuburb,
		$pickUpDate,
		$pickUpTime,
		$status
	)) {
		echo("<p>Thank you! Your booking reference number is $referenceNumber.</p>");
		echo("<p>You will be picked up in front of your provided address at $pickUpTime on $pickUpDate</p>");
	} else {
		echo("<p>There is an issue with your booking. Please try again!");
	}
	
	mysqli_close($conn);
?>