Hello,
I am running a query against a mysql db and the output is sent to a function that creates a html table. It works, but now I need to be able to add two additional columns. One of the columns needs to contain a submit button(no functionality necessary), the other a link to an image that is stored locally. The file name of the image is stored in the database and I've written a function to change the file name into an img tag in html. I believe that the key to solving this is editing my function for the html table but am not quite sure how to do it. I've attached my img tag function and html table loop. Any suggestions are appreciated. Thanks.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
JUst a small comment...
$query = "SELECT * FROM Table ";
...
$username = $tempClass["username"];
$firstname = $tempClass["firstname"];
$lastname = $tempClass["lastname"];
$imagename = $tempClass["imagename"];
You should avoid SELECT * as much as possible.
In that case, it should be
$query = "SELECT username, firstname, lastname, imagename FROM Table ";
SELECT * can really be a magnific and hidden performance trap...
I changed your existing code to add a submit button and image.
/*************************
* Function to print query as table
*
* Argument(s):
* $result - Result from SQL query
**************************
function dbtable($result)
{
?><table border="1" width="80%"><tr><?php
if(! $result)
{
?><th>result not valid</th><?php
}
else
{
$i = 0;
while ($i < mysql_num_fields($result))
{
$meta = mysql_fetch_field($result,
?><th style="white-space:nowrap"
$i++;
}
<th style="white-space:nowrap"
?></tr><?php
if(mysql_num_rows($result)
{
?><tr><td colspan="<?=mysql_num_field
<strong><center>no result</center></strong>
</td></tr><?php
}
else
while($row=mysql_fetch_ass
{
?>
<tr style="white-space:nowrap"
<?php
foreach($row as $key=>$value)
{
if ($key == 'image'){
?><td><?php echo nametoimage($value)?></td><?ph
}
else{
?><td><?=$value?></td><?php
}
}
?>
<td><input type=submit value=submit /></td>
</tr><?php
}
}
?></table><?php
}
Business Accounts
Answer for Membership
by: mmarthPosted on 2009-11-08 at 05:12:45ID: 25770357
try something like this. change the column names to fit your columns.
?>
<table>
<tr>
<td align="center" width="88" valign='bottom'><span class='black12B'>firstname</
<td align="center" width="88" valign='bottom'><span class='black12B'>lastname</s
<td align="center" width="88" valign='bottom'><span class='black12B'>email</span
</tr>
<?php
function openRS($query)
{
mysql_close;
mysql_connect(classSERVER,
mysql_select_db(classDATAB
$result=mysql_query($query
return $result;
}
$query = "SELECT * FROM Table ";
$rsClass=openRS($query);
$rowcount = mysql_num_rows($rsClass);
if ($rowcount > 0)
{
while($tempClass = mysql_fetch_array($rsClass
{
$username = $tempClass["username"];
$firstname = $tempClass["firstname"];
$lastname = $tempClass["lastname"];
$imagename = $tempClass["imagename"];
?>
<tr>
<form METHOD="POST" action="updateClassMate.ph
<td align="left" width="88" valign='bottom'><input NAME="firstname" SIZE="22" value="<?=$firstname?>" maxlength="22"></td>
<td align="left" width="88" valign='bottom'><input NAME="lastname" SIZE="22" value="<?=$lastname?>" maxlength="22"> </td>
<td align="left" width="88" valign='bottom'><input NAME="email" SIZE="40" value="<?=$email?>" maxlength="55"></td>
<td align="left" width="88" valign='bottom'>
<?php
if ($imagename != null)
{
?>
<img src="images/$imagename " />
<?php
}
?>
</td>
<td align="left" width="88" valign='bottom'>
<input type='submit' NAME="ipClassMate" SIZE="20" value="update <?=$firstname?>">
</td>
</form>
</tr>
<?php
}
}
?>