sql and image

timmybuck

Hi Guys,

I have a php page that displays information from a database. It displays information from an events table.

My task is to try and display an icon if an event is fully booked.

In my events table i have total_Seats booked field and Booked_Seats Column.

I think the way it could work is when some one makes a booking the Booked_Seats column is updated until it equals the total_seats booked field then i want an icon to appear, how do i do that ? do i need to create an extra column in my event table to hold the image ?

Any ideas

jpmoriarty

i wouldn't have thought it needs to be in the db at all!

why not just upload a little image and then do something like (excuse the pigeon code - hope you'll get the idea):

<?
$sql = "select total_seats, booked_seats from seats where performance = 'this_one'";
$...do the query and get the results into $row[] etc...
if($row['total_seats']==$row['booked_seats'])
{
   echo "<img src=\"fully_booked.jpg\" alt=\"This show is fully booked\" width=\"20\" height=\"20\">\n";
}

just use the html to do the work for you - there's no need for the image to be db based since it'll be the same for all of them.

timmybuck

Ok thanks for that,

Would i still need an extra colum in my dynamically created html table to hold the image.

Im guessing i would

tekky

so tack on an <td> before his <img> tag and a </td> after the IMG tag 😉

or simply add the extra TD too all the TR's and leave it blank if seats arent full and IMG'd if seats are full so you dont have to worry about COLSPAN's

timmybuck

hi guys,

ok this is my code below, it works

<html>
<head> </head>
<body>
<?php
$categoryID=$_POST['categoryID'];
$color[0] = "blue";

$color[1] = "yellow";

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");

mysql_select_db('booking');

$sql = "SELECT * FROM event WHERE categoryID='$categoryID'";
$result = mysql_query($sql);
#while ($row = mysql_fetch_array($result)) {
#echo $row['EventName'] . ',' . $row['Date'] . ',' . $row['Venue'] . " \n";
echo "<table>\n";

echo " <tr>\n";

echo " <th>Event Name</th>\n";

echo " <th>Date</th>\n";

echo " <th>Venue</th>\n";

echo " <th>Town</th>\n";

echo " <th>Availabilty</th>\n";
echo " </tr>\n";

echo '</table>';

?>
</body>
</html>

but where do i insert the code below, i realise i have to tidy it up but if i cant slot it in ot the right place then that will be a start for me

<?
$sql = "select total_seats, booked_seats from seats where performance = 'this_one'";
$...do the query and get the results into $row[] etc...
if($row['total_seats']==$row['booked_seats'])
{
echo "<img src=\"fully_booked.jpg\" alt=\"This show is fully booked\" width=\"20\" height=\"20\">\n";
}

timmybuck

I have just thought although the icon is displayed on the page i have posted the code to in my previous page. Im not sure if its executed on that page

timmybuck

Also, just another thought, when a customer makes a booking, i think im going to need an update query as well, is this right so something like update a variable that gets passed back to the display events page os that i can reflect how many seats are left.

Am i right in thinking this could be way to program this

timmybuck

Where do i place the image in order for it to be found

tekky

wherever you tell the <IMG> link to look for it in the SRC attribute...

timmybuck

Hi guys,

I can display the table and the image but the image doesnt display in the avaliability column. Can anyone see why

<html>
<head> </head>
<body>
<?php
$categoryID=$_POST['categoryID'];
$color[0] = "blue";

$color[1] = "yellow";

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");

mysql_select_db('booking');

echo "<table>\n";

echo " <tr>\n";

echo " <th>Event Name</th>\n";

echo " <th>Date</th>\n";

echo " <th>Venue</th>\n";

echo " <th>Town</th>\n";

echo " <th>Availabilty</th>\n";
echo " </tr>\n";

while ($row = mysql_fetch_array($result)) {

$a = ($a+1)%2;

echo '<tr bgcolor='.$color[$a] . ">\n";

#echo ' <td>'.$row['EventName'].'</td>'."\n";
echo '<td><a href="availabletickets.php">' . $row['EventName'] . "</a></td>\n";

echo ' <td>'.$row['Date'].'</td>'."\n";

echo ' <td>'.$row['Venue'].'</td>'."\n";

echo ' <td>'.$row['Town'].'</td>'."\n";
echo ' </tr>'."\n";

}

$query= "select Total_Seats, Booked_Seats FROM event where EventID = 3";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {

echo $row[Availabilty];
if($row['Total_Seats']==$row['Booked_Seats'])
{
echo "<img src=\"12.gif\" alt=\"This show is fully booked\" width=\"20\" height=\"20\">\n";
}
}
echo '</table>';

?>
</body>
</html>