/home/desid573/public_html
Edit: /home/desid573/public_html/addDate.php (1438B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$sydney = 0;
if(isset($_POST["sydney"])) {
$sydney = 1;
}
$melbourne = 0;
if(isset($_POST["melbourne"])) {
$melbourne = 1;
}
$queensland = 0;
if(isset($_POST["queensland"])) {
$queensland = 1;
}
$perth = 0;
if(isset($_POST["perth"])) {
$perth = 1;
}
$sql = "INSERT INTO `holiday`(`id`, `date`, `queensland`, `sydney`, `melbourne`, `perth`, `date_created`) VALUES (NULL,'".$_POST["date"]."',".$queensland.",".$sydney.",".$melbourne.",".$perth.",NOW())";
$query = $conn->query($sql);
if(!$query) {
$message = $conn->error;
reload($message);
} else {
$message = "";
reload($message);
}
}
function reload($message) {
header("Location: holidays.php?message=".$message);
}