i have a Listbox available in my page and that Listbox have these items.
and i have trip named table which have these fields.
id which will autocrement
from
to
coach_type
fare
journey_date
seat
now i want this to be happen if a user come and take any item from Listbox it will inserts that that info to these fields not in the seats cuz seat is on the other page.
for example
if a user selects 1st item which is Sukkur-Karachi-(NonAC) then it will insert this data in the field.
in from it insert sukkur
in to it insers karachi
in couchtype it insert nonac
in fare it insert 550
also for the second it insert according to the item in the list box.
after that i have a field which is journey date that is timestamp now i want a calender to be attach to this if user selects date that insers in the journey_date field. please help me out on this.
i have these fields in the listbox.
[IMG]http://i41.tinypic.com/epf0ug.jpg[/IMG]
In default situation
[IMG]http://i39.tinypic.com/2hn6x42.jpg[/IMG]
<?php
$a = $_GET['Karachi'];
$b = $_GET['Sukkur'];
$c = $_GET['ac'];
$d = $_GET['nonac'];
$e = $_GET['550'];
mysql_connect("localhost", "root", "") or die ('Error'.mysqlerror());
mysql_select_db("online_bus_project");
$query="INSERT INTO trip (from,to,coach_type,fare) values ('".$a."','".$b."','".$c."'".$d."'".$e."')";
mysql_query($query) or die ('Error Cannnot Insert Records!');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="obrs.css" rel="stylesheet" type="text/css" />
<!--[if IE 5]>
<style type="text/css">
/* place css box model fixes for IE 5* in this conditional comment */
.twoColFixRtHdr #sidebar1 { width: 220px; }
</style>
<![endif]--><!--[if IE]>
<style type="text/css">
/* place css fixes for all versions of IE in this conditional comment */
.twoColFixRtHdr #sidebar1 { padding-top: 30px; }
.twoColFixRtHdr #mainContent { zoom: 1; }
/* the above proprietary zoom property gives IE the hasLayout it needs to avoid several bugs */
</style>
<![endif]-->
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<style type="text/css">
<!--
.style1 {
color: #FFFF00;
font-weight: bold;
}
.style2 {
color: #FFFF66;
font-weight: bold;
}
.style5 {color: #0066FF; font-weight: bold; }
.style6 {
color: #0066FF;
font-weight: bold;
font-size: 24px;
}
.style7 {font-size: 12px}
#apDiv1 {
position:absolute;
left:35px;
top:168px;
width:621px;
height:362px;
z-index:1;
}
-->
</style>
</head>
<body class="twoColFixRtHdr">
<div id="container">
<div id="header">
<!-- end #header -->
<img src="images/header" alt="OBTRS: Header" /></div>
<div id="sidebar1">
<!-- end #sidebar1 -->
<img src="images/sidebar_slideshow" alt="" />
<div id="blogarea">
<p class="style2">Casual Dining Restaurants</p>
<p><br />
Our family-style restaurants are the favorite of thousands of tourists and professional drivers alike. Our clean and friendly surroundings encourage people to stop and enjoy a wholesome meal with us when they travel. Our customers recognize our strong teamwork ethic as we provide them quality service.</p>
<p><br />
<span class="style1">Convenience Stores</span></p>
<p><br />
Our cashiers take pride in having the items on the shelf ready for our travelers when they stop. We know many are in a hurry and we need to be "fast" to meet their busy schedules. Some of our returning customers enjoy fresh coffee and we have it ready for them. The joint effort of our managers and associates creates a strong "team spirit" that provides the customers what they are looking for as they travel.</p>
</div>
</div>
<div id="mainContent">
<div id="nav">
<script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','760','height','30','src','images/nav_bar2','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','images/nav_bar2' ); //end AC code
</script>
<noscript>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="760" height="30">
<param name="movie" value="images/nav_bar2.swf" />
<param name="quality" value="high" />
<embed src="images/nav_bar2.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="760" height="30"></embed>
</object>
</noscript>
</div>
<div id="status"><form name="status" method="post" action="bookinginfo.php">
<br>
<br>
<br>
<table class="note" width="90%" align="center" border="0" cellpadding="2" cellspacing="2">
<tbody><tr>
<td colspan="4" class="header" width="100%" align="center"><font size="4" color="royalblue" face="Verdana, Arial, Helvetica, sans-serif"><b class="heading"><span class="header"><font color="#336699">Welcome
To Online B<span class="heading"><span class="heading">us Reservation</span></span></font></span><br>
</b><font size="2" color="#ff0000">Please Select your date of departure and destination to proceed ahead with the booking.</font><font size="2" color="#000000">
</font></font></td>
</tr>
<tr>
<td colspan="4" width="100%"> </td>
</tr>
<tr>
<td font="" face="Verdana, Arial, Helvetica, sans-serif" color="maroon" size="2" width="25%" align="right" height="30">Journey :</td>
<td font="" face="Verdana, Arial, Helvetica, sans-serif" size="2" width="25%" align="left" height="30">
<select id="journey">
<option value = "Sukkur-Karachi-(NonAC)">Sukkur-Karachi-(NonAC)</option>
<option value = "Karachi-Sukkur-(NonAC)">Karachi-Sukkur-(NonAC)</option>
<option value = "Sukkur-Karachi-(AC)">Sukkur-Karachi-(AC)</option>
<option value = "Karachi-Sukkur-(AC)">Karachi-Sukkur-(AC)</option>
<option value = "Karachi-Islamabad-(Volvo)">Karachi-Islamabad-(Volvo)</option>
</select>
</select></td><td font="" face="Verdana, Arial, Helvetica, sans-serif" color="maroon" size="2" width="25%" align="left" height="30">
</td></tr><tr>
<td valign="top" align="right">Journey Date:</td>
</tr>
<!--
<tr>
<td width="100%" colspan=4> </td>
</tr>
-->
<tr>
<td colspan="4" width="100%"><hr width="95%" align="left" noshade="noshade"></td>
</tr>
<tr>
<td colspan="4" width="100%" align="center">
<input type="submit" name="submit" value="submit" >
</td>
</tr>
<tr>
<td colspan="4" align="center"> </td>
</tr>
<!--
<tr>
<td width="100%" align="center" colspan="4">
<div align="left" class="note">
<hr noshade width="95%" align="left">
<font face="Verdana, Arial, Helvetica, sans-serif" size="2"><font color="#000000"><br>
Note :</font></font> <span class="note">Please fill in your departure
and destination stations, number of seats required and the prefered
date of your journey in this page and click on "Check Status" </span></div>
</td>
</tr>
-->
</tbody></table>
</form></td>
</tr>
</tbody></table></div>
<div id="features"></div>
<!-- end #mainContent -->
</div>
<!-- This clearing element should immediately follow the #mainContent div in order to force the #container div to contain all child floats -->
<br class="clearfloat" />
<div id="footer">
<p><a href="aboutus.html">About us</a> |<a href="feedback.html"> Feedback</a> |<a href="faqs.html"> FAQs</a> | <a href="terms.html">Terms & Conditions</a> | <a href="contactus.html">Contact us</a></p>
<p> 2009 Copyright - Shah Abdul Latif University Khairpur</p>
<!-- end #footer -->
</div>
<!-- end #container -->
</div>
</body>
</html>