Ad:

PHP Discussion Thread
Unsolved
Views: 1671

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

May 3rd, 2009

use listbox to insert data?

Expand Post »

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.
http://i41.tinypic.com/epf0ug.jpg

In default situation

http://i39.tinypic.com/2hn6x42.jpg

PHP Syntax (Toggle Plain Text)
<?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 &quot;fast&quot; 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 &quot;team spirit&quot; 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%">&nbsp;</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>&nbsp;</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">&nbsp;</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 &amp; 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>
<?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 &quot;fast&quot; 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 &quot;team spirit&quot; 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%">&nbsp;</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>&nbsp;</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">&nbsp;</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 &amp; 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>

Similar Threads

Saving and displaying data on datagrid! in VB.NET
how can i get the value of listbox?to store data in database? in PHP
Tkinter scoll text area with listbox in Python
fill listbox with data from another table in Visual Basic 4 / 5 / 6
how to validate text file, loading into listbox in Visual Basic 4 / 5 / 6

m-hrt

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since May 2009

Permalink

May 3rd, 2009

Re: use listbox to insert data?

cmon guys i need help????

see line 147 to 148

and the upper php code every thing is ok just tell me how can i put the values for every selection in data base.

m-hrt

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since May 2009

Permalink

May 3rd, 2009

Re: use listbox to insert data?

A couple of questions..
1. Where are you getting those GET names from? Can't see any reference to them in your code..
2. Why are you putting GET data directly into the database.. That's just asking for trouble. Any and all input from a user should be seen cleaned before database entry.
3. What is so important about line 147/148, I see no problems there.

Will Gresham

Reputation Points: 96

Solved Threads: 124

Master Poster

Offline

728 posts
since May 2008

Permalink

May 4th, 2009

Re: use listbox to insert data?

see this line
You are using four fields but five parameters and some commas are missing.

(Toggle Plain Text)


$query="INSERT INTO trip (from,to,coach_type,fare) values ('".$a."','".$b."','".$c."'".$d."'".$e."')";

try this now

it should be either c or d (AC or non AC. not both)


$query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$e')";

Last edited by BzzBee; May 4th, 2009 at 1:16 am.

BzzBee

Reputation Points: 16

Solved Threads: 48

Posting Whiz

Offline

327 posts
since Apr 2009

Permalink

May 4th, 2009

Re: use listbox to insert data?

Click to Expand / Collapse Quote originally posted by BzzBee ...

see this line
You are using four fields but five parameters and some commas are missing.
(Toggle Plain Text)
$query="INSERT INTO trip (from,to,coach_type,fare) values ('".$a."','".$b."','".$c."'".$d."'".$e."')";

try this now

it should be either c or d (AC or non AC. not both)


$query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$e')";
$query="INSERT INTO trip (from,to,coach_type,fare) values ('".$a."','".$b."','".$c."'".$d."'".$e."')"; try this now it should be either c or d (AC or non AC. not both) $query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$e')";

thanx buddy im goin to check this.

i have a text box and i want a calender to be attach to that i have found a calender dont know how to attach where to put that code can u plz help me out on that two
here is the page which have a calender coding + i want only attach to one text box:-

http://blog.davglass.com/files/yui/cal2/

m-hrt

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since May 2009

Permalink

May 4th, 2009

Re: use listbox to insert data?

Click to Expand / Collapse Quote originally posted by xan ...

A couple of questions..
1. Where are you getting those GET names from? Can't see any reference to them in your code..
2. Why are you putting GET data directly into the database.. That's just asking for trouble. Any and all input from a user should be seen cleaned before database entry.
3. What is so important about line 147/148, I see no problems there.

is it ok now??????
i have made 3 combobox one is from other is to and the 3rd is Couch now tell me how can i insert the 3 values of 3 comboboxes to database

my database name is online_bus_project
table name is trip

here is the code i have made some changes check it
PHP CODE

php Syntax (Toggle Plain Text)
<?php
 
if(isset($_POST['submit']))
{
$a = $_POST['Karachi'];
 
$b = $_POST['Sukkur'];
 
$c = $_POST['ac'];
 
$d = $_POST['nonac'];
 
$e = $_POST['550'];
 
mysql_connect("localhost", "root", "password") or die ('Error'.mysqlerror());
 
mysql_select_db("online_bus_project");
 
$query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$e')";
 
mysql_query($query) or die ('Error Cannnot Insert Records!');
 
}
 
?>
<?php

if(isset($_POST['submit']))
{
$a = $_POST['Karachi'];

$b = $_POST['Sukkur'];

$c = $_POST['ac'];

$d = $_POST['nonac'];

$e = $_POST['550'];

mysql_connect("localhost", "root", "password") or die ('Error'.mysqlerror());

mysql_select_db("online_bus_project");

$query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$e')";

mysql_query($query) or die ('Error Cannnot Insert Records!');

}

?>

HTML CODE:

html Syntax (Toggle Plain Text)
<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%">&nbsp;</td>
    </tr>
 
 
 
<tr> 
 
 
  <td font="" face="Verdana, Arial, Helvetica, sans-serif" size="2" width="25%" align="left" height="30"> 
<center>
 
   <br /><center> <strong>From:</strong>  	 	 
	     <select id="from">
 
	<option value = "from1">Karachi</option>
 
	<option value = "from2">Sukkur</option>
 
	</select>
	 <center><br />
	 <strong>To:</strong>          
     <select id="to"></center>
 
	<option value = "to1">Sukkur</option>
 
	<option value = "to2">Karachi</option>
 </select>
 
     <center><br /><strong>Couch:   </strong>
     <select id="couch"></center>
 
	<option value = "couch1">NonAC</option>
 
	<option value = "couch2">AC</option>
 </select>
 
    </select>
 
 
 
    <!--
    <tr>
 
      <td width="100%" colspan=4>&nbsp;</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" value="Submit" /> 
	</form>
      </td>
    </tr>
 
    <tr> 
      <td colspan="4" align="center">&nbsp;</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>
<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%">&nbsp;</td>
    </tr>
    
  
 
<tr> 
  
  
  <td font="" face="Verdana, Arial, Helvetica, sans-serif" size="2" width="25%" align="left" height="30"> 
<center>
  
   <br /><center> <strong>From:</strong>  	 	 
	     <select id="from">

	<option value = "from1">Karachi</option>

	<option value = "from2">Sukkur</option>
		
	</select>
	 <center><br />
	 <strong>To:</strong>          
     <select id="to"></center>

	<option value = "to1">Sukkur</option>

	<option value = "to2">Karachi</option>
 </select>
 
     <center><br /><strong>Couch:   </strong>
     <select id="couch"></center>

	<option value = "couch1">NonAC</option>

	<option value = "couch2">AC</option>
 </select>
	
    </select>
    
    
    
    <!--
    <tr> 
      <td width="100%" colspan=4>&nbsp;</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" value="Submit" /> 
	</form>
      </td>
    </tr>
  
    <tr> 
      <td colspan="4" align="center">&nbsp;</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>

Last edited by Ezzaral; May 4th, 2009 at 3:41 pm. Reason: Added [code] [/code] tags. Please use them to format any code that you post.

m-hrt

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since May 2009

Permalink

May 4th, 2009

Re: use listbox to insert data?

Apart from the fact that your HTML is appalling.. as I said earlier, where are you getting the (in this case) POST from?

You appear to be using the values that the fields have, this is incorrect.
You should be using:

php Syntax (Toggle Plain Text)
    $a = $_POST['to'];
    $b = $_POST['from'];
    $c = $_POST['couch'];
    $e = $_POST['550'];
    $a = $_POST['to'];
    $b = $_POST['from'];
    $c = $_POST['couch'];
    $e = $_POST['550'];

This is not recommended though, the user can modify the data sent to the server through a form, you should look into SQL injection and how to prevent it.

Will Gresham

Reputation Points: 96

Solved Threads: 124

Master Poster

Offline

728 posts
since May 2008

Permalink

May 5th, 2009

Re: use listbox to insert data?

hmmm now i got u. i have to insert values of list box in the $_POST let me try this

m-hrt

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since May 2009

Permalink

May 5th, 2009

Re: use listbox to insert data?

still the same error which is from the navigation bar swf file

which is on the line 70 of HTML code

HTML CODE:

PHP Syntax (Toggle Plain Text)
<!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;
}
#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 &quot;fast&quot; 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 &quot;team spirit&quot; 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%">&nbsp;</td>
    </tr>
 
 
 
<tr> 
 
 
  <td font="" face="Verdana, Arial, Helvetica, sans-serif" size="2" width="25%" align="left" height="30"> 
<center>
 
   <br /><center> <strong>From:</strong>  	 	 
	     <select id="from">
 
	<option value = "from1">Karachi</option>
 
	<option value = "from2">Sukkur</option>
 
	</select>
	 <center><br />
	 <strong>To:</strong>          
     <select id="to"></center>
 
	<option value = "to1">Sukkur</option>
 
	<option value = "to2">Karachi</option>
 </select>
 
     <center><br /><strong>Couch:   </strong>
     <select id="couch"></center>
 
	<option value = "couch1">NonAC</option>
 
	<option value = "couch2">AC</option>
 </select>
 
    </select>
 
 
 
    <!--
    <tr> 
      <td width="100%" colspan=4>&nbsp;</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" value="Submit" name="submit"> 
	</form>
      </td>
    </tr>
 
    <tr> 
      <td colspan="4" align="center">&nbsp;</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 &amp; 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>
<!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;
}
#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 &quot;fast&quot; 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 &quot;team spirit&quot; 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%">&nbsp;</td>
    </tr>
    
  
 
<tr> 
  
  
  <td font="" face="Verdana, Arial, Helvetica, sans-serif" size="2" width="25%" align="left" height="30"> 
<center>
  
   <br /><center> <strong>From:</strong>  	 	 
	     <select id="from">

	<option value = "from1">Karachi</option>

	<option value = "from2">Sukkur</option>
		
	</select>
	 <center><br />
	 <strong>To:</strong>          
     <select id="to"></center>

	<option value = "to1">Sukkur</option>

	<option value = "to2">Karachi</option>
 </select>
 
     <center><br /><strong>Couch:   </strong>
     <select id="couch"></center>

	<option value = "couch1">NonAC</option>

	<option value = "couch2">AC</option>
 </select>
	
    </select>
    
    
    
    <!--
    <tr> 
      <td width="100%" colspan=4>&nbsp;</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" value="Submit" name="submit"> 
	</form>
      </td>
    </tr>
  
    <tr> 
      <td colspan="4" align="center">&nbsp;</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 &amp; 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>

PHP CODE

PHP Syntax (Toggle Plain Text)
<?php
 
if(isset($_POST['submit']))
{
$a = $_POST['from'];
 
$b = $_POST['to'];
 
$c = $_POST['couch'];
 
$d = $_POST['550'];
 
mysql_connect("localhost", "root", "password") or die ('Error'.mysqlerror());
 
mysql_select_db("online_bus_project");
 
$query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c')";
 
mysql_query($query) or die ('Error Cannnot Insert Records!');
 
}
 
?>
<?php

if(isset($_POST['submit']))
{
$a = $_POST['from'];

$b = $_POST['to'];

$c = $_POST['couch'];

$d = $_POST['550'];

mysql_connect("localhost", "root", "password") or die ('Error'.mysqlerror());

mysql_select_db("online_bus_project");

$query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c')";

mysql_query($query) or die ('Error Cannnot Insert Records!');

}

?>

m-hrt

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since May 2009

Permalink

May 5th, 2009

Re: use listbox to insert data?

it looks fine now

BzzBee

Reputation Points: 16

Solved Threads: 48

Posting Whiz

Offline

327 posts
since Apr 2009

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: .htacess file dosent work on main server

Next Thread in PHP Forum Timeline: Update profile

DaniWeb Message

Cancel Changes

User Name
Password