PHP ignoring my IF Statements
Posted: Tue Apr 06, 2010 5:05 pm
Code: Select all
<?php
function kill() {
echo "<table width='100%'><tr><td> </td></tr><tr><span class='boldblue'>There has been a problem.<br /><a href='index1.php?page=ivaorfe2010'>Please click here to try book another flight.</a></span><td></td></tr><tr><td> </td></tr></table>";
}
function error() {
echo "<table width='100%'><tr><td> </td></tr><tr><span class='boldblue'>We are sorry, the flight has already been booked.<br /><a href='index1.php?page=ivaorfe2010'>Please click here to try book another flight.</a></span><td></td></tr><tr><td> </td></tr></table>";
}
function book($pilotid, $flightno) {
mysql_query("UPDATE ivaorfetmp SET pilot_id='$pilotid' WHERE flightno='$flightno'");
echo "<table width='100%'><tr><td> </td></tr><tr><span class='boldblue'>Your booking has been submitted successfully, we hope you enjoy your flight.<br />You will be redirected to your 'My Bookings' page in 3 seconds...</span><td></td></tr><tr><td> </td></tr></table>";
echo "<script type='text/javascript'>";
echo "setTimeout(\"window.location.href = 'index.php?page=my_booked_flights';\" , 3000);";
echo "</script>";
}
if (isset($_GET['flightid'])) {
$flightno = $_GET['flightid'];
$pilotid = $flyuk->pilotid;
$avail = $flyuk->db_query("SELECT pilot_id FROM ivaorfetmp WHERE flightno='$flightno'");
$booked = mysql_result($avail,0);
if (($booked !='')||(!empty($booked))) {
error();
} else {
book($pilotid, $flightno);
}
} else {
kill();
}
?>
Thank you very much in advance!