php seat map

[stanghelle]

hi can anyone help me make a seat map for this ? 
 

<form action="vars.php" method="post" class="niceform">
 <fieldset>
    	<legend>Velg / Valgt plass </legend>
        <dl>
        <?php
        $dato = ''.date('d.m.y');
/*
 * Created on Mar 13, 2007
 * Author: dayg
 */
	if (isset($_POST['seats']))
	{
		$user = $username;
	
		$newStatusCode = $_POST['newStatusCode'];
		$oldStatusCode = $_POST['oldStatusCode'];

		// open database connection
		$linkID = @ mysql_connect("localhost", "user", "pass") or die("Could not connect to MySQL server");
		@ mysql_select_db("DB_name") or die("Could not select database");

		// prepare select statement
		$selectQuery = "SELECT rowId, columnId from seats where (";
		$count = 0;
		foreach($_POST['seats'] AS $seat) {
			if ($count > 0) {
				$selectQuery .= " || ";
			}
			$selectQuery .= " ( rowId = '" . substr($seat, 0, 1) . "'";
			$selectQuery .= " and columnId = " . substr($seat, 1) . " ) ";
			$count++;
		}
		$selectQuery .= " ) and status = $oldStatusCode";
		if ($oldStatusCode == 1) {
			$selectQuery .= " and updatedby = '$user'";
		}
		
		//echo $selectQuery;
		
		// execute select statement
		$result = mysql_query($selectQuery);
		//echo $result;
		
		$selectedSeats = mysql_num_rows($result);
		//echo "<br/>" . $selectedSeats;
		
		if ($selectedSeats != $count) {
			$problem = "<h3>There was a problem executing your request. No seat/s were updated.</h3>";
			$problem .= "Possible problems are:";
			$problem .= "<ul>";
			$problem .= "<li>Another process was able to book the same seat while you were still browsing.</li>";
			$problem .= "<li>You were trying to Confirm an unreserved Seat.</li>";
			$problem .= "<li>You were trying to Cancel an unreserved Seat.</li>";
			$problem .= "<li>You were trying to Reserve a reserved Seat.</li>";
			$problem .= "<li>There was a problem connecting to the database.</li>";
			$problem .= "</ul>";
			$problem .= "<a href='seats.php'>View Seat Plan</a>";
			die ($problem);
		}
		
		// prepare update statement
		$newStatusCode = $_POST['newStatusCode'];
		$oldStatusCode = $_POST['oldStatusCode'];
		
		$updateQuery = "UPDATE seats set status=$newStatusCode, updatedby='$user' where ( ";
		$count = 0;
		foreach($_POST['seats'] AS $seat) {
			if ($count > 0) {
				$updateQuery .= " || ";
			}
			$updateQuery .= " ( rowId = '" . substr($seat, 0, 1) . "'";
			$updateQuery .= " and columnId = " . substr($seat, 1) . " ) ";
			$count++;
		}
		$updateQuery .= " ) and status = $oldStatusCode";
		if ($oldStatusCode == 1) {
			$updateQuery .= " and updatedby = '$user'";
		}
		
		// perform update
		$result = mysql_query($updateQuery);
		$updatedSeats = mysql_affected_rows();

		if ($result && $updatedSeats == $count) {
			//$mysql->commit();
			echo "<h3>";
			echo "You have successfully updated $updatedSeats seat/s: ";
			echo "[";
			foreach($_POST['seats'] AS $seat) {
				$rowId = substr($seat, 0, 1);
				$columnId = substr($seat, 1);
				echo $rowId . $columnId . ", ";	
			}
			echo "]";
			echo "...</h3>";
		} else {
			//$mysql->rollback();
			echo "<h3>There was a problem executing your request. No seat/s were updated.</h3>";
			echo "Possible problems are:";
			echo "<ul>";
			echo "<li>Another process was able to book the same seat while you were still browsing.</li>";
			echo "<li>You were trying to Confirm an unreserved Seat.</li>";
			echo "<li>You were trying to Cancel an unreserved Seat.</li>";
			echo "<li>You were trying to Reserve a reserved Seat.</li>";
			echo "<li>There was a problem connecting to the database.</li>";
			echo "<a href='seats.php'>View Seat Plan</a> </ br>";
			echo "</ul>";
		}
		
		echo "<dl>
        	<dt><label for='plass'>Din valgte plass:</label></dt>
            <dd><input type='text' name='plass' id='plass' value='$seat' readonly/></dd</dl>";
		
		// Enable the autocommit feature
		//$mysqldb->autocommit(TRUE);
		
		// Recuperate the query resources
		//$result->free();
		
		mysql_close();
	}
?>

i need to make something like the black image . now it is like the green image . 

Edited January 30, 2014 by stanghelle

[stanghelle]

this is the right code for seat layout 

<?php

/*

 * Created on Mar 17, 2007

 * Author: dayg

 */


$linkID = @ mysql_connect("localhost", "root", "root") or die("Could not connect to MySQL server");

@ mysql_select_db("hlan") or die("Could not select database");

/* Create and execute query. */

$query = "SELECT rowId, columnId, status, updatedby from seats order by rowId, columnId asc";

$result = mysql_query($query);

$prevRowId = null;

$seatColor = null;

$tableRow = false;

//echo $result;

echo "<table width='500' border='0' cellpadding='3' cellspacing='3'>";

while (list($rowId, $columnId, $status, $updatedby) = mysql_fetch_row($result))

{

	if ($prevRowId != $rowId) {

		if ($rowId != 'A') {

			echo "</tr></table></td>";

			echo "\n</tr>";

		}

		$prevRowId = $rowId;

		echo "\n<tr><td align='center'><table border='1' cellpadding='50' cellspacing='50'><tr height='50'>";

	} else {

		$tableRow = false;

	}

	if ($status == 0) {

		$seatColor = "lightgreen";

	} else if ($status == 1 && $updatedby == 'user1') {

		$seatColor = "FFCC99";

	} else if ($status == 1 && $updatedby == 'user2') {

		$seatColor = "FFCCFF";

	} else if ($status == 2 && $updatedby == 'user1') {

		$seatColor = "FF9999";

	} else if ($status == 2 && $updatedby == 'user2') {

		$seatColor = "CC66FF";

	} else {

		$seatColor = "red";

	}


	echo "\n<td bgcolor='$seatColor' align='center' width='50'>";

	echo "$rowId$columnId";

	if ($status == 0 || ($status == 1 && $updatedby == $_SERVER['PHP_AUTH_USER'])) {

		echo "<input type='checkbox' name='seats[]' value='$rowId$columnId'></checkbox>";

	}

	echo "</td>";

		if (($rowId == 'A' && $columnId == 7) 

			|| ($rowId == 'B' && $columnId == 7) 

			|| ($rowId == 'C' && $columnId == 7) 

			|| ($rowId == 'D' && $columnId == 7) 

			|| ($rowId == 'E' && $columnId == 7) 

			|| ($rowId == 'F' && $columnId == 7) 

			|| ($rowId == 'G' && $columnId == 7) 

			|| ($rowId == 'H' && $columnId == 7) 

			|| ($rowId == 'I' && $columnId == 7) 

			|| ($rowId == 'J' && $columnId == 7) 

			|| ($rowId == 'K' && $columnId == 7) 

			|| ($rowId == 'L' && $columnId == 13) 

			|| ($rowId == 'M' && $columnId == 9)) {

			// This fragment is for adding a blank cell which represent the "center aisle"

			echo "<td> </td>";

		}

}


echo "</tr></table></td>";

echo "</tr>";

echo "</table>";


/* Close connection to database server. */

mysql_close();

?>

</td></tr>

<tr><td> </td></tr>

<tr><td width="100%" align="center">

	<table border="1" cellspacing="8" cellpadding="8">

		<tr>

			<td bgcolor='lightgreen'>Ledige sete</td>

			<td bgcolor='red'>Reservert av bruker</td>

		</tr>

	</table>

</td></tr>

<tr><td> </td></tr>

<tr><td width="100%" align="center">

  <a href="seatplan.jpg" target="new"></a> 

</td></tr>

</table>

</form>

 

Edited January 30, 2014 by stanghelle