PHP RSS PHP RSS

php table help

Reply

•
•
Join Date: Nov 2006
Posts: 2
Reputation: stevos is an unknown quantity at this point 
Solved Threads: 0
stevos stevos is offline Offline
Newbie Poster

php table help

 
0
  #1
Nov 3rd, 2006
Hi - was just wondering if anyone could help a php newbie

I'm trying to read in a list of items and display them in a table
What I would like to do is have a box of text to the left and one item from db alongside it followed by rows of three items

My micky mouse code is below - any help much appreciated

php Syntax (Toggle Plain Text) 
  1. <?
  2. include("conf/config.inc.php");
  3.  
  4. $p=$_GET['p'];
  5.  
  6. mysql_connect(localhost,$username,$password);
  7. @mysql_select_db($database) or die( "Unable to select database");
  8. $query="SELECT * FROM `products` where `cat_id` = $p";
  9. $result=mysql_query($query);
  10.  
  11. $num=mysql_numrows($result);
  12.  
  13. mysql_close();
  14. ?>
  15.  
  16. <table border='0'>
  17.     <tr>
  18.     <TD colspan="2" class="border" valign="top" width="390">
  19. <div class="sectitle">Large Shades</div>
  20.  
  21. <div class="txt">
  22. The Large Shade looks great as a pendant or you can <BR>
  23. team it with a large base to create a stunning table lamp.<BR><BR> 
  24. <b>Shade</b>: £00.00<BR>
  25. <b>Shade with ceramic base</b>: £00.00<BR><BR>
  26.  
  27. Dimensions<BR>
  28. <b>Shade</b>: height 20cm, diam 31cm<BR>
  29.  
  30. <b>Base</b>: height 50cm<BR>
  31. (Shade and base combined: height 70cm)<BR><BR>
  32.  
  33. <b>Bulb</b>: 60W Max<BR><BR>
  34. All products are great
  35.  
  36.  
  37. <?php
  38. $i=0;
  39. while ($i < $num) {
  40.  
  41.  
  42.   $name=mysql_result($result,$i,"name");
  43. $description=mysql_result($result,$i,"description");
  44. $price=mysql_result($result,$i,"price");
  45. $sm_image=mysql_result($result,$i,"sm_image_url");
  46. $lg_image=mysql_result($result,$i,"lg_image_url");
  47.  
  48.  
  49. ?>
  50.  
  51.  
  52.       <td><?php echo $name; ?> <br /> <img src=<?php echo $sm_image;  ?>
  53.     </td>
  54.  
  55.        </tr>  
  56.  
  57.  
  58. <?php
  59. $i++;
  60.  
  61. }
  62.  
  63. ?>
  64.  
  65. </table>
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2004
Posts: 494
Reputation: Puckdropper is an unknown quantity at this point 
Solved Threads: 21
Puckdropper Puckdropper is offline Offline
Posting Pro in Training

Re: php table help

 
0
  #2
Nov 4th, 2006
Ok, what's your question? What's not working as expected?

Tables are a HTML element, not a PHP thing so you're not going to find help for them looking around PHP.net.
www.uncreativelabs.net

Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2006
Posts: 2
Reputation: stevos is an unknown quantity at this point 
Solved Threads: 0
stevos stevos is offline Offline
Newbie Poster

Re: php table help

 
0
  #3
Nov 5th, 2006
I'm trying to build a 3 column table and populate with data from db but at present I just get a single column using the code above
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2006
Posts: 232
Reputation: Rhyan is an unknown quantity at this point 
Solved Threads: 24
Rhyan's Avatar
Rhyan Rhyan is offline Offline
Posting Whiz in Training

Re: php table help

 
0
  #4
Nov 7th, 2006
•
•
•
•
Originally Posted by stevos View Post
Hi - was just wondering if anyone could help a php newbie

I'm trying to read in a list of items and display them in a table
What I would like to do is have a box of text to the left and one item from db alongside it followed by rows of three items

My micky mouse code is below - any help much appreciated

php Syntax (Toggle Plain Text) 
  1. <?
  2. include("conf/config.inc.php");
  3.  
  4. $p=$_GET['p'];
  5.  
  6. mysql_connect(localhost,$username,$password);
  7. @mysql_select_db($database) or die( "Unable to select database");
  8. $query="SELECT * FROM `products` where `cat_id` = $p";
  9. $result=mysql_query($query);
  10.  
  11. $num=mysql_numrows($result);
  12.  
  13. mysql_close();
  14. ?>
  15.  
  16. <table border='0'>
  17.     <tr>
  18.     <TD colspan="2" class="border" valign="top" width="390">
  19. <div class="sectitle">Large Shades</div>
  20.  
  21. <div class="txt">
  22. The Large Shade looks great as a pendant or you can <BR>
  23. team it with a large base to create a stunning table lamp.<BR><BR> 
  24. <b>Shade</b>: £00.00<BR>
  25. <b>Shade with ceramic base</b>: £00.00<BR><BR>
  26.  
  27. Dimensions<BR>
  28. <b>Shade</b>: height 20cm, diam 31cm<BR>
  29.  
  30. <b>Base</b>: height 50cm<BR>
  31. (Shade and base combined: height 70cm)<BR><BR>
  32.  
  33. <b>Bulb</b>: 60W Max<BR><BR>
  34. All products are great
  35.  
  36.  
  37. <?php
  38. $i=0;
  39. while ($i < $num) {
  40.  
  41.  
  42.   $name=mysql_result($result,$i,"name");
  43. $description=mysql_result($result,$i,"description");
  44. $price=mysql_result($result,$i,"price");
  45. $sm_image=mysql_result($result,$i,"sm_image_url");
  46. $lg_image=mysql_result($result,$i,"lg_image_url");
  47.  
  48.  
  49. ?>
  50.  
  51.  
  52.       <td><?php echo $name; ?> <br /> <img src=<?php echo $sm_image;  ?>
  53.     </td>
  54.  
  55.        </tr>  
  56.  
  57.  
  58. <?php
  59. $i++;
  60.  
  61. }
  62.  
  63. ?>
  64.  
  65. </table>
my friend,

You are trying to do it the hard way. Let's say you have the following columns in your sql table: price, big_img, small_img, description

all you need to do is run it like this

[php]$connect=mysql_connect('localhost', $user, $pass);
$selectdb=mysql_select_db('yourdb');
if (!$selectdb)
{echo mysql_error()}
$query= "SELECT price, big_img, small_img, description FROM mytable;";
$runquery = myslq_query($query);
$rows = mysql_num_rows($runquery);

// here starts the table. As you have the row number, you can use the for cycle. Still while is good enough.

echo '<table id="mytable">';
for ($i=0; $i<$rows; $i++)
{
$result=mysql_fetch_array($runquery);
echo '<tr>
<td>'.$result['price'].'</td>
<td>'.$result['big_img'].'</td>
<td>'.$result['small_img'].'</td>
<td>'.$result['description'].'</td>
</tr>';
}
echo '</table>';[/php]
That's all.

Let me clarify it for you so you can understand:

1. mysql_fetch_array loads into your variable an array, which can be accessed both using numeric keys, or using names as they appear into your mysql table. So - if you know the names of the mysql table coloumns, you can access the value using both $result['0'] or $result['coloumn_name']. Both are valid.

2. There is no need to create new variables to load the values from the result array into separate values, however if you feel comfortable to use it like this $price=$result['price'] - it is ok, however to me seems a bit of unnecessary effort.

3. The for cycle - that is the fun part - the cycle creates a <tr></tr> element with all table cells you need. Basicly - the more <td></td> elements you have the more coloumns you create. Thats all.

If you have some trouble, you can always ask again.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



ajax apache api array arrays beginner binary broken cache cakephp checkbox class cms code confirm cron curl customizableitems database date display dynamic echo email error external file files folder form forms forum function functions google header headmethod howtowriteathesis href htaccess html iframe image include insert integration ip java javascript joomla limit link login loop mail malfunction menu method mlm multiple mysql neutrality oop paypal pdf php phpmysql play problem query question radio random recursion regex remote root script search select server sessions sms soap source space sql syntax system table tutorial update upload url validator variable video web xml youtube
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC