1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 1:59 am Apr 29, 2026

Forum Moderators: coopster

Message Too Old, No Replies

show color on table if a user select a seat?

         

Meer

10:26 am on May 17, 2009 (gmt 0)

10+ Year Member



i want this to be happen defult color of seats i mean available color of seats to be green after that if a user book a ticket it goes to red and stays red how can i do this?

code im using

<?php

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

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

{

header("location: http://example.com/site/ticketregistration.php");

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

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

mysql_query($insert);

}

}

?>

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></td>
</tr>

[edited by: dreamcatcher at 8:38 pm (utc) on May 17, 2009]
[edit reason] use example.com. Thanks. [/edit]

Meer

3:40 pm on May 17, 2009 (gmt 0)

10+ Year Member



any one?

enigma1

10:01 am on May 18, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



first you need a query to retrieve from the database the seats that are booked. I am not sure how the seat table structure is setup.

//
$seat_array = array();
$sql_query = mysql_query("select seat from seat");
while( $tmp = mysql_fetch_array($sql_query) ) {
$seat_array[] = $tmp['seat'];
}

if( count($seat_array) >= 40 ) {
// All booked - do something
}

Now in the html (inside the form) you could setup a loop to setup all the checkboxes that represent available seats.
<?php
$seat_array = array_flip($seat_array);
for( $i=1, $j=41; $i<$j; $i++ ) {
if( isset($seat_array[$i]) ) {
// Booked display red
echo '<td class="red">Booked</td>';
} else {
// Available, display green
echo '<td class="green"><input name="team[]" value="' . $i . '" type="checkbox"></td>'
}
}
?>

You need to redo the formating within the loop and add some css for the table/cells.

Meer

10:23 am on May 19, 2009 (gmt 0)

10+ Year Member



thanx for the help enigma but i havent got any thing from this can u define more clearly plz.

Meer

10:25 am on May 19, 2009 (gmt 0)

10+ Year Member



table structure of seat have only 2 fields as shown:

Table "seat"

* id
* seat

enigma1

1:03 pm on May 22, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



yea sure, here is the code that should work. Basically you do not need to repeat the cells, I placed a couple of loops so you can specify the max number of seats and cells per line. 


<?php
 define('MAX_SEATS', 40);
 define('ROW_CELLS', 5);
 $connection = mysql_connect("localhost","root","password") or die("error connect");
 mysql_select_db("online_bus_project"); 
 if( isset($_POST['team']) && is_array($_POST['team']) ) {
  //header("location: http://example.com/site/ticketregistration.php");
  foreach($_POST['team'] as $key => $value) {
   $insert="INSERT INTO seat (id, seat) VALUES ('$key', '$value')";
   mysql_query($insert);
  }
 } 
 $seat_array = array();
 $sql_query = mysql_query("select id, seat from seat");
 while( $tmp = mysql_fetch_array($sql_query) ) {
  $seat_array[$tmp['id']] = $tmp['seat'];
 }
 if( count($seat_array) >= MAX_SEATS ) {
  // All booked - do something
  header("location: http://example.com/site/allbooked.php");
  exit();
 }
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table width="94%" bgcolor="#cacb98" border="1" cellpadding="0" cellspacing="0">
<?php
 for( $i=0; $i<MAX_SEATS;) {
  echo '<tbody>' . "\n";
  echo '<tr>' . "\n";
  for($j=0; $j<ROW_CELLS; $j++,$i++) {
   echo '<td width="12%">';
   if( !isset($seat_array[$i]) ) {
    echo '<input name="team[' . $i . ']" value="' . ($i+1) . '" type="checkbox" />';
    echo '<font style="font-family:Verdana; font-size: 10px; font-weight:bold; color: #005500;">' . ($i+1) . '</font>';
   } else {
    echo '<font style="font-family:Verdana; font-size: 10px; font-weight:bold; color: #ff0000;">Booked</font>';
   }
   echo '</td>' . "\n";
  }
  echo '</tr>';
  echo '<tr><td colspan="' . ROW_CELLS . '" width="' . (int)(100/ROW_CELLS) . '%">&nbsp;</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></td>
</tr>
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

  1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 1:59 am Apr 29, 2026