//connect to database
require 'connection.php';
?>

	<?php 
//insert make into database
if (!empty($_POST)) {
    if (validateMake()) {
        $make = $_POST["make"];
        $sql = $conn->prepare('INSERT INTO makes(Make) VALUE (?)');
        $sql->bind_param("s", $make);
        if (!$sql->execute()) {
            failUpdate();
        }
    } else {
        failUpdate();
    }
}
function failUpdate()
{
    echo '<script type="text/javascript">alert("Add Make Failed");</script>';
}
function validateMake()
{
    if (!isset($_POST["make"])) {
        return false;
    }
    return true;
}
?>
        }
        if ($check) {
            if (validateUpdate($row)) {
                $street = $_POST["street_" . $row["ID"]];
                $city = $_POST["city_" . $row["ID"]];
                $state = $_POST["state_" . $row["ID"]];
                $zip = $_POST["zip_" . $row["ID"]];
                $zip = $zip == null || $zip == '' ? null : $zip;
                $sql = $conn->prepare('UPDATE locations SET Street=?, City=?, State=?,
							ZIP=? WHERE ID=?');
                $sql->bind_param('sssii', $street, $city, $state, $zip, $row["ID"]);
                if (!$sql->execute()) {
                    failUpdate(2);
                }
            } else {
                failUpdate(3);
            }
        }
    }
}
function failUpdate($num)
{
    echo '<script>console.error("update failed (' . $num . ')");</script>';
}
function validateUpdate($row)
{
    $state = $_POST["state_" . $row["ID"]];
    if (!isset($state)) {
        return false;
    }
    $states = ["AL", "MT", "AK", "NE", "AZ", "NV", "AR", "NH", "CA", "NJ", "CO", "NM", "CT", "NY", "DE", "NC", "FL", "ND", "GA", "OH", "HI", "OK", "ID", "OR", "IL", "PA", "IN", "RI", "IA", "SC", "KS", "SD", "KY", "TN", "LA", "TX", "ME", "UT", "MD", "VT", "MA", "VA", "MI", "WA", "MN", "WV", "MS", "WI", "MO", "WY"];