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_t ype,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;