function dropDownQueryForRental($attr_name, $table, $target)
{
    echo "<h2> Rent Equipment </h2>";
    echo "<form method=\"POST\" action=\"" . $target . "\"><select name =\"equip\">";
    echo "<option value=\"\">Select...</option>";
    $string = "select " . $attr_name . " from " . $table;
    $result = executePlainSQL($string);
    while ($row = OCI_Fetch_Array($result, OCI_BOTH)) {
        echo "<option value=\"" . $row[0] . "\">" . $row[0] . "</option>";
    }
    echo "<input type=\"text\" value=\"Quantity...\" name=\"qty\">";
    echo "<input type=\"text\" value=\"Member ID\" name=\"memID\">";
    echo "</select><input type=\"submit\" class=\"pure-button\" value=\"Rent\">";
    echo "</form>";
}

function populateTables()
{
    require 'setup.php';
    echo "<b>Populating tables...</b> <br>";
    // execute all "INSERT INTO" SQL statements in setup.php
    foreach ($insertArray as &$subArray) {
        foreach ($subArray as &$subStatement) {
            global $db_conn;
            // for variable scope in inner loop
            executePlainSQL($subStatement);
            global $verbose;
            if ($verbose) {
                echo $subStatement . "<br>";
            }
            OCICommit($db_conn);
        }
        if ($verbose) {
            echo "<br>";
        }
    }
}

            } else {
                $update_pw_q = "UPDATE Customer SET password = '" . $_POST['new_pw'] . "' WHERE cid = " . $cid;
                executePlainSQL($update_pw_q);
                OCICommit($db_conn);
                ?>
				<script type="text/javascript"> 
					alert("Password successfully updated!");
					location: "profile.php";
				</script>
				<?php 
            }
        }
    }
    // Fetch the customer profile based on the cid from cookies
    $q = "select * from Customer where cid = '" . $cid . "'";
    $result = executePlainSQL($q);
    $row = OCI_Fetch_Array($result, OCI_BOTH);
    $cname = $row['CNAME'];
    $email = $row['EMAIL'];
    $addr = $row['ADDRESS'];
    $phone = $row['PHONE'];
    $passport_country = $row['PASSPORT_COUNTRY'];
    $passport_num = $row['PASSPORT_NUM'];
    OCILogoff($db_conn);
}
?>
<div class="content-customer-area">

<p>Edit your profile:</p>
<form class="pure-form pure-form-aligned" method="POST" action="profile.php">
    <fieldset>

function printLayOver($firstid, $secondid)
{
    $layover = oci_fetch_row(executePlainSQL("select F2.departtime-F1.arrivaltime from Flight F1, Flight F2\n\t\t\t\t\t\t\t\t\twhere F1.fid='{$firstid}' AND F2.fid='{$secondid}'"));
    $layovertime = parseDate($layover[0], 2);
    echo "<br>Lay over for {$layovertime}";
}

        // Insert reservation tuple into make_res
        // (resid, cid, pclass, ticket_num)
        executePlainSQL("insert into make_res values (\r\n\t\t\t\t\t\tresid_sequence.nextval," . $_COOKIE['cid'] . "," . $_POST['makeres_classint'] . "," . $_POST['makeres_numtickets'] . ")");
        OCICommit($db_conn);
        // res_includes(fid, resid, resorder)
        $fids = array($_POST['fid1'], $_POST['fid2'], $_POST['fid3']);
        foreach ($fids as $key => $value) {
            //echo $fids[$key]."<br>";
            if ($fids[$key] != "") {
                executePlainSQL("insert into res_includes values (" . $value . ",\r\n\t\t\t\t\tresid_sequence.currval," . number_format($key + 1) . ")");
            }
        }
        OCICommit($db_conn);
        executePlainSQL("insert into payment values(\r\n\t\t\t\tpayid_sequence.nextval," . $_POST['credit'] . "," . $_COOKIE['cid'] . ")");
        OCICommit($db_conn);
        executePlainSQL("insert into deter_pay values(\r\n\t\t\t\tpayid_sequence.currval,\r\n\t\t\t\tresid_sequence.currval," . $_POST['makeres_totalcost'] . ")");
        OCICommit($db_conn);
        // Confirmation dialog
        ?>
		<script type="text/javascript"> 
			alert("Payment successful. Proceed to adding bags");
			location = "baggage.php";
		</script>
		<?php 
    } else {
        //print_r($res);
        echo "Your flight itinerary:";
        printDetails($res, 0, 0);
        ?>
		<br><br>The summary of your ticket order:
		<table class="pure-table">

                $tuple = array(":bind1" => $_POST['oldName'], ":bind2" => $_POST['newName']);
                $alltuples = array($tuple);
                executeBoundSQL("update tab1 set name=:bind2 where name=:bind1", $alltuples);
                OCICommit($db_conn);
            } else {
                if (array_key_exists('dostuff', $_POST)) {
                }
            }
        }
    }
    if ($_POST && $success) {
        //POST-REDIRECT-GET -- See http://en.wikipedia.org/wiki/Post/Redirect/Get
        header("location: oracle-test.php");
    } else {
        // Select data...
        $result = executePlainSQL("select * from Customer");
        printResult($result);
    }
    //Commit to save changes...
    OCILogoff($db_conn);
} else {
    echo "cannot connect";
    $e = OCI_Error();
    // For OCILogon errors pass no handle
    echo htmlentities($e['message']);
}
/* OCILogon() allows you to log onto the Oracle database
   The three arguments are the username, password, and database
   You will need to replace "username" and "password" for this to
   to work. 
   all strings that start with "$" are variables; they are created

     $deletesearchby = $_POST['deletesearchby'];
     $searchedvalue = $_POST['searchedvalue'];
     executePlainSQL("delete from {$tablename}" . " where {$deletesearchby} = '{$searchedvalue}'");
     OCICommit($db_conn);
     // save selection for next load
     setcookie("deletesearchby", $deletesearchby);
 }
 if ($_POST && $success) {
     //POST-REDIRECT-GET -- See http://en.wikipedia.org/wiki/Post/Redirect/Get
     header("location: admin.php");
     // default will check if there is any table already selected and output that
 } else {
     if (strcmp($_COOKIE['tabchoice'], "") !== 0 && strcmp($_COOKIE['tabchoice'], "default") !== 0) {
         $tabchoice = $_COOKIE['tabchoice'];
         $cols = executePlainSQL("select column_name from user_tab_columns where table_name = '{$tabchoice}'");
         $data = executePlainSQL("select * from " . $tabchoice);
         printResults($tabchoice, $cols, $data);
         // retrieve past delete/update selection from cookie for this load
         $updatesearchby = $_COOKIE['updatesearchby'];
         $deletesearchby = $_COOKIE['deletesearchby'];
         // delete them as only needed for one load
         setcookie("updatesearchby", "", time() - 3600);
         setcookie("deletesearchby", "", time() - 3600);
         // set the drop down lists according to the cookie (last delete/update selections)
         echo "<script>document.getElementById('tabchoice').value='{$tabchoice}'</script>";
         if (strcmp($_COOKIE['updatesearchby'], "") !== 0) {
             echo "<script>document.getElementById('updatesearchby').value='{$updatesearchby}'</script>";
         }
         if (strcmp($_COOKIE['deletesearchby'], "") !== 0) {
             echo "<script>document.getElementById('deletesearchby').value='{$deletesearchby}'</script>";
         }

        oci_close($db_conn);
    }
}
if (isset($_POST['BusinessLogin'])) {
    if (empty($_POST['businessName']) || empty($_POST['businessPwd'])) {
        $error = "Business Name or Password is invalid";
    } else {
        // connect to DB
        $db_conn = OCILogon("ora_" . $csid, "a" . $studentnum, "ug");
        // now connected
        if ($db_conn) {
            // grab the information needed for login
            $inputname = $_POST['businessName'];
            $inputpwd = $_POST['businessPwd'];
            // query for information obtained
            $s = executePlainSQL("select count (*)\n                           from Business \n                          where BusinessName = '{$inputname}' AND \n                          PasswordHash = '{$inputpwd}'");
            $result = oci_fetch_array($s);
            if ($result[0] == 1) {
                $_SESSION['login_business'] = $inputname;
                // Initializing Session
                header("location: business_profile.php");
                // Redirecting To Other Page
            } else {
                $error = "Business Name or Password is invalid";
            }
        } else {
            echo "cannot connect";
            $e = OCI_Error();
            // For OCILogon errors pass no handle
            echo htmlentities($e['message']);
        }

<?php

//THIS PHP FILE IS TO DELETE USER OR LOG OUT
require 'template.php';
ini_set('session.save_path', '/home/i/i5a8/');
session_start();
if (isset($_SESSION['username'])) {
    if (isset($_GET['logout'])) {
        session_destroy();
    } else {
        executePlainSQL("delete from party where partyid='{$_SESSION['username']}'");
        OCICommit($db_conn);
        OCILogoff($db_conn);
        session_destroy();
    }
}
header('Location: user.php');

    function printResult($result)
    {
        //prints results from a select statement
        echo "<br>Employee Info<br>";
        echo "<table class='table table-striped'>";
        echo "<tr><th>Username</th>" . " " . "<th>Wage</th>" . " " . "<th>Job Type</th>" . " " . "<th>Work Schedule</th></tr>";
        while ($row = OCI_Fetch_Array($result, OCI_BOTH)) {
            echo "<tr><td>" . $row["USERNAME"] . " </td><td>" . $row["WAGE"] . " </td><td>" . $row["JOBT"] . "</td><td>" . " " . $row["WORKS"] . "</td></tr>";
            //or just use "echo $row[0]"
        }
        echo "</table>";
    }
    // Connect Oracle...
    if ($db_conn) {
        $users = $_SESSION["username"];
        printResult(executePlainSQL("select * from employee where username = '{$users}'"));
        OCICommit($db_conn);
    }
    ?>
        </font>
      </div>
    </div>
    <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
    <!-- Include all compiled plugins (below), or include individual files as needed -->
    <script src="../js/bootstrap.min.js"></script>
  </body>
<?php 
} else {
    echo "ACCESS DENIED";
}

    }
    if (array_key_exists('Value', $_POST)) {
        $users = $_POST['username'];
        $amount = $_POST['amount'];
        $result = executePlainSQL("select username from customers where username = '{$users}'");
        $numrows = oci_fetch_all($result, $res);
        if ($numrows == 0) {
            echo "<div class='alert alert-danger' role='alert'>";
            echo "<span class='glyphicon glyphicon-exclamation-sign' aria-hidden='true'></span>";
            echo "<span class='sr-only'>Error:</span>";
            echo "Invalid User";
            echo $amount = $_POST['amount'];
            echo "</div>";
        }
        if ($numrows == 1) {
            executePlainSQL("update customers set credit = {$amount} where username = '{$users}'");
            header("location: index.php");
        }
    }
    OCICommit($db_conn);
    //Commit to save changes...
    OCILogoff($db_conn);
    // printResult($result);
    //Commit to save changes...
} else {
    $e = OCI_Error();
    // For OCILogon errors pass no handle
    echo "<div class='alert alert-danger' role='alert'>";
    echo "<span class='glyphicon glyphicon-exclamation-sign' aria-hidden='true'></span>";
    echo "<span class='sr-only'>Error:</span>";
    echo htmlentities($e['message']);

function minAvg()
{
    $min = executePlainSQL("SELECT min(avg(pp)) FROM moves GROUP BY type");
    echo "<div class='Pokeguide'>";
    echo "<table>";
    echo "<tr>";
    echo "<td>Lowest Average PP</td>";
    echo "<td>Type</td>";
    echo "</tr>";
    echo "<tr>";
    $row = OCI_Fetch_Array($min, OCI_BOTH);
    echo "<td>" . $row[0] . "</td><td>Dragon</td>";
    echo "</tr>";
    echo "</table>";
    echo "</div>";
}

Location: <input type="text" name="location">
<input type="submit" value="search">
</form> 

<br>

<?php 
//SEARCH
$location = strtolower($_GET["location"]);
if ($location != null) {
    //$pokemon = ucfirst($_POST["pokemon"]);
    $locations = array_map('ucfirst', explode(" ", $location));
    $location = implode(" ", $locations);
    $result = executePlainSQL("SELECT * FROM location WHERE lname = '" . $location . "' OR lname LIKE '%" . $location . "%'");
} else {
    $result = executePlainSQL("SELECT * FROM location");
}
printLocation($result);
//Print result
function printLocation($result)
{
    echo "<div class='Pokeguide'>";
    echo '<table>';
    echo '<tr><td>Location</td><td>Description</td></tr>';
    while ($row = OCI_Fetch_Array($result, OCI_BOTH)) {
        if (strpos($row[0], 'Evolve') === false and strpos($row[0], 'LName') === false) {
            echo '<tr>';
            echo '<td>' . $row[0] . '</td>';
            echo '<td>' . $row[1] . '</td>';
            echo '</tr>';
        }

<head>
	<title>RegSys</title>
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link href="css/style.css" rel="stylesheet" type="css/css" media="all" />
	<link rel="stylesheet" href="http://yui.yahooapis.com/pure/0.6.0/pure-min.css">
	<link href='http://fonts.googleapis.com/css?family=Montserrat' rel='stylesheet' type='text/css'>
	<link href='http://fonts.googleapis.com/css?family=Exo+2:400,700,100' rel='stylesheet' type='text/css'>
</head>
<body>
<!--content-->
<h1>RegSys 1.0</h1>
<h2>Recreation Centre Registration System</h2>
<p><?php 
echo "Hello, ";
$getName = "SELECT name \n\t\t\t\tFROM employee\n\t\t\t\tWHERE employee.empID = '" . $_SESSION["empID"] . "' \n\t\t\t\tAND employee.password = '" . $_SESSION["password"] . "'";
$result = executePlainSQL($getName);
$row = oci_fetch_array($result, OCI_BOTH);
if ($row["NAME"]) {
    echo $row["NAME"];
    $loginName = "Logout";
    $loginAction = "window.location.href='logout.php'";
} else {
    echo "Guest!";
    $loginName = "Login";
    $loginAction = "window.location.href='login.php'";
}
?>
</p>
<ul class="content">
      <li class="menu">
          <ul>

                    //the function takes a list of lists
                    // Update data...
                    //executePlainSQL("update tab1 set nid=10 where nid=2");
                    // Delete data...
                    //executePlainSQL("delete from tab1 where nid=1");
                    OCICommit($db_conn);
                }
            }
        }
    }
    if ($_POST && $success) {
        //POST-REDIRECT-GET -- See http://en.wikipedia.org/wiki/Post/Redirect/Get
        header("location: oracle-test.php");
    } else {
        // Select data...
        $result = executePlainSQL("select * from tab1");
        printResult($result);
    }
    //Commit to save changes...
    OCILogoff($db_conn);
} else {
    echo "cannot connect";
    $e = OCI_Error();
    // For OCILogon errors pass no handle
    echo htmlentities($e['message']);
}
/* OCILogon() allows you to log onto the Oracle database
   The three arguments are the username, password, and database
   You will need to replace "username" and "password" for this to
   to work. 
   all strings that start with "$" are variables; they are created

		<div id="main">
			<div class="container">
				<div class="row main-row">
					<div class="12u">

<?php 
if (isset($_SESSION["username"])) {
    echo "<h2 style='text-align:center;'>Welcome to your Pokemon Party<br> PokeMaster {$_SESSION["username"]}</h2>";
    $trainer_info = executePlainSQL("SELECT * FROM party WHERE partyid = '{$_SESSION["username"]}'");
    $row = OCI_Fetch_Array($trainer_info, OCI_BOTH);
    $party = explode(",", $row[1]);
    echo "<div class='Pokeguide'>";
    //================LIST OF POKEMON
    for ($i = 0; $i < count($party); $i++) {
        echo "<table>";
        $result = executePlainSQL("SELECT * FROM pokemon WHERE pid = '{$party[$i]}'");
        printPoke($result);
        echo "<td>";
        echo "<form action='deletePoke.php' method='get'>";
        echo "<button name='submit' value='{$party[$i]}'>Remove Pokemon</button></form>";
        echo "</td>";
        echo "</tr>";
        //========================================
    }
    echo "<tr>";
    echo "<td colspan='2'>";
    //DELETE USER BUTTON
    echo "<form action='deleteUser.php'>";
    echo "<button name='delete'>DELETE USER</button></form>";
    echo "</td>";
    echo "</tr>";

function executeClassQuery($attributes, $selectMode)
{
    switch ($selectMode) {
        case "className":
            echo "Search by Class Name<br>";
            $attr = "CU.name";
            break;
        case "repeatedOn":
            echo "Search by Repeat Day<br>";
            $attr = "CU.repeatedOn";
            break;
        case "instructor.name":
            echo "Search by Instructor Name<br>";
            $attr = "T.Name";
            break;
    }
    $tables = "class_uses CU, class_info CI, teaches T";
    $queryString = "SELECT " . $attributes[0] . " FROM " . $tables . " WHERE " . $attr . " LIKE '%" . $_GET["select"] . "%'" . " AND CU.name = CI.name \n\t\t  \tAND CU.activity_ID = T.activity_ID";
    // echo $queryString . "<br>";
    $result = executePlainSQL($queryString);
    printResultTable($result, "Classes", $attributes[1], $attributes[2]);
}

function getDetails($bigTuple, $numFlights)
{
    $fid1 = $bigTuple['FID1'];
    $departFlight = oci_fetch_assoc(executePlainSQL("select * from Flight where fid='{$fid1}'"));
    $departDate = parseDate($departFlight['DEPARTTIME'], 1);
    $departApCode = $departFlight['DEPARTAP'];
    $departAp = oci_fetch_assoc(executePlainSQL("select CITY, COUNTRY from Airport where code='{$departApCode}'"));
    $departCity = $departAp['CITY'];
    $departCountry = $departAp['COUNTRY'];
    if ($numFlights == 1) {
        $arrivalFlight = $departFlight;
    } else {
        if ($numFlights == 2) {
            $fid2 = $bigTuple['FID2'];
            $arrivalFlight = oci_fetch_assoc(executePlainSQL("select * from Flight where fid='{$fid2}'"));
        } else {
            $fid3 = $bigTuple['FID3'];
            $arrivalFlight = oci_fetch_assoc(executePlainSQL("select * from Flight where fid='{$fid3}'"));
        }
    }
    $arrivalApCode = $arrivalFlight['ARRIVALAP'];
    $arrivalAp = oci_fetch_assoc(executePlainSQL("select * from Airport where code='{$arrivalApCode}'"));
    $arrivalCity = $arrivalAp['CITY'];
    $arrivalCountry = $arrivalAp['COUNTRY'];
    $flightLoc = array("DEPARTDATE" => $departDate, "DEPARTCITY" => $departCity, "DEPARTCOUNTRY" => $departCountry, "ARRIVALCITY" => $arrivalCity, "ARRIVALCOUNTRY" => $arrivalCountry);
    return $flightLoc;
}

    echo "</table>";
}
function printActivityUseTable($result)
{
    echo "<table class=\"myTable\">";
    echo "<tr>\n\t\t\t\t<th>Activity ID</th>\n\t\t\t\t<th>Name</th>\n\t\t\t\t<th>Day</th><th></th><th></th>\n\t\t\t\t<th>Start Time</th><th></th><th></th>\n\t\t\t\t<th>End Time</th><th></th>\n\t\t\t\t<th>Room</th>\n\t\t\t</tr>";
    while ($row = OCI_Fetch_Array($result, OCI_BOTH)) {
        echo "<tr><td>" . $row["ACTIVITY_ID"] . "</td><td>" . $row["NAME"] . "</td><td>" . $row["DAY"] . "</td><td>" . "</td><td>" . "</td><td>" . $row["START_TIME"] . "</td><td>" . "</td><td>" . "</td><td>" . $row["END_TIME"] . "</td><td>" . "</td><td>" . $row["ROOMNUM"] . "</td></tr>";
    }
    echo "</table>";
}
if ($db_conn) {
    dropDownFromQuery($attr_name, $table, "activities.php");
    // Display Activity_Info and Activity_Uses entires
    $activityInfoCmd = "select * from Activity_Info";
    $activityUseCmd = "select * from Activity_uses";
    if ($_POST["activityName"] != "") {
        $activityInfoCmd = "select * from Activity_Info where name like '%" . $_POST["activityName"] . "%'";
        $activityUseCmd = "select * from Activity_uses where name like '%" . $_POST["activityName"] . "%'";
    }
    echo '<h2>Activity Info</h2>';
    $result1 = executePlainSQL($activityInfoCmd);
    printActivityInfoTable($result1);
    echo '<h2>Activity Uses</h2>';
    $result2 = executePlainSQL($activityUseCmd);
    printActivityUseTable($result2);
}
?>
<br><hr><form><input class="pure-button" type="button" value="Back to Main Menu" onclick="window.location.href='index.php'"><br>
</body>
</html>

<html>
<body>

<p>Enter the Name:</p> <input type="text" name="Nameone" />
<p>Enter the Barcode:</p> <input type="number" name="Barcodeone" />
<p>Enter the ESRB:</p> <input type="text" name="rateone" />
<p>Enter The Number Players:</p> <input type="number" name="playersone" />
<p>Enter the Price: </p> <input type = "number" name = "priceone" />
<p></p>
<input type="submit" value="AddGames" name = "submit">

<p>Select your order: <input type="text" name="productorder"> 
<input type="submit" value="purchase" name="purchasesubmit">

</body>
</html>

<?php 
$productorder = $_POST['productorder'];
if (!($productorder == 0)) {
    $queryten = executePlainSQL("SELECT Name \t\t\t\t\t\t\t\n\t\t\t\t\t\t\tFROM ProductBarcode p\t\t\t\t\t\t\n\t\t\t\t\t\t\tWHERE rownum = {$productorder}");
    $row = OCI_Fetch_Assoc($queryten);
    echo $row['Name'];
    echo $row["Name"];
    echo "you have purchased" . $row["Name"];
}