PHP - Formating A Table Row Based On A Cell Value

I am trying to insert data from a mysql in a table. I want the data to appear with the image on the left, item name on the top right followed by description underneath.


<?php
$sql = 'SELECT * FROM tbl_products ORDER BY id';
$result = $db->query($sql);
$output[] = '<ul>';
$output[] = '<table border="3" bordercolor="#000000">';
while ($row = $result->fetch()) {

         $output[] = '<tr>';
         $output[] = '<td><img src="images/'.$row['pic'].'" width="67" height="100" /></td>';
         $output[] = '<td class="style10"><strong>'.$row['item_name'].'</strong></td>';
         $output[] = '<td>'.$row['item_description'].'</td>';
         $output[] = '</tr>';

}
$output[] = '</table>';
echo join('',$output);
?>

I would like the items to appear the same way as this page

http://aafcollection.info/items/list.php

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=314271.0

Trying to run this function so it displays the generated image in a table cell -

Code: [Select]
<?php 
function imgsecuregen($size = 6){ 

$width = 11*$size; 
$height = 25; 

$string = ""; 
for($i = 1; $i <= $size; $i++){ 
$string .= rand (0,9).""; 
} // for 

$im = ImageCreate($width, $height); 
$bg = imagecolorallocate($im, 102, 102, 102);  // background
$black = imagecolorallocate($im, 0, 255, 0);   // text
$grey = imagecolorallocate($im, 102, 102, 102);    // border 
imagerectangle($im,0, 0, $width-1, $height-1, $grey); 
imagestring($im, 5, $size, 5, $string, $black); 
imagepng($im); 
imagedestroy($im); 
} 

imgsecuregen(8);  // string length

?>

Works if I load it directly, but not in a <td>.
 

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=307147.0

Image name will come from database.
It can be displayed in divs or table cells.
Which is better using divs or table cells?
Can anyone post sample code?
http://img28.imageshack.us/i/44233003.png/

Hi

I have a table that populated by a recordset, and wondered whether is was possible to make a row background colour = red where a particular cell = some text?

I have been searching around and not managed to find anything of use.

Any help would be appreciated.

When I echo out my variable in the php file it works fine but when I put the variable in a table cell it doesn't echo out. 
 

This is a little confusing so please bear with me.  I was thinking of using left.join but couldn't figure out how to implement it properly.

I am trying to order all of the results from a table names 'clans' based on how many points the clan has. To calculate the points you have to go into another table 'clanteams' and then loop every team in the clan pulling wins and losses from a row in a specific ladder table.

Here is the code i have to calculate the points.

Code: [Select]
$total[wins] = 0;
$total[loss] = 0;
$members=mysql_query("SELECT id,clanid,teamid,DATE_FORMAT(datejoined,'%M %d, %Y') FROM clanteams WHERE clanid='$member[id]'");
while(list($id,$clanid,$teamid,$joined)=mysql_fetch_row($members)){
$team=mysql_query("SELECT name,ladderid FROM teams WHERE id='$teamid'");
if(mysql_num_rows($team) == 0) continue;
$team=mysql_fetch_array($team);
$ladder=mysql_query("SELECT name FROM ladders WHERE id='$team[ladderid]'");
$ladder=mysql_fetch_array($ladder);
$linfo=mysql_query("SELECT rank,wins,loss FROM ladder_$team[ladderid] WHERE teamid='$teamid'");
$linfo=mysql_fetch_array($linfo);

$total[wins] = $total[wins] + $linfo[wins];
$total[loss] = $total[loss] + $linfo[loss];

}
$totalpoints = ($total[wins] * 2) - $total[loss];

So now i want to loop through every row in the clans table, and using the above code oder them by $total points.
Ive spent hours wrapping my head around it and still cannot figure it out.

Please help.

I have a stdClass Object array with nested User arrays as a value that I would like to display in a table cell.

I am struggling and have exhausted a lot of time. I am hoping to get a shove in the right direction if possible.

The image below will show what I am trying to do.

 

$someArray = json_decode($token_result);

foreach ($someArray as $key => $value) {
    $combined[] =
        "<tr><td>" .
        $value->customer .
        "</td><td>" .
        $value->city .
        '</td>
           <td>' .
        $value->state .
        "</td><td>" .
        $value->zipcode .
        '</td>
           <td>' .
        $value->totalUsers .
        "</td><td>" .
        $value->totalActiveUsers .
        "</td><td>" .
        $value->totalInActiveUsers .
        '</td><td>
           <a href="">' .
        $value->users .
        "</a></td></tr>";
}

foreach ($combined as $value) {
    print $value;
}

Here is what my Array and Objects look like

Array
(
    [0] => stdClass Object
        (
            [customer] => SWSH
            [city] => Thomasville
            [state] => GA
            [zipcode] => 31792
            [totalUsers] => 6
            [totalActiveUsers] => 6
            [totalInActiveUsers] => 0
            [users] => Array
                (
                    [0] => stdClass Object
                        (
                            [firstName] => xxx
                            [lastName] => xxx
                            [phoneNumber] => 
                            [userName] => cb_igwrth@xxx.com
                            [createdBy] => 
                            [isActive] => 1
                        )

                    [1] => stdClass Object
                        (
                            [firstName] => Dan
                            [lastName] => Stewart
                            [phoneNumber] => +11111111111
                            [userName] => dan.sxx@xxx.ga.gov
                            [createdBy] => kwilliams@xxx.com
                            [isActive] => 1
                        )
                )

        )

    [1] => stdClass Object
        (
            [customer] => xxxx
            [city] => Carver
            [state] => MA
            [zipcode] => 02330
            [totalUsers] => 3
            [totalActiveUsers] => 3
            [totalInActiveUsers] => 0
            [users] => Array
                (
                    [0] => stdClass Object
                        (
                            [firstName] => Leo
                            [lastName] => Furtado
                            [phoneNumber] => 781-000-0000
                            [userName] => LFurtado@xxx.com
                            [createdBy] => TConger@ccccc.com
                            [isActive] => 1
                        )                

                )

        )
)

Table is attached

 

I'm wondering how to do this with javascript for a table that i have made in php and html.

I want to hide the row for the table based on the value inside my first column for each row of the table.

Like if column 1 has "apple" inside it, then the row would not be shown.
I'm pretty sure this can be done in javascript but i'm not a coding guy, so any help would be appreciated!

My table.php file that has the table i want to do this for:
Code: [Select]
<script language="javascript">

imageX1='plus';
imageX2='plus';
imageX3='plus';

function toggleDisplay(e){
imgX="imagePM"+e;
tableX="table"+e;
imageX="imageX"+e;
tableLink="tableHref"+e;
imageXval=eval("imageX"+e);
element = document.getElementById(tableX).style;
 if (element.display=='none') {element.display='block';}
 else {element.display='none';}
 if (imageXval=='plus') {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='minus';");document.getElementById(tableLink).title='Hide WoW';}
 else {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='plus';");document.getElementById(tableLink).title='Show WoW';}
}
</script>

<?php
$username="user";
$password="password";
$tmp="database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($tmp) or die( "Unable to select database");
$query="SELECT * FROM users";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table class="sortable" id="wow" border="1" cellpadding="0" cellspacing="0" style="margin-left:auto;margin-right:auto;text-align:left">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Game</font></th>
<th><font face="Arial, Helvetica, sans-serif">Character</font></th>
<th><font face="Arial, Helvetica, sans-serif">Rating</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/xfirelogo.png">&nbsp;Status</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/xfirelogo.png">&nbsp;Link</font></th>
<th><font face="Arial, Helvetica, sans-serif">Realm</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/livestreamlogo.png">&nbsp;Status</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/livestreamlogo.png">&nbsp;Link</font></th>
<th><font face="Arial, Helvetica, sans-serif">Team&nbsp;Setup</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"wowcharacter");
$f2=mysql_result($result,$i,"username");
$f3=mysql_result($result,$i,"livestream");
$f4=mysql_result($result,$i,"wowserver");

$f5=mysql_result($result,$i,"wowplayer1");
$f6=mysql_result($result,$i,"wowplayer2");
$f9=mysql_result($result,$i,"wowplayer3");

$f7=mysql_result($result,$i,"wowrealm");
$f8=mysql_result($result,$i,"xfire");
$f10=mysql_result($result,$i,"xfirecheck");
$f11=mysql_result($result,$i,"wowrating");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<center><img src=http://www.pvpstreams.com/table-images/wowtable.png>"; ?></center></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://$f4.battle.net/wow/en/character/$f7/$f1/simple>$f1</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f11; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "$f10"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://www.pvpstreams.com/xfire.php?user=$f2>$f8</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php include("livestreamcheck.php"); ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://www.pvpstreams.com/livestream.php?user=$f2>$f3</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<img src=http://www.pvpstreams.com/wclassicons/$f5.png><img src=http://www.pvpstreams.com/wclassicons/$f6.png><img src=http://www.pvpstreams.com/wclassicons/$f9.png>" ?></font></td>
</tr>


<?php
$i++;
}
?>
</table>

hi,

Instead giving its default on "Choose Process", I would like to display its process based on the value in database. How can I do it?

Code: [Select]
<?php 
require_once '../../connectDB.php';
require_once '../include/functions.php';

$sql = " SELECT *
 FROM tb_item
 ORDER BY itm_id asc";
$result = mysql_query($sql) or die(mysql_error());
?>
<form>
<h1>Items</h1>
<table width="75%" border="1" align="left" cellpadding="5" cellspacing="1">
<tr>
    <th width="100" align="left">Item ID</th>
    <th width="100" align="left">Parts</th>
    <th width="100" align="left">Sub-Process</th>
    <th width="100" align="left">Confirmation</th>
    </tr>
    <tr>
    <?php 
    while ($row = mysql_fetch_array($result)) 
{
    extract($row);
?>
<td><?php echo $itm_id; ?></td>
    <td><?php echo $itm_parts; ?></td>
    <td>
<select name='cboSub' id='cbosub'>
<option value='' selected>---- Choose Process ----</option>
    <?php createComboBox(); ?>  
</select>
</td>
<td>
<a href='processItem.php?itm_id=<?php echo $itm_id; ?>'>
<img src='../images/modify.png' width='20' height='20' alt='confirm'/>
</a>
</td>
</tr>
<?php 
}; 
?>

</table>
</form>
<?php 
/**
 * Create combo box for sub-process
 */
function createComboBox() 
{
$sql = " SELECT *
   FROM tb_sub_process
      ORDER BY sub_id asc";

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

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

echo "<option value='$sub_id' $select>$sub_name</option>";
}
}
?>

I've attached an example of what basically the output will looks like.

Any help are appreciated.

Thanks in advance.


Regards,
Juz

[attachment deleted by admin]

Dear All

I want to display my data in tabular columns with the headings of table  like 00:06-00:08,00:08-00:10,00:10:00:12:00........22:00-24:00.i.e.time
In database I have two columns one containing value and other containing time when this reading was done.
I could retrieve data from my mysql table in php and look at time.
I want to know how could I insert the value to the correct column of table based on the time.
e.g If I have record in table in database say containing value 09:45 and 5.
I want this value to go to the column heading 00:08-00:10 and same thing for the other values.

I hope I am clear with the problem definition but if you need more info.Please let me know.

Thanks,
elp

hi 

I have 2 tables (members & friendship)



Members table columns:
--------------------------------------------
username | password |    email    | etc ....
--------------------------------------------
Person 1     xxxxxx        x@x.com
person 2     yyyyyy        y@y.com
 
Friendship columns:

---------------------------------------
username |   friend   |  status  |
---------------------------------------
person 1     person 2     friends
person 2     person 1     friends
person 1     person 3     pending



I want to query the friendship table: "SELECT friend FROM friendship WHERE username ='$_SESSION['myusername'];'  AND status='friends' "

(so its basically getting the user names of anyone who is the logged in users friend)

And then use the returned user names  to select their data from the members table.

Any help much appreciated!

^.^
 

Hi all,

I have a number of tables within a mysql database and I'm stuck on how to pull information from one based on the results being displayed by another.

The site shows items for sale where by all the product information is held in tablea, when an individual item is being displayed I need to be able to pull a manufacturer profile from tableb based on the manufacturer name stored in tablea column profile. The manufacturer name is already being called into the page by existing code as the site has always shown the manufacturer name, I just can't work out out to pull the new profile information in as well from the new table.

Any help appreciated

Iain