im able to insert data in mysql and redirect to my index page. but my confirmation alert box wont pop-up after clicking my button/ submit form, whats the problem? :(
php/javascript page(seatplan_occupied.php):
<script>
function formOccupied()
{
document.getElementByName("formOccupied").innerHTML;
if (confirm("Are you sure you want to confirm your purchase?") == true)
{
alert("Yeay! You bought ticket/s");
<?php
include("databaseconnect.php");
if (mysql_query("UPDATE tblseatchart SET seatSTATUS='Occupied' WHERE seatSTATUS='Selected'"));
include("index.php");
?>
}
else
{
alert("Owh No! You Cancelled to confirm... Whats wrong?");
}
}
</script>
html page:
<form name = "formOccupied" method="post" onSubmit="occupied()" action="seatplan_occupied.php">
<input name = "btnSubmit" type = "submit" value="CONFIRM">
</form>