***PHP***

<?php
require_once('mysqli_connect_db.php');

if(isset($_POST['office_submitted'])) {
    $office_name = $_POST['office_name'];
    $insert_query = "INSERT INTO offices (office_name) VALUES ('$office_name')";
    $insert_result = mysqli_query($connection, $insert_query);
}
elseif(isset($_POST['office_checks'])) {
    $delete_query = "DELETE FROM offices WHERE office_id IN ";
    $delete_query.= "('".implode("','",array_values($_POST['office_check']))."')";
    $delete_result = mysqli_query($connection, $delete_query);

    $delete_query = "DELETE FROM staff WHERE office_id IN ";
    $delete_query.= "('".implode("','",array_values($_POST['office_check']))."')";
    $delete_result = mysqli_query($connection, $delete_query);
}
elseif(isset($_POST['staff_submitted'])) {
    $staff_name = $_POST['staff_name'];
    $office_name = $_POST['staff_office_name_select'];
    $date_hire = $_POST['date_hire'];
    $insert_query = "INSERT INTO staff (staff_name, office_id, date_of_hire) VALUES ('$staff_name', '$office_name', '$date_hire')";
    $insert_result = mysqli_query($connection, $insert_query);
}
elseif(isset($_POST['staff_checks'])) {
    $delete_query = "DELETE FROM staff WHERE staff_id IN ";
    $delete_query.= "('".implode("','",array_values($_POST['staff_check']))."')";
    $delete_result = mysqli_query($connection, $delete_query);
}
else {
    $delete_offices_query = "DELETE FROM offices";
    $delete_offices_result = mysqli_query($connection, $delete_offices_query);

    $office_name_data = array("Marketing", "Management", "Development", "Testing");
    for($i = 0; $i < 4; $i++) {
        $insert_offices_query = "INSERT INTO offices (office_name) VALUES ('$office_name_data[$i]')";
        $insert_offices_result = mysqli_query($connection, $insert_offices_query);
    }

    $delete_staff_query = "DELETE FROM staff";
    $delete_staff_result = mysqli_query($connection, $delete_staff_query);
}
?>

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

<?php
require_once('mysqli_connect_db.php');

//getting data from offices table
$offices_result = mysqli_query($connection, "SELECT * FROM offices");

//storing in array
$office_data = array();
while($office_row = mysqli_fetch_assoc($offices_result)) {
    $office_data[] = $office_row;
}

//returning response in JSON format
echo json_encode($office_data);

?>

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

<?php
$host = "localhost";
$username = "root";
$password = "root";
$name = "smart_pelican_sample";

$connection = mysqli_connect($host, $username, $password, $name)
OR die('Could not connect to MySQL ' . mysqli_connect_error());
?>