send data at same id?

[obtrs]

i have alot of check boxes and through that check boxex one select seat and send tha seat number to database.

i have a table named called trip in which i have some fields which are ok but they are on the start page user send booking time and selects "from" "to" after sending that there is a page of seat selection when ever im sending data of seat selection it sends data to the other line how can i send that too on the same line as the others are???


im sending data through this its working.

<?php

$connection = mysql_connect("localhost","root","autodeskmaya") or die("error connect");
mysql_select_db("online_bus_project");


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

{

foreach($_POST['team'] as $value) {

$insert="INSERT INTO trip (seat) VALUES ('$value')";

mysql_query($insert);

}

}

?>

[prabirchoudhury]

send data at same id?

it seems like you have a wrong relational data structure or sql injection. so far i am making sense from your question. if i am not wrong then

Problems
1. you are trying to insert data in the same table twice, once for selection dates and other for selecting seat no, then it would come two lines.

2. if you want to put all data in the same table then insertion seat no would be a UPDATE table rather INSERT.

3. But if you have more then one selection for seat no (seat no 10 and 11 ) one column for "seat" in table then it is a wrong structure. would insert into more then one line.. thats probably happening for you in this case.

Solutions.

1. you must have a trip table (say trip ) with each trip details. get the primary key (say trip_id)

2. you must have a main booking table (say booking), get this primary key (say booking_id)

3.Could make a seperate table called "seat" and with booking_id and seat_no fields and booking_id is the foreign key of main booking table that would be filled with

4. have to avoid the over booking for one seat for same trip

Table seat

booking_id | trip_id |  seat_no |




foreach($_POST['team'] as $value) { 
  
$insert="INSERT INTO seat (booking_id, trip_id, seat_no) VALUES ('$booking_id','$trip_id', '$value')"; 
  
mysql_query($insert); 
  

}

might help this ..

[obtrs]

thanx for the help....

so how much fields i make for the seat selection say i made 8 OK so how that would be done if a person say select more than one field how it will insert that into separate fields?

[obtrs]

how can i insert more than one values in this???

<?php

$connection = mysql_connect("localhost","root","autodeskmaya") or die("error connect");
mysql_select_db("online_bus_project");


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

{

foreach($_POST['team'] as $value) {

$insert="INSERT INTO seats (seat) VALUES ('$value')";

mysql_query($insert);

}

}

?>

i have table called seats in this i have these fields "seat, seat_two, seat_three, seat_four, seat_five, seat_six"

if a user wants to reserve more than one fields so he can upto six.


HTML Form:-

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
   
        
  <table width="94%" bgcolor="#cacb98" border="1" cellpadding="0" cellspacing="0">
    <tbody><tr> 
            <td width="12%">  
              <input name="team[]" value="1" type="checkbox">
              <font size="2" face="verdana">1</font>  </td>
            <td width="12%">  
              <input name="team[]" value="2" type="checkbox">
              <font size="2" face="verdana">2</font>  </td>
            <td width="13%">  
              <input name="team[]" value="3" type="checkbox">
              <font size="2" face="verdana">3</font>  </td>
            <td width="13%">  
              <input name="team[]" value="4" type="checkbox">
              <font size="2" face="verdana">4</font>  
            </td>
            <td width="20%">  
              <input name="team[]" value="5" type="checkbox">
              <font size="2" face="verdana">5</font>  </td>
          </tr>
          <tr> 
            <td width="12%">  
              <input name="team[]" value="6" type="checkbox">
              <font size="2" face="verdana">6</font>  </td>
            <td width="12%">  
              <input name="team[]" value="7" type="checkbox">
              <font size="2" face="verdana">7</font>  </td>
            <td width="13%">  
              <input name="team[]" value="8" type="checkbox">
              <font size="2" face="verdana">8</font>  </td>
            <td width="13%">  
              <input name="team[]" value="9" type="checkbox">
              <font size="2" face="verdana">9</font>  </td>
            <td width="20%">  
              <input name="team[]" value="10" type="checkbox">
              <font size="2" face="verdana">10</font>  </td>
          </tr>
          <tr> 
            <td width="12%">  
              <input name="team[]" value="11" type="checkbox">
              <font size="2" face="verdana">11</font>  </td>
            <td width="12%">  
              <input name="team[]" value="12" type="checkbox">
              <font size="2" face="verdana">12</font>  </td>
            <td width="13%">  
              <input name="team[]" value="13" type="checkbox">
              <font size="2" face="verdana">13</font>  </td>
            <td width="13%">  
              <input name="team[]" value="14" type="checkbox">
              <font size="2" face="verdana">14</font>  </td>
            <td width="20%">  
              <input name="team[]" value="15" type="checkbox">
              <font size="2" face="verdana">15</font>  </td>
          </tr>
          <tr> 
            <td width="12%">  
              <input name="team[]" value="16" type="checkbox">
              <font size="2" face="verdana">16</font>  </td>
            <td width="12%">  
              <input name="team[]" value="17" type="checkbox">
              <font size="2" face="verdana">17</font>  </td>
            <td width="13%">  
              <input name="team[]" value="18" type="checkbox">
              <font size="2" face="verdana">18</font>  </td>
            <td width="13%">  
              <input name="team[]" value="19" type="checkbox">
              <font size="2" face="verdana">19</font>  </td>
            <td width="20%">  
              <input name="team[]" value="20" type="checkbox">
              <font size="2" face="verdana">20</font>  </td>
          </tr>
          <tr> 
            <td width="12%">  
              <input name="team[]" value="21" type="checkbox">
              <font size="2" face="verdana">21</font>  </td>
            <td width="12%">  
              <input name="team[]" value="22" type="checkbox">
              <font size="2" face="verdana">22</font>  </td>
            <td width="13%">  
              <input name="team[]" value="23" type="checkbox">
              <font size="2" face="verdana">23</font>  </td>
            <td width="13%">  
              <input name="team[]" value="24" type="checkbox">
              <font size="2" face="verdana">24</font>  </td>
            <td width="20%">  
              <input name="team[]" value="25" type="checkbox">
              <font size="2" face="verdana">25</font>  </td>
          </tr>
          <tr> 
            <td width="12%">  
              <input name="team[]" value="26" type="checkbox">
              <font size="2" face="verdana">26</font>  </td>
            <td width="12%">  
              <input name="team[]" value="27" type="checkbox">
              <font size="2" face="verdana">27</font>  </td>
            <td width="13%">  
              <input name="team[]" value="28" type="checkbox">
              <font size="2" face="verdana">28</font>  </td>
            <td width="13%">  
              <input name="team[]" value="29" type="checkbox">
              <font size="2" face="verdana">29</font>  </td>
            <td width="20%">  
              <input name="team[]" value="30" type="checkbox">
              <font size="2" face="verdana">30</font>  </td>
          </tr>
    <tr>
            <td width="12%">  
              <input name="team[]" value="31" type="checkbox">
              <font size="2" face="verdana">31</font>  </td>
            <td width="12%">  
              <input name="team[]" value="32" type="checkbox"> <font size="2" face="verdana">32</font>
               </td>
            <td width="13%">  
              <input name="team[]" value="33" type="checkbox"> <font size="2" face="verdana">33</font>
               </td>
            <td width="13%">  
              <input name="team[]" value="34" type="checkbox"> <font size="2" face="verdana">34</font>
               
            </td>
            <td width="20%">  
              <input name="team[]" value="35" type="checkbox"> <font size="2" face="verdana">35</font>
               </td>
    </tr>
    <tr>
            <td width="12%">  
              <input name="team[]" value="36" type="checkbox">
              <font size="2" face="verdana">36</font>  </td>
            <td width="12%">  
              <input name="team[]" value="37" type="checkbox">
              <font size="2" face="verdana">37</font>  </td>
            <td width="13%">  
              <input name="team[]" value="38" type="checkbox">
              <font size="2" face="verdana">38</font>  </td>
            <td width="13%">  
              <input name="team[]" value="39" type="checkbox">
              <font size="2" face="verdana">39</font>  </td>
            <td width="20%">  
              <input name="team[]" value="40" type="checkbox"> <font size="2" face="verdana">40</font>
               </td>
    </tr>
          <tr> 
            <td width="12%">  
              <input name="team[]" value="41" type="checkbox"> <font size="2" face="verdana">41</font>
               </td>
            <td width="12%">&nbsp;  </td>
            <td width="13%">&nbsp;  </td>
            <td width="13%">&nbsp;  </td>
            <td width="20%">  </td>
          </tr>
        </tbody></table>
  <p align="center">&nbsp;</p>
  <p></p><table>
      <tbody><tr>
      <td>
        
      <div align="center"><input type="submit" name="submit" value="submit">
      </div>

[prabirchoudhury]

send data at same id

Try this should wrk .. you have to pass the booking_ID and trip_id in hidden field and run a foreach loop to get the seat no checked and then insert each seat no with trip_id and booking_id

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> 
  
  
  <table width="94%" bgcolor="#cacb98" border="1" cellpadding="0" cellspacing="0"> 
    <tbody><tr>  
            <td width="12%">   
              <input name="team[]" value="1" type="checkbox"> 
              <font size="2" face="verdana">1</font>  </td> 
            <td width="12%">   
              <input name="team[]" value="2" type="checkbox"> 
              <font size="2" face="verdana">2</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="3" type="checkbox"> 
              <font size="2" face="verdana">3</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="4" type="checkbox"> 
              <font size="2" face="verdana">4</font>   
            </td> 
            <td width="20%">   
              <input name="team[]" value="5" type="checkbox"> 
              <font size="2" face="verdana">5</font>  </td> 
          </tr> 
          <tr>  
            <td width="12%">   
              <input name="team[]" value="6" type="checkbox"> 
              <font size="2" face="verdana">6</font>  </td> 
            <td width="12%">   
              <input name="team[]" value="7" type="checkbox"> 
              <font size="2" face="verdana">7</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="8" type="checkbox"> 
              <font size="2" face="verdana">8</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="9" type="checkbox"> 
              <font size="2" face="verdana">9</font>  </td> 
            <td width="20%">   
              <input name="team[]" value="10" type="checkbox"> 
              <font size="2" face="verdana">10</font>  </td> 
          </tr> 
          <tr>  
            <td width="12%">   
              <input name="team[]" value="11" type="checkbox"> 
              <font size="2" face="verdana">11</font>  </td> 
            <td width="12%">   
              <input name="team[]" value="12" type="checkbox"> 
              <font size="2" face="verdana">12</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="13" type="checkbox"> 
              <font size="2" face="verdana">13</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="14" type="checkbox"> 
              <font size="2" face="verdana">14</font>  </td> 
            <td width="20%">   
              <input name="team[]" value="15" type="checkbox"> 
              <font size="2" face="verdana">15</font>  </td> 
          </tr> 
          <tr>  
            <td width="12%">   
              <input name="team[]" value="16" type="checkbox"> 
              <font size="2" face="verdana">16</font>  </td> 
            <td width="12%">   
              <input name="team[]" value="17" type="checkbox"> 
              <font size="2" face="verdana">17</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="18" type="checkbox"> 
              <font size="2" face="verdana">18</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="19" type="checkbox"> 
              <font size="2" face="verdana">19</font>  </td> 
            <td width="20%">   
              <input name="team[]" value="20" type="checkbox"> 
              <font size="2" face="verdana">20</font>  </td> 
          </tr> 
          <tr>  
            <td width="12%">   
              <input name="team[]" value="21" type="checkbox"> 
              <font size="2" face="verdana">21</font>  </td> 
            <td width="12%">   
              <input name="team[]" value="22" type="checkbox"> 
              <font size="2" face="verdana">22</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="23" type="checkbox"> 
              <font size="2" face="verdana">23</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="24" type="checkbox"> 
              <font size="2" face="verdana">24</font>  </td> 
            <td width="20%">   
              <input name="team[]" value="25" type="checkbox"> 
              <font size="2" face="verdana">25</font>  </td> 
          </tr> 
          <tr>  
            <td width="12%">   
              <input name="team[]" value="26" type="checkbox"> 
              <font size="2" face="verdana">26</font>  </td> 
            <td width="12%">   
              <input name="team[]" value="27" type="checkbox"> 
              <font size="2" face="verdana">27</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="28" type="checkbox"> 
              <font size="2" face="verdana">28</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="29" type="checkbox"> 
              <font size="2" face="verdana">29</font>  </td> 
            <td width="20%">   
              <input name="team[]" value="30" type="checkbox"> 
              <font size="2" face="verdana">30</font>  </td> 
          </tr> 
    <tr> 
            <td width="12%">   
              <input name="team[]" value="31" type="checkbox"> 
              <font size="2" face="verdana">31</font>  </td> 
            <td width="12%">   
              <input name="team[]" value="32" type="checkbox"> <font size="2" face="verdana">32</font> 
               </td> 
            <td width="13%">   
              <input name="team[]" value="33" type="checkbox"> <font size="2" face="verdana">33</font> 
               </td> 
            <td width="13%">   
              <input name="team[]" value="34" type="checkbox"> <font size="2" face="verdana">34</font> 
  
            </td> 
            <td width="20%">   
              <input name="team[]" value="35" type="checkbox"> <font size="2" face="verdana">35</font> 
               </td> 
    </tr> 
    <tr> 
            <td width="12%">   
              <input name="team[]" value="36" type="checkbox"> 
              <font size="2" face="verdana">36</font>  </td> 
            <td width="12%">   
              <input name="team[]" value="37" type="checkbox"> 
              <font size="2" face="verdana">37</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="38" type="checkbox"> 
              <font size="2" face="verdana">38</font>  </td> 
            <td width="13%">   
              <input name="team[]" value="39" type="checkbox"> 
              <font size="2" face="verdana">39</font>  </td> 
            <td width="20%">   
              <input name="team[]" value="40" type="checkbox"> <font size="2" face="verdana">40</font> 
               </td> 
    </tr> 
          <tr>  
            <td width="12%">   
              <input name="team[]" value="41" type="checkbox"> <font size="2" face="verdana">41</font> 
               </td> 
            <td width="12%">&nbsp;  </td> 
            <td width="13%">&nbsp;  </td> 
            <td width="13%">&nbsp;  </td> 
            <td width="20%">  </td> 
          </tr> 
        </tbody></table> 
  <p align="center">&nbsp;</p> 
  <p></p><table> 
      <tbody><tr> 
      <td> 
  
      <div align="center"><input type="submit" name="submit" value="submit"> 
      </div> 
      <INPUT TYPE="hidden" NAME="booking_id" VALUE=102>
      <INPUT TYPE="hidden" NAME="trip_id" VALUE=10>
      
</form>

<br><br>



<?

//echo "submitred result=".$_POST["booking_id"]."<br>";


foreach($_POST['team'] as $seat=> $value)
{
	$seat =$seat+1;
	echo "The seat no $seat is $value<br>"; 
  $sql = "INSERT into table_name (booking_id, trip_id, seat_no )";
  $sql .= "VALUES ('".$_POST['booking_id']."','".$_POST['trip_id']."','".$value."' )";
  mysql_query($sql)or die("cant execute : $sql");
  
}






?>