tables and images

UKlee

I have been working on a script to call information from a database and displayed this information in a table please see bellow code.

$dbh=mysql_connect ("", "", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("");

$query = "SELECT * FROM membersorder by pilot_id ";

$result = mysql_query($query) or die(mysql_error());

$row = mysql_fetch_assoc($result);
mysql_close();

/ Display results in a table /
echo "<table width='800' align='center' cellpadding='0' border='1' bordercolor='#000080'>";
echo "<tr>\n
<td width='150'bgcolor='#ffffff' bordercolor='#000080' style='font-weight: bold'style='text-decoration: none'>pilot_id</td>
<td width='150'style='font-weight: bold'><a href=$href style='text-decoration: none'>name</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>hours</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>hub</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>joindate</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>flights</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>last flight</td>\n
</tr>\n";
while ($colum = mysql_fetch_array($result))
extract($colum);
echo "<tr>\n
<td width='150'bgcolor='#ffffff' bordercolor='#000080' style='font-weight: bold'style='text-decoration: none'>$pilot_id</td>
<td width='150'style='font-weight: bold'><a href=$href style='text-decoration: none'>$name</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>$hours</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>$hub</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>$joindate</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>$flights</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'>$date</td>\n
<td width='100'style='font-weight: bold'style='text-decoration: none'></td>\n
</tr>\n";
}
echo "</table>\n";?>

what i would like to do is actually show and image in this table but based upon a rank structure using the if command and get this to output a different image according to the actual data returned from within mysql datbase if command example bellow.

if ($row['hours']<="5")
{ echo '<img src="1.gif" width="70" height="30"> '; }
else
if ($row['hours']>="3000")
{ echo '<img src="10.gif" width="70" height="30"> '; }
else
if ($row['hours']>="2000")
{ echo '<img src="9.gif" width="70" height="30"> '; }
else
if ($row['hours']>="1000")
{ echo '<img src="8.gif" width="70" height="30"> '; }
else
if ($row['hours']>="500")
{ echo '<img src="7.gif" width="70" height="30"> '; }
else
if ($row['hours']>="100")
{ echo '<img src="6.gif" width="70" height="30"> '; }
else
if ($row['hours']>="50")
{ echo '<img src="5.gif" width="70" height="30"> '; }
else
if ($row['hours']>="30")
{ echo '<img src="4.gif" width="70" height="30"> '; }
else
if ($row['total']>="10")
{ echo '<img src="3.gif" width="70" height="30"> '; }
else
if ($row['hours']>="5")
{ echo '<img src="2.gif" width="70" height="30"> '; }

so for example if you had 100 it would display a different image to say if you had 50 hours and so on and so fourth in the same table as the other information being pulled from the mysql db.

I am fairly new to php but am getting to grips with it any help would be appreciated here. this has had me stumped for weeks I have looked around the website and am unable to locate any information to help.

Lee.

kellog

It looks like you have all the code you need to do what you want to do, but your just missing where to place the image at?

Try something like:

/* Display results in a table */
<table width='800' align='center' cellpadding='0' border='1' bordercolor='#000080'>
	<tr>
		<td width='150'bgcolor='#ffffff' bordercolor='#000080' style='font-weight: bold'style='text-decoration: none'><font color='#000080'>pilot_id</td>
		<td width='150'style='font-weight: bold'><a href=$href style='text-decoration: none'><font color='#000080'>name</td>
		<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>hours</td>
		<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>hub</td>
		<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>joindate</td>
		<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>flights</td>
		<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>last flight</td>
	</tr>

<?
while ($colum = mysql_fetch_array($result))
	{
	extract($colum);

	if ($row['hours'] > 3000)
		{
		$ImageName = "10.gif";
		}
	elseif ($row['hours'] > 2000 && $row['hours'] < 3000)
		{
		$ImageName = "9.gif";
		}
	elseif ($row['hours'] > 1000 && $row['hours'] < 2000)
		{
		$ImageName = "8.gif";
		}
	...
	else
		{
		$ImageName = "1.gif";
		}
?>
<tr>
	<td width='150'bgcolor='#ffffff' bordercolor='#000080' style='font-weight: bold'style='text-decoration: none'><font color='#000080'>$pilot_id</td>
	<td width='150'style='font-weight: bold'><a href=$href style='text-decoration: none'><font color='#000080'>$name</td>
	<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>$hours</td>
	<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>$hub</td>
	<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>$joindate</td>
	<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>$flights</td>
	<td width='100'style='font-weight: bold'style='text-decoration: none'><font color='#000080'>$date</td>
	<td width='100'style='font-weight: bold'style='text-decoration: none'><img src = "<?= $ImageName ?>" width="70" height="30"></td>
</tr>
</table>
<?		} ?>

paulnaj

Hi UKLee,

Welcome to the forum.

There were quite a few things wrong with your code, might be a bit dispiriting to list them all so I thought I'd tweak your code and set it out in a more organised fashion.

It should do what you intended it to do ... display rows of data and choose an image according to some criteria (which are the same as you had) ... but with a few ways to see how you could organise your code.

Hope it helps!! Obviously, I can't use your data, so I'm not able to de-bug my code properly. The fieldnames might be wrong for a start, but you should be able to clear that sort of thing up yourself.

<?php
// Function to choose image ... I've just used
// exactly the same conditions as you
function chooseImage($hours){
	if ($hours <= 5) $img = 1;
	else if ($hours >= 3000) $img = 10;
	else if ($hours >= 2000) $img = 9;
	else if ($hours >= 1000) $img = 8;
	else if ($hours >= 500) $img = 7;
	else if ($hours >= 100) $img = 6;
	else if ($hours >= 50) $img = 5;
	else if ($hours >= 30) $img = 4;
	else if ($hours >= 10) $img = 3;
	else if ($hours >= 5) $img = 2;

return '<img src="'.$img.'.gif" width="70" height="30">';
}
?>
<html>
<head>
<title>Table results</title>
<!-- 
	Definitely easier to control styles in one place 
	In the HTML, table has the attribute class="results"
-->
<style type="text/css">
TABLE.results {
	width: 800px;<p></p>
	color: #000080;
	border: 1px solid #000080;
	border-width: 1px 0px 0px 1px;
}
TABLE.results TH {
	width: 150px;
	text-align: left;
	border: 1px solid #000080;
	border-width: 0px 1px 1px 0px;
	padding: 2px;
}
TABLE.results TD {
	width: 150px;
	border: 1px solid #000080;
	border-width: 0px 1px 1px 0px;
	padding: 2px;
}
TABLE.results A {
	text-decoration: none;
}
TABLE.results A:HOVER {
	text-decoration: underline;
}
</style>
</head>
<body>
<?php // Don't just use <? ... some servers won't recognise it as PHP

$dbh = mysql_connect("", "", "")
	or die ('I cannot connect to the database because: ' . mysql_error()); 
mysql_select_db("")
	or die ('I cannot select a database because: ' . mysql_error()); 

$query = "SELECT * FROM `members`order by pilot_id"; 
$result = mysql_query($query)	or die(mysql_error()); 

// I cut in-and-out of PHP ... for me, it's easier to see the HTML

// First display the header row
?>
<table class="results" border="0" cellpadding="0" cellspacing="0">
	<tr> 
		<th>pilot_id</th> 
		<th>name</th>
		<th>hours</th>
		<th>hub</th> 
		<th>joindate</th>
		<th>flights</th>
		<th>last flight</th>
		<th>image</th>
	</tr>
<?php
// Now the content rows ...
while($row = mysql_fetch_array($result)){
	// $row now contains a array representing one record in the table
?>
	<tr> 
		<td><?php echo $row['pilot_id']; ?></td> 
		<td><a href="<?php echo $row['href']; ?>"><?php echo $row['name']; ?></a></td>
		<td><?php echo $row['hours']; ?></td>
		<td><?php echo $row['hub']; ?></td> 
		<td><?php echo $row['joindate']; ?></td>
		<td><?php echo $row['flights']; ?></td>
		<td><?php echo $row['lastflight']; ?></td>
		<td><?php echo chooseImage($row['hours']); ?></td>
	</tr>
<?php
} 
mysql_close(); // After the while loop has finished
?> 
</table> <!-- remember to close the table -->
</body>
</html>

Paul 🙂

UKlee

I would like to thank you both very very much , The problem is solved,and I take your comments well in regards my scripts and use of these as I said I am learning and will take your sugestions and good working practices into hand for the furture.

Thank you once again,great community here and great to be a new member.

kind regards

Lee🙂