Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > php > answers

use combobox to insert data to database

Newbie
  
Join Date: May 2009
Posts: 27
#1: May 6 '09
I have some code for drop down its not working it gives the errors every thing looks fine to me help me out.


Errors

Expand|Select|Wrap|Line Numbers
  1. Notice: Undefined index: from in C:\wamp\www\site\booking.php on line 6
  2.  
  3. Notice: Undefined index: to in C:\wamp\www\site\booking.php on line 8
  4.  
  5. Notice: Undefined index: couch in C:\wamp\www\site\booking.php on line 10
  6.  
  7. Notice: Undefined index: 550 in C:\wamp\www\site\booking.php on line 12
  8. Error Cannnot Insert Records! 




PHP CODE:

Expand|Select|Wrap|Line Numbers
  1. <?php
  2.  
  3.  
  4. if(isset($_POST['submit']))
  5. {
  6. $a = $_POST['from'];
  7.  
  8. $b = $_POST['to'];
  9.  
  10. $c = $_POST['couch'];
  11.  
  12. $d = $_POST['550'];
  13.  
  14.  
  15.  
  16. mysql_connect("localhost", "root", "password") or die ('Error'.mysql_error());
  17.  
  18. mysql_select_db("online_bus_project");
  19.  
  20.  
  21. $query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c')";
  22.  
  23.  
  24.  
  25. mysql_query($query) or die ('Error Cannnot Insert Records!');
  26.  
  27. }
  28.  
  29. ?>


HTML CODE:


Expand|Select|Wrap|Line Numbers
  1. <div id="status"><form name="status" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  2.               <br>
  3.   <br>
  4.   <br>
  5.   <table class="note" width="90%" align="center" border="0" cellpadding="2" cellspacing="2">
  6.     <tbody><tr> 
  7.       <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 
  8.         To Online B<span class="heading"><span class="heading">us Reservation</span></span></font></span><br>
  9.         </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"> 
  10.         </font></font></td>
  11.     </tr>
  12.     <tr> 
  13.       <td colspan="4" width="100%">&nbsp;</td>
  14.     </tr>
  15.  
  16.  
  17.  
  18. <tr> 
  19.  
  20.  
  21.   <td font="" face="Verdana, Arial, Helvetica, sans-serif" size="2" width="25%" align="left" height="30"> 
  22. <center>
  23.  
  24.    <br /><center> <strong>From:</strong>            
  25.     *****<select id="from">
  26.  
  27.     <option value = "karachi">Karachi</option>
  28.  
  29.     <option value = "sukkur">Sukkur</option>
  30.  
  31.     </select>
  32.      <center><br />
  33.      <strong>To:</strong>**********
  34.      <select id="to"></center>
  35.  
  36.     <option value = "sukkur">Sukkur</option>
  37.  
  38.     <option value = "karachi">Karachi</option>
  39.  </select>
  40.  
  41.      <center><br /><strong>Couch:***</strong>
  42.      <select id="couch"></center>
  43.  
  44.     <option value = "nonac">NonAC</option>
  45.  
  46.     <option value = "ac">AC</option>
  47.  </select>
  48.  
  49.     </select>
  50.  
  51.  
  52.  
  53.     <!--
  54.     <tr> 
  55.       <td width="100%" colspan=4>&nbsp;</td>
  56.     </tr>
  57.     -->
  58.     <tr> 
  59.       <td colspan="4" width="100%"><hr width="95%" align="left" noshade="noshade"></td>
  60.     </tr>
  61.  
  62.  
  63.    <tr> 
  64.       <td colspan="4" width="100%" align="center"> 
  65.  
  66.  
  67.     <input type="submit" value="Submit" name="submit"> 
  68.     </form>

Dormilich's Avatar
Moderator
  
Join Date: Aug 2008
Location: Leipzig, Germany
Posts: 3,652
#2: May 6 '09

re: use combobox to insert data to database

add the mentioned indices as name attribute.

ex.
Expand|Select|Wrap|Line Numbers
  1. <select name="from" id="from">
Newbie
  
Join Date: May 2009
Posts: 27
#3: May 6 '09

re: use combobox to insert data to database

thanx for the help DORMILICH so many errors gone by adding name.

But what about
Expand|Select|Wrap|Line Numbers
  1. $d = $_POST['550'];
its not in the list i want this to be inserted that's the rent its same for all.

Error:

Expand|Select|Wrap|Line Numbers
  1. Notice: Undefined index: 550 in C:\wamp\www\site\booking.php on line 12
  2. Error Cannnot Insert Records!
Markus's Avatar
Moderator
  
Join Date: Jun 2007
Location: York, England, with wolves.
Posts: 4,947
#4: May 6 '09

re: use combobox to insert data to database

Declare $d's value yourself then.

Expand|Select|Wrap|Line Numbers
  1. $d = 550;
  2.  
Newbie
  
Join Date: May 2009
Posts: 27
#5: May 7 '09

re: use combobox to insert data to database

Declared $d value its not working same error but removing this by removing $d value it also gives error message !cannot insert record
Expand|Select|Wrap|Line Numbers
  1. $query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$d')";
  2.  

This one

Expand|Select|Wrap|Line Numbers
  1. mysql_query($query) or die ('Error Cannnot Insert Records!');
Newbie
  
Join Date: May 2009
Posts: 27
#6: May 7 '09

re: use combobox to insert data to database

cmon guys im waiting?
Markus's Avatar
Moderator
  
Join Date: Jun 2007
Location: York, England, with wolves.
Posts: 4,947
#7: May 7 '09

re: use combobox to insert data to database

Quote:

Originally Posted by obtrs View Post

cmon guys im waiting?

Patience is a virtue.

add mysql_error() to your die() call. If there's a mysql error, it'll give you the info.

Expand|Select|Wrap|Line Numbers
  1. mysql_query(...) or die(mysql_error());
  2.  
Please note: for lack of a better term, Bytes.com is a privilege, not a right. Until you start paying us cash, you'll have to wait until one of our kind experts takes time out of his day to give you help.

Moderator.
Newbie
  
Join Date: May 2009
Posts: 27
#8: May 7 '09

re: use combobox to insert data to database

Quote:
Patience is a virtue.
sorry my bad

same 550 fare error even i have declared it in $query

Expand|Select|Wrap|Line Numbers
  1. $query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$d')";
the last one $d.

Error

Expand|Select|Wrap|Line Numbers
  1. Notice: Undefined index: 550 in C:\wamp\www\site\booking.php on line 12
  2. You have an error in your SQL syntax; from,to,coach_type,fare)values ('karachi','sukkur','nonac','')' at line 1
database has the same value as shown from,to,coach_type,fare


line 12 in which the error showing:

Expand|Select|Wrap|Line Numbers
  1. $d = $_POST['550'];
Newbie
  
Join Date: May 2009
Posts: 27
#9: May 7 '09

re: use combobox to insert data to database

its showing that the 550 is empty ' ' i have declare it do i have to declare it any where else too?
Markus's Avatar
Moderator
  
Join Date: Jun 2007
Location: York, England, with wolves.
Posts: 4,947
#10: May 7 '09

re: use combobox to insert data to database

You haven't declared it. You point it to a none-existent index in the POST array.

When I said 'declare its value yourself', I meant assign it's value (550) because you said that was a constant.

Expand|Select|Wrap|Line Numbers
  1. $d = 550;
  2.  
Newbie
  
Join Date: May 2009
Posts: 27
#11: May 7 '09

re: use combobox to insert data to database

i didn't got that???
Newbie
  
Join Date: May 2009
Posts: 27
#12: May 7 '09

re: use combobox to insert data to database

u mean that i have to use the value instead of variable $d i have to put direct 550 in values?
Dormilich's Avatar
Moderator
  
Join Date: Aug 2008
Location: Leipzig, Germany
Posts: 3,652
#13: May 7 '09

re: use combobox to insert data to database

Quote:

Originally Posted by obtrs View Post

u mean that i have to use the value instead of variable $d i have to put direct 550 in values?

you don't have to put it directly in the SQL, but it's a good idea, esp. when the value doesn't change.
Newbie
  
Join Date: May 2009
Posts: 27
#14: May 7 '09

re: use combobox to insert data to database

its not working either this way or that is there any thing wrong with the code?


Expand|Select|Wrap|Line Numbers
  1. <?php
  2.  
  3.  
  4. if(isset($_POST['submit']))
  5. {
  6. $a = $_POST['from'];
  7.  
  8. $b = $_POST['to'];
  9.  
  10. $c = $_POST['couch'];
  11.  
  12. $d = $_POST['550'];
  13.  
  14.  
  15.  
  16. mysql_connect("localhost", "root", "autodeskmaya") or die ('Error'.mysql_error());
  17.  
  18. mysql_select_db("online_bus_project");
  19.  
  20.  
  21. $query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$d')";
  22.  
  23.  
  24.  
  25. mysql_query($query) or die (mysql_error());
  26.  
  27. }
  28.  
  29. ?>
  30.  
  31.  
  32.  
  33.  
  34. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  35. <html xmlns="http://www.w3.org/1999/xhtml">
  36. <head>
  37. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  38. <title>Untitled Document</title>
  39. <link href="obrs.css" rel="stylesheet" type="text/css" />
  40. <!--[if IE 5]>
  41. <style type="text/css"> 
  42. /* place css box model fixes for IE 5* in this conditional comment */
  43. .twoColFixRtHdr #sidebar1 { width: 220px; }
  44. </style>
  45. <![endif]--><!--[if IE]>
  46. <style type="text/css"> 
  47. /* place css fixes for all versions of IE in this conditional comment */
  48. .twoColFixRtHdr #sidebar1 { padding-top: 30px; }
  49. .twoColFixRtHdr #mainContent { zoom: 1; }
  50. /* the above proprietary zoom property gives IE the hasLayout it needs to avoid several bugs */
  51. </style>
  52. <![endif]-->
  53. <script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
  54. <style type="text/css">
  55. <!--
  56. .style1 {
  57.     color: #FFFF00;
  58.     font-weight: bold;
  59. }
  60. .style2 {
  61.     color: #FFFF66;
  62.     font-weight: bold;
  63. }
  64. #apDiv1 {
  65.     position:absolute;
  66.     left:35px;
  67.     top:168px;
  68.     width:621px;
  69.     height:362px;
  70.     z-index:1;
  71. }
  72. -->
  73. </style>
  74.  
  75.  
  76. </head>
  77.  
  78. <body class="twoColFixRtHdr">
  79. <div id="container">
  80.   <div id="header">
  81.     <!-- end #header -->
  82.     <img src="images/header" alt="OBTRS: Header" /></div>
  83.   <div id="sidebar1">
  84.     <!-- end #sidebar1 -->
  85.     <img src="images/sidebar_slideshow" alt="" />
  86.     <div id="blogarea">
  87.       <p class="style2">Casual Dining Restaurants</p>
  88.       <p><br />
  89.         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>
  90.       <p><br />
  91.           <span class="style1">Convenience Stores</span></p>
  92.       <p><br />
  93.         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>
  94.     </div>
  95.   </div>
  96.   <div id="mainContent">
  97.     <div id="nav">
  98.       <script type="text/javascript">
  99. 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
  100.     </script>
  101.       <noscript>
  102.       <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">
  103.         <param name="movie" value="images/nav_bar2.swf">
  104.         <param name="quality" value="high" />
  105.         <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>
  106.       </object>
  107.       </noscript>
  108.     </div>
  109.  
  110.     <div id="status"><form name="status" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  111.               <br>
  112.   <br>
  113.   <br>
  114.  
  115.  
  116.  
  117.   <table class="note" width="90%" align="center" border="0" cellpadding="2" cellspacing="2">
  118.     <tbody><tr> 
  119.       <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 
  120.         To Online B<span class="heading"><span class="heading">us Reservation</span></span></font></span><br>
  121.         </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"> 
  122.         </font></font></td>
  123.     </tr>
  124.     <tr> 
  125.       <td colspan="4" width="100%">&nbsp;</td>
  126.     </tr>
  127.  
  128.  
  129.  
  130. <tr> 
  131.  
  132.  
  133.   <td font="" face="Verdana, Arial, Helvetica, sans-serif" size="2" width="25%" align="left" height="30"> 
  134. <center>
  135.  
  136.    <br /><center> <strong>From:</strong>            
  137.     *****<select name="from" id="from">
  138.  
  139.     <option value = "karachi">Karachi</option>
  140.  
  141.     <option value = "sukkur">Sukkur</option>
  142.  
  143.     </select>
  144.      <center><br />
  145.      <strong>To:</strong>**********
  146.      <select name="to" id="to"></center>
  147.  
  148.     <option value = "sukkur">Sukkur</option>
  149.  
  150.     <option value = "karachi">Karachi</option>
  151.  </select>
  152.  
  153.      <center><br /><strong>Couch:***</strong>
  154.      <select name="couch" id="couch"></center>
  155.  
  156.     <option value = "nonac">NonAC</option>
  157.  
  158.     <option value = "ac">AC</option>
  159.  </select>
  160.  
  161.     </select>
  162.  
  163.  
  164.  
  165.     <!--
  166.     <tr> 
  167.       <td width="100%" colspan=4>&nbsp;</td>
  168.     </tr>
  169.     -->
  170.     <tr> 
  171.       <td colspan="4" width="100%"><hr width="95%" align="left" noshade="noshade"></td>
  172.     </tr>
  173.  
  174.  
  175.    <tr> 
  176.       <td colspan="4" width="100%" align="center"> 
  177.  
  178.  
  179.     <input type="submit" value="Submit" name="submit"> 
  180.     </form>
  181.       </td>
  182.     </tr>
  183.  
  184.     <tr> 
  185.       <td colspan="4" align="center">&nbsp;</td>
  186.     </tr>
  187.  
  188. <!--
  189.     <tr> 
  190.       <td width="100%" align="center" colspan="4"> 
  191.         <div align="left" class="note"> 
  192.           <hr noshade width="95%" align="left">
  193.           <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><font color="#000000"><br>
  194.           Note :</font></font> <span class="note">Please fill in your departure 
  195.           and destination stations, number of seats required and the prefered 
  196.           date of your journey in this page and click on "Check Status" </span></div>
  197.       </td>
  198.     </tr>
  199.     -->
  200.  
  201.   </tbody></table>
  202.  
  203.     </form></td>
  204.     </tr>
  205.     </tbody></table></div>
  206.     <div id="features"></div>
  207.     <!-- end #mainContent -->
  208.   </div>
  209.   <!-- This clearing element should immediately follow the #mainContent div in order to force the #container div to contain all child floats -->
  210.   <br class="clearfloat" />
  211.   <div id="footer">
  212.     <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>
  213.     <p> 2009 Copyright - Shah Abdul Latif University Khairpur</p>
  214.     <!-- end #footer -->
  215.   </div>
  216.   <!-- end #container -->
  217. </div>
  218.  
  219. </body>
  220. </html>
  221.  
Markus's Avatar
Moderator
  
Join Date: Jun 2007
Location: York, England, with wolves.
Posts: 4,947
#15: May 7 '09

re: use combobox to insert data to database

Reread what I posted. You're still trying to assign $d to a variable that doesn't exist!

Change $d = $_POST['550'] to just $d = 550
Newbie
  
Join Date: May 2009
Posts: 27
#16: May 7 '09

re: use combobox to insert data to database

<moderator note: i accidently overwrote the contents of this post>
Markus's Avatar
Moderator
  
Join Date: Jun 2007
Location: York, England, with wolves.
Posts: 4,947
#17: May 7 '09

re: use combobox to insert data to database

You're trying to insert into 4 columns but only providing 3 values. Try something like
Expand|Select|Wrap|Line Numbers
  1. INSERT INTO `table` ('from, to, coach_type, fare) VALUES ('sukkur', 'karachi', 'nonac')
  2.  
Newbie
  
Join Date: May 2009
Posts: 27
#18: May 8 '09

re: use combobox to insert data to database

tried every thing just stuck with this error i have deleted some unnecessary things now i have this code with same error:

PHP CODE:

Expand|Select|Wrap|Line Numbers
  1. <?php
  2.  
  3.  
  4. if(isset($_POST['submit']))
  5. {
  6. $a = $_POST['from'];
  7.  
  8. $b = $_POST['to'];
  9.  
  10.  
  11.  
  12.  
  13.  
  14.  
  15.  
  16. mysql_connect("localhost", "root", "password") or die ('Error'.mysql_error());
  17.  
  18. mysql_select_db("online_bus_project");
  19.  
  20.  
  21. $query="INSERT INTO trip (from,to) values ('$a','$b')";
  22.  
  23.  
  24.  
  25. mysql_query($query) or die (mysql_error());
  26.  
  27. }
  28.  
  29. ?>

HTML CODE:
Expand|Select|Wrap|Line Numbers
  1. <form name="status" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  2.               <br>
  3.   <br>
  4.   <br>
  5.  
  6.  
  7.  
  8.   <table class="note" width="90%" align="center" border="0" cellpadding="2" cellspacing="2">
  9.     <tbody><tr> 
  10.       <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 
  11.         To Online B<span class="heading"><span class="heading">us Reservation</span></span></font></span><br>
  12.         </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"> 
  13.         </font></font></td>
  14.     </tr>
  15.     <tr> 
  16.       <td colspan="4" width="100%">&nbsp;</td>
  17.     </tr>
  18.  
  19.  
  20.  
  21. <tr> 
  22.  
  23.  
  24.   <td font="" face="Verdana, Arial, Helvetica, sans-serif" size="2" width="25%" align="left" height="30"> 
  25. <center>
  26.  
  27.    <br /><center> <strong>From:</strong>            
  28.     *****<select name="from" id="from">
  29.  
  30.     <option value = "karachi">Karachi</option>
  31.  
  32.     <option value = "sukkur">Sukkur</option>
  33.  
  34.     </select>
  35.      <center><br />
  36.      <strong>To:</strong>**********
  37.      <select name="to" id="to"></center>
  38.  
  39.     <option value = "sukkur">Sukkur</option>
  40.  
  41.     <option value = "karachi">Karachi</option>
  42.  </select>
Markus's Avatar
Moderator
  
Join Date: Jun 2007
Location: York, England, with wolves.
Posts: 4,947
#19: May 8 '09

re: use combobox to insert data to database

What error?
Newbie
  
Join Date: May 2009
Posts: 27
#20: May 8 '09

re: use combobox to insert data to database

Marcus thanx for the help buddy u helped alot i really appreciate every time i have posted u replied man thanx.

its working now with this direct way.


made another php and database for testing purpose working.
Expand|Select|Wrap|Line Numbers
  1. mysql_query("INSERT INTO test2 (name, dob, gender, country) VALUES ('$_POST[name]', '$_POST[dob]', '$_POST[gender]', '$_POST[country]')"); 
  2.  
Reply

« previous question | next question »

Similar PHP bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,449 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved