<?php //Check for request method if ($_SERVER['REQUEST_METHOD'] == 'POST') { assignCar(); } else { displayBookings(); } //This function accesses databases and sends records as XML function displayBookings() { $host; $user; $pswd; $dbnm; $connection = mysqli_connect($host, $user, $pswd, $dbnm) or die('Failed to connect.'); $searchQuery = "SELECT * FROM bookings where status = 'unassigned'"; $result = mysqli_query($connection, $searchQuery); $xml = new SimpleXMLElement('<xml/>'); if (mysqli_num_rows($result) > 0) { while ($result_array = mysqli_fetch_array($result)) { $data = $xml->addChild('search'); $data->addChild('bookingNumber', $result_array['bookingNumber']); $data->addChild('customerName', $result_array['customerName']); $data->addChild('pickupAddress', $result_array['pickupAddress']); $data->addChild('suburb', $result_array['suburb']); $data->addChild('destination', $result_array['destination']); $data->addChild('phoneNumber', $result_array['contactPhone']); $data->addChild('pickUpDate', $result_array['pickUpDate']); $data->addChild('pickUpTime', $result_array['pickUpTime']); $data->addChild('bookingDate', $result_array['bookingDate']);
<!DOCTYPE html> <html> <head> <title>Contacts</title> </head> <body> <div id="main_container"> <h1 style="text-align:center;"></h1><br /> <fieldset> <legend align="center">Your Bookings!</legend><br/> <?php include "Functions.php"; print displayBookings($_SESSION['userid']); ?> </fieldset> </br></br> <?php include "footer.php"; ?> </div> </body> </html>