<?php //HTTP Post allowing mobile and browser clients to call the queries specified in queryDatabaseFunc. if (isset($_POST["Username"]) && isset($_POST["Password"]) && isset($_POST['QueryType'])) { require_once 'queryDatabaseHelper.php'; $username = $_POST["Username"]; $password = $_POST["Password"]; $queryType = $_POST["QueryType"]; $valid = validUsernameAndPassword($username, $password); if ($valid === True) { $json_to_send = array(); $results = queryDatabaseFunc($username, $password, $queryType); $subscribed = false; if (strcmp($queryType, "myOrgs") == 0 || strcmp($queryType, "browseOrgs") == 0) { if (strcmp($queryType, "myOrgs") == 0) { $subscribed = true; } $link = mysqli_connect("localhost", "Tommy", "pickles", "Model"); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit; } $orglist = array(); $orgnumberlist = array(); foreach ($results as $orgrow) { $found = false; for ($x = 0; $x < count($orgnumberlist); $x++) { if ($orgnumberlist[$x] === $orgrow['orgnumber']) { $found = true; break; }
<html> <body> <h1> Add Admins: <br /> </h1> <form action="insertAdmin.php" method="post"> Username: <input type="text" name="Username"><br> Group: <select name="Entity"> <?php require_once 'queryDatabaseHelper.php'; session_start(); $results = queryDatabaseFunc($_SESSION['username'], $_SESSION['password'], 'myAdmins'); foreach ($results as $row) { echo '<option value="' . $row['orgnumber'] . '">' . $row['orgname'] . '</option>'; } ?> </select> <input type="submit"> </form> </body> </html>