Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $servername = "localhost";
- $_SESSION['SERVER'] = $servername;
- $username = "placeholder";
- $_SESSION['USER'] = $username;
- $password = "";
- $_SESSION['PASS'] = $password;
- $dbname = "placeholder";
- $_SESSION['DB'] = $dbname;
- $cookie_name = "password";
- $cookie_value = $password;
- setcookie($cookie_name, $cookie_value, time() + (86400 * 30), "/");
- $conn = new mysqli($servername, $username, $password, $dbname);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- function add_customer ($FName, $LName, $Addr_City, $Addr_Street, $Addr_State, $Addr_Zip, $DoB, $PhoneNumber, $Email, $Special) {
- global $conn;
- $sql_i = "INSERT INTO Customer(FName, Lname, Addr_City, Addr_Street, Addr_State, Addr_Zip, DoB, PhoneNumber, Email_Address, Special) VALUES " . "('$FName', '$LName', '$Addr_City', '$Addr_Street', '$Addr_State', '$Addr_Zip', '$DoB', '$PhoneNumber', '$Email', '$Special')";
- run_update($sql_i); }
- function add_Employee ($Fname, $LName, $Duty_Start, $Duty_End, $DoB, $Password) {
- global $conn;
- $sql_i = "INSERT INTO Employee(FName, LName, Duty_Start, Duty_End, DoB, Password) VALUES " . "('$FName', '$LName', '$Duty_Start', '$Duty_End', '$DoB', '$Password')";
- run_update($sql_i); }
- function add_Flight ($DutyStart, $DepTime, $DepLocation, $ArrivalTime, $ArrivalLocation, $ResSeats, $AID, $Delayed, $Price) {
- global $conn;
- $sql_i = "INSERT INTO Flight(DutyStart, DepTime, DepLocation, ArrivalTime, ArrivalLocation, ResSeats, AID, Delayed, Price) VALUES " . "('$DutyStart', '$DepTime', '$DepLocation', '$ArrivalTime', '$ArrivalLocation', '$ResSeats', '$AID', '$Delayed', '$Price')";
- run_update($sql_i); }
- function add_Ticket ($CID, $FID, $DiscountID, $TicketID, $Class, $Type, $SeatNo) {
- global $conn;
- $sql_i = "INSERT INTO Ticket(CID, FID, DiscountID, TicketID, Class, Type, SeatNo) VALUES " . "('$CID', '$FID', '$DiscountID', '$TicketID', '$Class', '$Type', '$SeatNo')";
- run_update($sql_i); }
- function run_select_Customer ($sql) {
- global $conn;
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- echo "FName: " . $row["FName"] . " - LName: " . $row["Lname"] . " - Addr_City: " . $row["Addr_City"] . " - Addr_Street: " . $row["Addr_Street"] . " - Addr_State: " . $row["Addr_State"] . " - Addr_Zip: " . $row["Addr_Zip"] . " - DoB: " . $row["DoB"] . " - PhoneNumber: " . $row["PhoneNumber"] . " - Email: " . $row["Email"] . " - Special: " . $row["Special"] . "<br>";
- }
- }
- else {
- echo "0 results";
- }
- }
- function run_select_Employee ($sql) {
- global $conn;
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- echo "FName: " . $row["FName"] . " - LName: " . $row["Lname"] ." - Duty_Start: " . $row["Duty_Start"] . " - Duty_End: " . $row["Duty_End"] . " - DoB: " . $row["DoB"] . " - Password: " . $row["Password"] . "<br>";
- }
- }
- else {
- echo "0 results";
- }
- }
- function run_select_Flight ($sql) {
- global $conn;
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- echo "DutyStart: " . $row["DutyStart"] . " - DepTime: " . $row["DepTime"] ." - DepLocation: " . $row["DepLocation"] . " - ArrivalTime: " . $row["ArrivalTime"] . " - ArrivalLocation: " . $row["ArrivalLocation"] . " - ResSeats: " . $row["ResSeats"] . " - AID: " . $row["AID"] . " - Delayed: " . $row["Delayed"] . " - Price: " . $row["Price"] . "<br>";
- }
- }
- else {
- echo "0 results";
- }
- }
- function get_Customer_Records (&$result) {
- global $conn;
- $sql = "SELECT * FROM Customer";
- if (($result = $conn->query($sql)) == TRUE) {
- echo "Database updated successfully <br>";
- }
- else {
- echo "Error: " . $sql . "<br>" . $conn->error; }
- }
- function get_Employee_Records (&$result) {
- global $conn;
- $sql = "SELECT * FROM Employee";
- if (($result = $conn->query($sql)) == TRUE) {
- echo "Database updated successfully <br>";
- }
- else {
- echo "Error: " . $sql . "<br>" . $conn->error; }
- }
- function get_Flight_Records (&$result) {
- global $conn;
- $sql = "SELECT * FROM Flight";
- if (($result = $conn->query($sql)) == TRUE) {
- echo "Database updated successfully <br>";
- }
- else {
- echo "Error: " . $sql . "<br>" . $conn->error; }
- }
- function run_update ($sql) {
- global $conn;
- if ($conn->query($sql) === TRUE) {
- echo "Database updated successfully <br>";
- }
- else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- }
- function check_login($EID, $pass, $msg) {
- global $conn;
- $msg = "Login Denied";
- $retvalue = False;
- $sql = "select password from Employee where EID = '$EID'";
- $result = $conn->query($sql);
- if ($result->num_rows == 1) {
- $row = $result->fetch_assoc();
- $dbpass = $row["password"];
- if ($dbpass == $pass) {
- $retvalue = True;
- $msg = "Login Successful";
- }
- }
- return $retvalue;
- }
- function delete_ticket ($TicketID) {
- global $conn;
- $sql_i = "DELETE FROM Ticket WHERE TicketID='$TicketID'";
- run_update($sql_i);
- }
- function delete_flight ($FID) {
- global $conn;
- $sql_i = "DELETE FROM Flight WHERE FID='$FID'";
- run_update($sql_i);
- }
- /*function calculate_refund {
- global $conn;
- //get cost from ticket, remove lost percentage. Drop box to find time remaining, possible other screen to notify user how much time is left.
- //$sql_i = "SELECT FROM Ticket"
- }
- function calculate_cost (&$CID){
- global $conn;
- //add luggage, flight cost
- //subtract discount, membership, enter discount manually, membership entered manually
- //google: client side operations on multiple queries
- $sql_i = "SELECT Price FROM Luggage JOIN Flight WHERE CID='$CID'"
- } */
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement