Array problems

[keithjasper]

ok people i have recieved some help regarding a slightly complex array which i have managed to modify to add in seating gaps for walk ways for a theatre online booking thingy..

here is my boggle...

i have made the array but i wish to modify the array's i currently have 20 options in a self created array like so....

<?

$blankarray = array();
for ($i = 1; $i <= 20; $i++) $blankarray[$i] = 0;
$seats = array();
for ($i = 0; $i < 20; $i++) $seats['row'. chr(65 + $i)] = $blankarray;
// njm: echo the $seats array
echo '<pre>';
print_r($seats);
echo '</pre><hr />';
//then loop through your sales
//and if the seat is sold then change the value from 0 to 1

//then loop through the array
for ($i = 1; $i < 21; $i++)
{
if ($i == 1) echo '<table border="1">';
elseif ($i == 5) echo '</table><table border="1">';
elseif ($i == 15) echo '</table><table border="1">';

echo '<tr>';
for ($j = 1; $j <= 20; $j++)
{
if ($i == 4 & $j == 5) echo '<td>||</td>';
if ($i == 4 & $j == 14) echo '<td>||</td>';
if ($i >= 5 && $i < 11 && $j == 10) echo '<td>||</td>';
if ($i == 11 & $j == 11) echo '<td>||</td>';
if ($i >= 12 && $i < 15 && $j == 10) echo '<td>||</td>';
echo '<td>S</td>';
}
echo '</tr>';
if ($i == 20) echo '</table>';
}
?>

but at arrayA (rowA) i wish to make it 17 seats accross and row b 18 seats accross and rowc 9 seats accross etc... how do i go about making something like that?

on top of that would the following work

SELECT booked FROM bookings where seatid = $seats['row'. chr(65 + $i)];
while rows......
if $row = 1 echo <td colour=red>B</td>

obviously it would need to be formatted correctly would that work../where would i put it..

Many thanks... damn i love a challenge...

all of the rows are layed out as follows

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A
1 2 3 4 | 5 6 7 8 9 10 11 12 13 | 14 15 16 17 18 B
1 2 3 4 5 6 7 8 9 C

1 2 3 4 5 6 7 8 9 10 11 12 D

1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 20 E
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 F
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 20 G
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 20 H
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 20 I
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 J
1 2 3 4 5 6 7 8 9 10 11 | 12 13 14 15 16 17 18 19 K
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 L
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 M

1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 N

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 O
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 P
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Q
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 R
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 S
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 T

Thanks for any assiastance anyone could provide?

Keith Jasper

[sarahk]

Hi Keith

I'll try and give a good answer! 🙂

$seatLimits = array('A' => 17, 'B' = 18, 'C' => 9 ); // with one entry for every row
for ($i = 1; $i <= 20; $i++)
{
   $blankarray = array();
   // make sure blank array is only as big as we need it to be
   for ($j = 1; $j <= $seatLimits[chr(65 + $i)]; $j++) $blankarray[$j] = 0;
   $seats['row'. chr(65 + $i)] = $blankarray; 
}
// now continue as before

[keithjasper]

sorry sarahk i cant seem to make that work... i have played with the syntax on the first line as my php does not seem to like that.

had a play and cant seem to make it work i even took all rest of rows out and left A to see if one worked...

might just be the location i put it in to the code though?

im all confused... HE EH

[njm]

The '=' on the first line should be a '=>', and 65 should be 64 if $i starts at 1 (65 = 'A'). Other than that the array gets built ok.

hth, njm

[keithjasper]

ah yea i see but on mine it echos the array twice i cant see what code i was suppoosed to delete if any... to place the code provided ?

also the new array is not built at the bottom of the screen with the <td>s</td>'s

it has 20 seats accross still on row a?

i know its something im doing wrong but dont know what..

sorry and thanks.

[adrian_brooks]

Perhaps you may wish to post a snippet of your code here (the revised code, that is)...that can sometimes reveal major or minor syntax errors. Just a suggestion for ya. Something else that may help you debug is create a test.php file and place the code in question in it and run it as stand-alone code. If it works in the test file, then it means that surrounding code is the problem.

These tactics have proven quite helpful for me in the past. I hope they offer you the same success.

[keithjasper]

sorry should have added the previous thread address to the first post here... explains all of the problem and thoughout the series of posts explains the problems.

Hope this provedes some more help

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10263929

[sarahk]

Hi Keith

are you still working on this?

[keithjasper]

Yea its on the back burner now but definatly would love to complete it yea..

Thanks

[keithjasper]

how do i make it echo the seat limits.

I have the seat limits array built but i cant seem to get it to link the the seats array

 <?
$blankarray = array(); 
$seatLimits = array('A' => 17, 'B' => 18, 'C' => 9, 'D' => 9, 'E' => 9, 'F' => 9, 'G' => 9, 'H' => 9, 'I' => 9, 'J' => 9, 'K' => 9, 'L' => 9, 'M' => 9, 'N' => 9, 'O' => 9, 'P' => 9, 'Q' => 9, 'R' => 9, 'S' => 9, 'T' => 9, 'U' => 9); // with one entry for every row 
for ($i = 1; $i <= 20; $i++) 
{ 
   $blankarray = array(); 
   // make sure blank array is only as big as we need it to be 
   for ($j = 1; $j <= $seatLimits[chr(65 + $i)]; $j++) $blankarray[$j] = 0; 
   $seats['row'. chr(65 + $i)] = $blankarray;  

} 

for ($i = 1; $i <= 30; $i++) $blankarray[$i] = 0; 
$seats = array(); 
for ($i = 0; $i < 20; $i++) $seats['row'. chr(65 + $i)] = $blankarray; 
// njm: echo the $seats array 
echo '<pre>'; 
print_r($seats); 
echo "<br>";
print_r($seatLimits);
echo '</pre><hr />'; 
//then loop through your sales 
//and if the seat is sold then change the value from 0 to 1 

//then loop through the array 
for ($i = 1; $i < 21; $i++) 
{ 
  if ($i == 1) echo '<table border="1">'; 
  elseif ($i == 6) echo '</table><table border="1">'; 
  elseif ($i == 16) echo '</table><table border="1">'; 

  echo '<tr>'; 
  for ($j = 1; $j <= 30; $j++) 
  { 
    if ($i >= 6 && $i < 16 && $j == 16) echo '<td>||</td>'; 
    echo '<td>S</td>'; 
  } 
  echo '</tr>'; 
  if ($i == 20) echo '</table>'; 
}

?>

[sarahk]

Hi Keith

I've got this working at http://www.pcpropertymanager.com/test/jasper.php

<? 
$blankarray = array();  

$seats = array();
$seatLimits = array('A' => 17, 'B' => 18, 'C' => 9, 'D' => 9, 'E' => 9, 'F' => 9, 'G' => 9, 'H' => 9, 'I' => 9, 'J' => 9, 'K' => 9, 'L' => 9, 'M' => 9, 'N' => 9, 'O' => 9, 'P' => 9, 'Q' => 9, 'R' => 9, 'S' => 9, 'T' => 9, 'U' => 9); // with one entry for every row 
foreach($seatLimits as $key => $val)  

{  

   $blankarray = array();  

   // make sure blank array is only as big as we need it to be 
   for ($j = 1; $j <= $val; $j++) $blankarray[$j] = 0;  

   $seats['row'. $key] = $blankarray;   

}  

print_r($seats); 
echo '<hr>'; 

//then loop through your sales 
//and if the seat is sold then change the value from 0 to 1 

//then loop through the array 
$i = 1;
foreach($seats as $key => $varray) 
{  

  if ($i == 1) echo '<table border="1">';  

  elseif ($i == 6) echo '</table><table border="1">';  

  elseif ($i == 16) echo '</table><table border="1">';  

  echo '<tr><td>',$key, '</td>';  

  $midRows = ($i >= 6 && $i < 16);
  $j = 0;
  foreach($varray as $key => $val)
  {  

    if ($midRows && $j == 16) echo '<td>||</td>';  

	if ($val == 0) echo "<th>S {$key}</th>";
    else echo "<td>S {$key}</td>";
	$j++;  

  }  

  echo '</tr>';  

  $i++;
} 
echo '</table>';  

?> 

[keithjasper]

ok now to tweak that... how can it submit values to the database to book the tickets and also read from the database to show if the ticket is booked or not... if booked leave out the select box.

somehow needs to have a if relating to a different color if ticket is booked?

what is the var which makes the actal seat code/array so i could say to you a1 is and t7 is??

this is like a complete mystery to me?

Thanks for your help so far this looks well sexy!!

thanks

[adrian_brooks]

Hi Keith,

I'm really not sure what exactly it is that your are attempting to do with that blankarrayother than to initialize your other array data with all zeros with its values, but I have come up with a schema that should take care of all your requirements now.

First, I have come up with a database populator script that will build the basic structure of your database set aorund your seating criteria.

Next I have come up with a script that reads the data from the table based on a per row selection criteria. When run, I get the exact results that I believe that you are attempting to achieve.

Let me know if this helped.

CODE FOR DATABASE POPULATOR:
My database layout was as follows for this design;
DBName > seats
|
TABLE > tbl_seats
|
seatID ---------- auto_increment - Primary
seat_Row ----- int - Default 0
seat_Pos ------ int - Default 0
seat_Price ---- float (10,2) - Default 0.00
seat_Avail ---- int - Default 1 //1 = Avail - 0 = Booked

<?php

//replace this with your own code for database connection
include("db_inc.php");

$seat_Index = 1;
$seatLimits = array('A' => 17, 'B' => 18, 'C' => 9, 'D' => 9, 'E' => 9, 'F' => 9, 'G' => 9, 'H' => 9, 'I' => 9, 'J' => 9, 'K' => 9, 'L' => 9, 'M' => 9, 'N' => 9, 'O' => 9, 'P' => 9, 'Q' => 9, 'R' => 9, 'S' => 9, 'T' => 9, 'U' => 9);

// Row iteration loop
for($seatRow=1;$seatRow<=20;$seatRow++)
{
	$seatAsciiVal = 64 + $seatRow;
	// Array bound seat iteration loop that is bound to each row's limits
	for($seatPos=1;$seatPos<=$seatLimits[chr(64+$seatRow)];$seatPos++)
	{
		$sql = "INSERT INTO `tbl_seats` (`seatID` , `seat_Row` , `seat_Pos` , `seat_Price` , `seat_Avail`) VALUES ('" . $seat_Index . "', '" . $seatAsciiVal . "', '" . $seatPos . "', '29.95', '1');";
		$seat_Index += 1;

		if(!($dbResult = mysql_query($sql, $db)))
		{
			print("ERROR: Could not retrieve data from query!<br>\n");
			print("MySQL Reports: " . mysql_error() . "<br>\n");
			exit();
		}
	}
}
print "New data has been successfully recorded to the database.\r\n";
?>

CODE FOR READING TABLE DATA AND DISPLAYING IT:

<?php
	//replace this with your own code for database connection
	include("db_inc.php");

$seatLimits = array('A' => 17, 'B' => 18, 'C' => 9, 'D' => 9, 'E' => 9, 'F' => 9, 'G' => 9, 'H' => 9, 'I' => 9, 'J' => 9, 'K' => 9, 'L' => 9, 'M' => 9, 'N' => 9, 'O' => 9, 'P' => 9, 'Q' => 9, 'R' => 9, 'S' => 9, 'T' => 9, 'U' => 9);

print "<table bgcolor=\"#3333CC\" align=\"center\">\r\n";

for($seatRow=1;$seatRow<=21;$seatRow++)		//iterate through each row from A to U
{
	$seatLtr = chr(64 + $seatRow);
	print " <tr align=\"center\"><td colspan=\"" . $seatLimits[chr(64+$seatRow)] . "\" bgcolor=\"#999966\" align=\"center\">Row: " . $seatLtr . "</td></tr>\r\n";
	print "  <tr align=\"center\">\r\n";
	print "   <tr align=\"center\">\r\n";

	//Here we are selecting only the records that correspond
	//to each specific row throughout the iteration.
	$sql = "SELECT seat_Row, seat_Pos, seat_Price, seat_Avail FROM tbl_seats WHERE seat_Row=" . ($seatRow + 64) . ";";

	// performs the SQL statement upon the the database table
	if(!($dbResult = mysql_query($sql, $db)))
	{
		print("ERROR: Could not retrieve data from query!<br>\n");
		print("MySQL Reports: " . mysql_error() . "<br>\n");
		exit();
	}
	//retrieves each row into an array called row whose
	//array elements are called upon individually.
	//Each row element contains the field key/value pairs that related to the read record.
	while($row = mysql_fetch_array($dbResult))
	{
		print "   <td width=\"3%\" align=\"center\" bgcolor=\"#CC99CC\">" . $row['seat_Pos'] . "</td>\r\n";
	}
	print "   </tr>\r\n";
}
?>

I'm curious if this solves your problem. Good luck, Keith
😃
~Adrian

[keithjasper]

Thanks adrian i wont test it just yet either tonight or the weekend.

although one thing i dont see in the code which is quite important is the vertical walk ways.

roughly the middle there should be a walkway.

hopefuly its quite easy to add in. but either way it could do with being easyenough for me to understand so that it can be changed should we use a different theatre.

just somewhere in the code to say e.g.

if seat = 11 insert a gap and continue 11 ont eh next cell.

but need one for almost all lines... i think its mentioned in some of my source somewhere.

Thanks

keith😃

[adrian_brooks]

Hi again Keith,

So sorry that I missed that detail. I'll put that together for you and post it with position for inclusion in the code.

I am also working on a routine for you that will allow for a live seat 'click & sell' interface based on availability and color coding.

Glad to be a help.

~Adrian

[keithjasper]

Thanks Again Adrian I shall be testing out that code in a short time..

Looks good.

Thanks..

How difficult will the click and buy be?

[adrian_brooks]

Hello again Keith,

The interface that would achieve a functional 'click and buy' design wouldn't have to be entirely all that difficult. The basic design concept that I, personally, may attempt to approach it from may be the use of onClick events tied to an external script for handling the actual transaction. If the sale is finalized then the appropriate seat_Avail flag value is set in the database to indicate that that seat would then be flagged as booked.

As for what you will see upon testing my latest code I sent to you. You will notice that the layout is backwards to what you were expecting and no isle way. I have a new code snippet that corrects this issue and have made the modifications that have inverted the display to suit your 'bottom up' display requirements and have been attempting to put your isle in. Albeit, I have been having been experiencing a small amount of confusion though in assertaining exactly where the isle is placed in each row based on your early design suggestions and your latest array structure suggests something a bit different then what I had imagined. I based my array off of your original table layout posted earlier in this series of threads. My current isle placement is making the assumption that your isle runs down past the 10th seats only in rows 'E' thru 'N'. Is this correct?

Inclusion of the isle is quite an easy task. Alignment and centering of all the rows has proven a bit more of a head ache. Nothing out of reach though. As I finish developing the 'click & buy' interface I can post it for you here. That is just a matter of either simple form handling or coordinated database updating and manipulation through callback methodology and syntax.

~Adrian

[keithjasper]

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A
1 2 3 4 | 5 6 7 8 9 10 11 12 13 | 14 15 16 17 18 B
1 2 3 4 5 6 7 8 9 C

1 2 3 4 5 6 7 8 9 10 11 12 D

1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 20 E
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 F
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 20 G
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 20 H
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 20 I
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 J
1 2 3 4 5 6 7 8 9 10 11 | 12 13 14 15 16 17 18 19 K
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 L
1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 18 19 M

1 2 3 4 5 6 7 8 9 10 | 11 12 13 14 15 16 17 N

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 O
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 P
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Q
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 R
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 S
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 T

this is the seating layout of the theatre which the booking is to be designed. where | equals the isle which is center all the way through the middle block of seats however the balcony row A to D are seats aligned to the center of the room...
should be understandable i think.

Just wish i had taken my camera there the other day could have shown you a pic to make it easier to understand.

Thanks for all of your support all of PHP builder and the main helpers will be listed in the credits as long as they agree. Thanks

[adrian_brooks]

Ok then, Keith. That layout is easy enough to decipher. As for the credits, sure, you have my permission to make any inclusions you may wish.

I'll be getting back with you as my developments continue.

~Adrian