use combo box to insert data?

m-hrt · May 1, 2009

i have a combo box available in my page and that combobox have these items.

And a text field for the journey date:

and i have trip named database 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 combobox it will inserts that that info to these fealds 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

infare it insert 550

after that i have a field whihc 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.

<!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 name="serviceNo" style="font-size: 8pt;">
 <!-- <option selected>Select Journey From</option> -->

      <option style="" value="29">Sukkur-Karachi-(NonAC)</option>
      
      <option style="" value="34">Karachi-Sukkur-(NonAC)</option>
      
      <option style="color: darkblue;" value="37">Sukkur-Karachi-(AC)</option>
      
      <option style="" value="39">Karachi-Sukkur-(AC)</option>
      
      <option style="" value="40">Karachi-Islamabad-(Volvo)</option>
      
</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>

              <td nowrap="nowrap"><input name="date" class="text_box" value="" size="20"> 

              <td class="table_text" align="left"> </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>

ignace · May 1, 2009

Please post the php code if any

m-hrt · May 1, 2009

have some but i dont understand how to use it havent worked with combobox that's why.

<?php
// Connect to the db server and select a database
$conn = mysql_connect("localhost", "root", "")
or die("Can't connect to database!");
mysql_select_db("online_bus_project")
or die("Can't select database!");
// Retrieve the language table data
$query = "SELECT id,from FROM trip ORDER BY name";
$result = mysql_query($query)
// Create an associative array based on the table data
while($row = mysql_fetch_array($result))
{
$value = $row["id"];
$name = $row["from"];
$pairs["$value"] = $name;
}
echo "Choose your preferred language: <br />";
echo create_dropdown("language",$pairs,"Choose One:");



function create_dropdown($identifier,$pairs,$firstentry,$multiple="")
{
// Start the dropdown list with the <select> element and title
$dropdown = "<select name=\"$identifier\" multiple=\"$multiple\">";
$dropdown .= "<option name=\"\">$firstentry</option>";
// Create the dropdown elements
foreach($pairs AS $value => $name)
{
$dropdown .= "<option name=\"$value\">$name</option>";
}
// Conclude the dropdown and return it
echo "</select>";
return $dropdown;
}




?>

m-hrt · May 1, 2009

is it going to work or i have to do some thing else? help me out can u plz generate ur own code to help me out.

m-hrt · May 1, 2009

some more------

<?php

  // Connect to the database
  mysql_connect("localhost", "root", "") or die(mysql_error());
  mysql_select_db("trip") or die(mysql_error());

  // Has the form been submitted?
  if (isset($_POST['item'])) {

    // The form has been submitted, query results
    $queryitem = "SELECT * FROM table WHERE item = '".$_POST['item']."';";

    // Successful query?
    if($result = mysql_query($queryitem))  {

      // More than 0 results returned?
      if($success = mysql_num_rows($result) > 0) {

        // For each result returned, display it
        while ($row = mysql_fetch_array($result)) echo $row[serial];
      }
      // Otherwise, no results, tell user
      else { echo "No results found."; }
    }
    // Error connecting? Tell user
    else { echo "Failed to connect to database."; }
  }
  // The form has NOT been submitted, so show the form instead of results
  else {

    // Create the form, post to the same file
    echo "<form method='post' action='example.php'>";

    // Form a query to populate the combo-box
    $queryitem = "SELECT DISTINCT item FROM table;";

    // Successful query?
    if($result = mysql_query($queryitem))  {

      // If there are results returned, prepare combo-box
      if($success = mysql_num_rows($result) > 0) {
        // Start combo-box
        echo "<select name='item'>\n";
        echo "<option>-- Select Item --</option>\n";

        // For each item in the results...
        while ($row = mysql_fetch_array($result))
          // Add a new option to the combo-box
          echo "<option value='$row[item]'>$row[item]</option>\n";

        // End the combo-box
        echo "</select>\n";
      }
      // No results found in the database
      else { echo "No results found."; }
    }
    // Error in the database
    else { echo "Failed to connect to database."; }

    // Add a submit button to the form
    echo "<input type='submit' value='Submit' /></form>";
  }
?>

JD* · May 1, 2009

You have two ways of doing it.

Currently, you're doing one of them, where you re-query the database with the submitted item, which you can then use to grab all of the information and insert that into another table.

Another way of doing it is to make the value of each of your options the $row[item].'-'.$row[fare], and on your processing page, you can explode the posted value into an array based on the '-' character, since it looks like each part of your journeys uses that to separate what you need to collect, except for the price.

So what you'd have is:

$trip = explode('-', $_POST['item']);
print_r($trip);

The print_r will show the following:

Array
(
    [0] => sukkur
    [1] => karachi
    [2] => nonac
    [3] => 550
)

And that should let you construct your query.

Additionally, if you want your database to be truly relational, you could just store the ID of the journey and then reference your journey table with that ID to get all of the values.

m-hrt · May 1, 2009

thanx JD for the help man u rock.

can u please write the code because im new in programming.

ill appreciate

premiso · May 1, 2009

can u please write the code because im new in programming.

This forum is not to ask people to write code for you. Put forth an effort and try and show us the code you tried if it does not work. Or place this in the freelance section and hopefully someone is willing to do it, but it may cost you some money.

m-hrt · May 4, 2009

i have worked on this now tell me how to bypass this its giving error on 103 line which has a swf navigation.

i have changed some stuffs

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

if(isset($_POST['submit']))

{

$a = $_POST['from'];

$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!');

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--[if IE 5]>

/* place css box model fixes for IE 5* in this conditional comment */

.twoColFixRtHdr #sidebar1 { width: 220px; }

</style>

<![endif]--><!--[if IE]>

/* 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]-->

<!--

.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>

<p class="style2">Casual Dining Restaurants</p>

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>

<span class="style1">Convenience Stores</span></p>

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>

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>

This line is 103 <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">

</object>

</noscript>

</div>

<br>

<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>

</tr>

<tr>

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

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

</select>

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

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

</select>

<center><br /><strong>Couch: </strong>

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

</select>

<!--

<tr>

</tr>

-->

<tr>

</tr>

<tr>

</form>

</td>

</tr>

<tr>

</tr>

<!--

<tr>

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>

<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>

</div>

</div>

</body>

</html>

m-hrt · May 5, 2009

every thing is fine now coding looks perfect still the same error on line 103

line 103:-

param name="movie" value="images/nav_bar2.swf"/>

<CODE><?php

if(isset($_POST['submit']))

{

$a = $_POST['from'];

$b = $_POST['to'];

$c = $_POST['couch'];

$d = $_POST['550'];

mysql_connect("localhost", "root", "autodeskmaya") 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!');

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--[if IE 5]>

/* place css box model fixes for IE 5* in this conditional comment */

.twoColFixRtHdr #sidebar1 { width: 220px; }

</style>

<![endif]--><!--[if IE]>

/* 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]-->

<!--

.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>

<p class="style2">Casual Dining Restaurants</p>

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>

<span class="style1">Convenience Stores</span></p>

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>

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>

</object>

</noscript>

</div>

<br>

<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>

</tr>

<tr>

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

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

</select>

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

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

</select>

<center><br /><strong>Couch: </strong>

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

</select>

<!--

<tr>

</tr>

-->

<tr>

</tr>

<tr>

</form>

</td>

</tr>

<tr>

</tr>

<!--

<tr>

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>

<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>

</div>

</div>

</body>

</html>

Sign In

use combo box to insert data?

Recommended Posts

m-hrt

Link to comment

Share on other sites

ignace

Link to comment

Share on other sites

m-hrt

Link to comment

Share on other sites

m-hrt

Link to comment

Share on other sites

m-hrt

Link to comment

Share on other sites

JD*

Link to comment

Share on other sites

m-hrt

Link to comment

Share on other sites

premiso

Link to comment

Share on other sites

m-hrt

Link to comment

Share on other sites

m-hrt

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information