<?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>
