function addRoom($db, $company, $branch, $room, $max_cap) { $sub_query = "SELECT c.company_id, b.branch_id FROM company AS c\n INNER JOIN branch b on b.company_id = c.company_id\n WHERE b.branch_address = '{$branch}' AND c.company_name = '{$company}'"; $results = $db->query($sub_query); $ids = $results->fetch_assoc(); $branch_id = $ids['branch_id']; $rand = genRandom(); $hash = password_hash($rand, PASSWORD_DEFAULT); $insert_room = "INSERT INTO room (`branch_id`, `room_number`, `max_capacity`, `secret_key`)\n VALUES ('{$branch_id}', '{$room}', '{$max_cap}', '{$hash}')"; if ($db->query($insert_room) === TRUE) { echo "Successfully inserted '{$room}'" . "<br>"; echo "Your Pi's password is " . $rand . ". Keep it safe and secure. The Pi needs it to submit counts" . "<br>"; } else { echo mysqli_error($db) . "<br />"; } }
/** * Adds a room to an existing branch * @param mysqli $db the database to add information to * @param string $company the company the branch belongs to * @param string $branch the address of the branch the room belongs to * @param string $room the room number of the room to add * @param int $max_cap the max capacity of the room */ function addRoom($db, $company, $branch, $room, $max_cap) { $sub_query = "SELECT c.company_id, b.branch_id, COALESCE(MAX(r.room_id), 0) AS `room_id` FROM company AS c\n INNER JOIN branch b on b.company_id = c.company_id\n INNER JOIN room r\n WHERE b.branch_address = '{$branch}' AND c.company_name = '{$company}'"; $results = $db->query($sub_query); $ids = $results->fetch_assoc(); $branch_id = $ids['branch_id']; $room_id = $ids['room_id'] + 1; //Generate random string and then hash it to retrieve the authentication key for the Pi $rand = genRandom(); $hash = password_hash($rand, PASSWORD_DEFAULT); $insert_room = "INSERT INTO room (`room_id`, `branch_id`, `room_number`, `max_capacity`, `secret_key`)\n VALUES ('{$room_id}','{$branch_id}', '{$room}', '{$max_cap}', '{$hash}')"; if ($db->query($insert_room) === TRUE) { echo "Successfully inserted '{$room}'" . "<br>"; echo "Your Pi's password is " . $rand . ". Keep it safe and secure. The Pi needs it to submit counts" . "<br>"; echo "Your Pi's id is " . $room_id . ". Keep it safe and secure. The Pi also needs it to submit counts" . "<br>"; } else { echo "Error inserting '{$room}' <br>"; } }