Version: 1.00
Type: Full Script
Category: Databases
License: GNU General Public License
Description: this is a car rental online reservation script utilizing freesql.org’s (http://www.freesql.org) mysql server.
<html>
<head>
<title>Online Reservation</title>
<!--company x online reservation created by Mark Anthony R. Lisao-->
</head>
<?
//note : $first_pass variable is hidden in the form
empty($first_pass) ?
show_form() :
data_keep($first_name, $last_name, $email, $address, $contact_no,
$units_sedan, $units_pickup, $units_van, $month, $day,
$year, $inquiries);
exit;
?>
<?
function untaint($x){
chop($x);
$x=strtolower($x);
$x=ereg_replace("[!#$%^()+=<>]", "", $x);
return $x;
//clean up user input data
}
function data_keep($d1, $d2, $d3, $d4, $d5,
$d6, $d7, $d8, $d9, $d10,
$d11, $d12){
$arr=array("first_name" => $d1,
"last_name" => $d2,
"email_address" => $d3,
"business_address" => $d4,
"contact_no" => $d5
);
//error handler
$empty_vals=array();
while (list($key, $value )=each($arr)){
untaint($value);
if($value==""){
array_push($empty_vals, $key);
}
}
if (empty($empty_vals)){
//establishing database connection
$db_loc=mysql_connect("freesql.org", "markl", "asia12");
mysql_select_db("markl", $db_loc);
$query="INSERT INTO crc_data (first_name, last_name, email, address, contact_no,
units_sedan, units_pickup, units_van, month, day,
year, inquiries) VALUES
('$d1', '$d2', '$d3', '$d4', '$d5',
'$d6', '$d7', '$d8', '$d9', '$d10',
'$d11', '$d12')";
mysql_query($query);
//entry succesfully added
echo("<p style=font-family:arial font-size:2>");
echo("Your reservation has been processed. We shall update you soon about your booking.");
echo("<br>Thank you very much.</p>");
echo("<a href='http://www.markl001ph.host.sk'>Back to main page</a>");
}
else{
global $PHP_SELF;
$err_html=<<<EOL
<p style="font-family:arial font-size:2">
Error on Form.<br>
You had error(s) on the following fields :
EOL;
echo ($err_html." ");
for ($i=0; $i<count($empty_vals); $i++){
echo ($empty_vals[$i].", ");
}
echo("<br><a href=".$PHP_SELF.">Back to form</a>");
echo("</p>");
}
}
function show_form(){
global $PHP_SELF;
$form=<<<HTML
<body>
<div align="center">
<form action="$PHP_SELF">
<input type="HIDDEN" name="first_pass" value="no">
<table>
<tr>
<td colspan="2">Customer Information</td>
</tr>
<tr>
<td>First Name </td><td><input type="text" size="15" name="first_name" maxlength="40"></td>
</tr>
<tr>
<td>Last Name </td><td><input type="text" size="20" name="last_name" maxlength="40"></td>
</tr>
<tr>
<td>Email </td><td><input type="text" size="20" name="email" maxlength="40"></td>
</tr>
<tr>
<td>Business Address</td><td><input type="text" size="30" name="address" maxlength="80"></td>
</tr>
<tr>
<td>Contact Number</td><td><input type="text" size="18" name="contact_no" maxlength="20"></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
<table>
<tr>
<td colspan="2">Vehicle Reservation</td>
</tr>
<tr>
<td>Vehicle Type</td><td>Number of Units</td>
</tr>
<tr>
<td>Sedan</td><td><select name="units_sedan">
<option value="0">0
<option value="1">1
<option value="2">2
<option value="3">3
<option value="4">4
<option value="5">5
</select>
</td>
</tr>
<tr>
<td>Pickup</td><td><select name="units_pickup">
<option value="0">0
<option value="1">1
<option value="2">2
<option value="3">3
<option value="4">4
<option value="5">5
</select>
</td>
</tr>
<tr>
<td>Van</td><td><select name="units_van">
<option value="0">0
<option value="1">1
<option value="2">2
<option value="3">3
<option value="4">4
<option value="5">5
</select>
</td>
</tr>
<tr>
<td>Reservation Date</td>
<td><select name="month">
<option value="jan">January
<option value="feb">February
<option value="mar">March
<option value="apr">April
<option value="may">May
<option value="jun">June
<option value="jul">July
<option value="aug">August
<option value="sep">September
<option value="oct">October
<option value="nov">November
<option value="dec">December
</select>
</td>
<td>
<select name="day">
<option value="1">1
<option value="2">2
<option value="3">3
<option value="4">4
<option value="5">5
<option value="6">6
<option value="7">7
<option value="8">8
<option value="9">9
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
<option value="24">24
<option value="25">25
<option value="26">26
<option value="27">27
<option value="28">28
<option value="29">29
<option value="30">30
<option value="31">31
</select>
</td>
<td>
<select name="year">
<option value="2001">2001
<option value="2002">2002
<option value="2003">2003
</select>
</td>
</tr>
</table>
<table>
<tr>
<td>Inquiries/Trip Details </td><td> </td>
</tr>
<tr>
<td colspan="2"><textarea name="inquiries" cols="42" rows="7"></textarea></td>
</tr>
<tr>
<td><input type="submit" value="submit entries"> <input type="reset" value="clear"></td>
</tr>
</table>
</form>
</body>
</html>
HTML;
echo $form;
}
?>
