use combobox to insert data to database

[obtrs]

I have some code for drop down its not working it gives the errors every thing looks fine to me help me out.


Errors

Notice: Undefined index: from in C:\wamp\www\site\booking.php on line 6
 
Notice: Undefined index: to in C:\wamp\www\site\booking.php on line 8
 
Notice: Undefined index: couch in C:\wamp\www\site\booking.php on line 10
 
Notice: Undefined index: 550 in C:\wamp\www\site\booking.php on line 12
Error Cannnot Insert Records! 

PHP CODE:

<?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'.mysql_error());
 
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!');
 
}
 
?>

HTML CODE:

<div id="status"><form name="status" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
              <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 = "karachi">Karachi</option>
 
    <option value = "sukkur">Sukkur</option>
 
    </select>
     <center><br />
     <strong>To:</strong>**********
     <select id="to"></center>
 
    <option value = "sukkur">Sukkur</option>
 
    <option value = "karachi">Karachi</option>
 </select>
 
     <center><br /><strong>Couch:***</strong>
     <select id="couch"></center>
 
    <option value = "nonac">NonAC</option>
 
    <option value = "ac">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>

[Dormilich]

add the mentioned indices as name attribute.

ex.

<select name="from" id="from">

[obtrs]

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

But what about

$d = $_POST['550'];

its not in the list i want this to be inserted that's the rent its same for all.

Error:

Notice: Undefined index: 550 in C:\wamp\www\site\booking.php on line 12
Error Cannnot Insert Records!

[Markus]

Declare $d's value yourself then.

$d = 550;
 

[obtrs]

Declared $d value its not working same error but removing this by removing $d value it also gives error message !cannot insert record

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

This one

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

[obtrs]

cmon guys im waiting?

[Markus]

@obtrs
Patience is a virtue.

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

mysql_query(...) or die(mysql_error());
 

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.

[obtrs]

Patience is a virtue.

sorry my bad

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

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

the last one $d.

Error

Notice: Undefined index: 550 in C:\wamp\www\site\booking.php on line 12
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:

$d = $_POST['550'];

[obtrs]

its showing that the 550 is empty ' ' i have declare it do i have to declare it any where else too?

[Markus]

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.

$d = 550;
 

[obtrs]

i didn't got that???

[obtrs]

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

[Dormilich]

@obtrs
you don't have to put it directly in the SQL, but it's a good idea, esp. when the value doesn't change.

[obtrs]

its not working either this way or that is there any thing wrong with the 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'.mysql_error());
 
mysql_select_db("online_bus_project");
 
 
$query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$d')";
 
 
 
mysql_query($query) or die (mysql_error());
 
}
 
?>
 
 
 
 
<!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="<?php echo $_SERVER['PHP_SELF']; ?>">
              <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 name="from" id="from">
 
    <option value = "karachi">Karachi</option>
 
    <option value = "sukkur">Sukkur</option>
 
    </select>
     <center><br />
     <strong>To:</strong>**********
     <select name="to" id="to"></center>
 
    <option value = "sukkur">Sukkur</option>
 
    <option value = "karachi">Karachi</option>
 </select>
 
     <center><br /><strong>Couch:***</strong>
     <select name="couch" id="couch"></center>
 
    <option value = "nonac">NonAC</option>
 
    <option value = "ac">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>
 

[Markus]

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

[obtrs]

<moderator note: i accidently overwrote the contents of this post>

[Markus]

You're trying to insert into 4 columns but only providing 3 values. Try something like

INSERT INTO `table` ('from, to, coach_type, fare) VALUES ('sukkur', 'karachi', 'nonac')
 

[obtrs]

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

PHP CODE:

<?php
 
 
if(isset($_POST['submit']))
{
$a = $_POST['from'];
 
$b = $_POST['to'];
 
 
 
 
 
 
 
mysql_connect("localhost", "root", "password") or die ('Error'.mysql_error());
 
mysql_select_db("online_bus_project");
 
 
$query="INSERT INTO trip (from,to) values ('$a','$b')";
 
 
 
mysql_query($query) or die (mysql_error());
 
}
 
?>

HTML CODE:

<form name="status" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
              <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 name="from" id="from">
 
    <option value = "karachi">Karachi</option>
 
    <option value = "sukkur">Sukkur</option>
 
    </select>
     <center><br />
     <strong>To:</strong>**********
     <select name="to" id="to"></center>
 
    <option value = "sukkur">Sukkur</option>
 
    <option value = "karachi">Karachi</option>
 </select>

[Markus]

What error?

[obtrs]

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.

mysql_query("INSERT INTO test2 (name, dob, gender, country) VALUES ('$_POST[name]', '$_POST[dob]', '$_POST[gender]', '$_POST[country]')");