reading/submission into mysql
Posted: Wed Mar 31, 2004 6:56 am
Am still trying to read from the fields into mysql database but proving unsuccessful from the code below...have named all field names exactly the same??..If anyone can help thanks...and if anyone can give me inspiration on how to make sure all fields contain data before submission and if not report which field was missed??
Thanks__________
Thanks__________
Code: Select all
<html>
<head><title>Flight Details</title></head>
<body text="blue" bgcolor="FFFFCC">
<HR SIZE=4 style="background-color: blue">
<body>
<?
$db = "u2ell";
$host = "mysql";
$user = "u2ell";
$pass = "";
mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db) or die (mysql_error());
//the connection to the database was successful
$flightid = $HTTP_POST_VARS['flightid'];
$flyday = $HTTP_POST_VARS['flyday'];
$time = $HTTP_POST_VARS['time'];
$destinationfrom = $HTTP_POST_VARS['destinationfrom'];
$destinationtill = $HTTP_POST_VARS['destinationtill'];
if(empty($flightid)or(empty($flyday)or($time)or(empty($destinationfrom)or(empty($destinationtill))
$query = "INSERT INTO flights
(flightid,flyday,time,destinationfrom,destinationtill)
VALUES
('$flightid','$flyday','$time','$destinationfrom','$destinationtill')";
$result =mysql_query($query) or die(mysql_error());
}
?>
<h1 align="center" h1><b><FONT COLOR="blue">FIND THE RIGHT TIME TO FLY!!<br>Flight Details</b></font></h1>
<center><img src="http://images.google.com/images?q=tbn:PFur1okFNCUJ:danenet.danenet.org/ywen/calender"</center>
<HR SIZE=4 style="background-color: blue">
<h2><center>Flights</h2>
<form method="post"action="<?php echo $PHP_SELF?>">
<table cellpadding=2 cellspacing=0 border=1>
<td>Flight Id :</td><td> <input type="text" size="10" maxlength="4" name="flightId" value=""></td><tr>
<td>Fly Day:</td><td><input type="text" size="20" maxlength="10" name="flyday" value=""></td></tr>
<td>Time:</td><td> <input type="decimal" size="10" name="time"value=" "></td></tr>
<td>Destination From</td><td> <input type="text" size="20" maxlength="15" name="destinationfrom" value=""></td></tr>
<td>Destination Till</td><td> <input type="text" size="20" maxlength="15" name="destinationtill" value=""> </td><tr>
</table>
<input type="Submit" name="flights" value="Enter Flight Details">
<HR SIZE=4 style="background-color: blue">
</form>
</body>
</html>