Jump to content

Showing mysql php results in html table

dropbop

By dropbop
in PHP Coding Help

 Share

Recommended Posts

dropbop Member

dropbop

Posted
Posted

I was wondering how does one go about showing results from SELECT query in columns in a html table.

 

I have a list of products in a table, and would like to show them on the page in 4 columns. I have done many searches on google to try and find the sulution, but the majority of what im finding instead is about displaying a table from phpmyadmin as a table in html.

 

If its a large operation to do this, I would be very happy if someone could poiint me in the direction of a tutorial maybe.

 

Here is the code I have so far to display the products, but for some reason, it only show 1 row instead of all the rows from my table.

 

<?php

$dbhost = "localhost";
$dbuser = "user";
$dbpass = "pass";
$dbname = "dbname";

mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

$result = mysql_query("SELECT * FROM mcproducts");
while($row = mysql_fetch_array($result))
{
  $products_local_id = $row['products_local_id'];
  $productname = $row['product_name'];
  $thumburl = $row['image_from_url'];
  $productlink = $row['product_local_url'];
  $thumbnail = $row['product_image_small'];
  $currencysymbol = $row['product_currency'];
  $price = $row['product_price'];
  $flagicon = $row['product_country_from'];

}

?> 
<html>
<head>
<link href="style/stylesheet.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div class="displaybox">
                <div class="productimage">
                <a href="<?php echo $productlink; ?><?php echo $products_local_id; ?>"><img src="<?php echo $thumburl; ?><?php echo $thumbnail ?>" width="150" height="150"></a>
                </div>
                <div class="productdescription">
                  <div class="pro_name">
		      <a href="<?php echo $productlink ?><?php echo $products_local_id; ?>"><?php echo $productname; ?></a>
                  </div>
                  <div class="pro_description">
                  </div>
                  <?php
                  if ($flagicon=="Ireland") {
				  $flagicon = "<img src=\"flags/ireland.jpg\">";
				  }
				  
				  elseif ($flagicon=="UK") {
					  $flagicon = "<img src=\"flags/uk.jpg\">";
					  }  else
					  echo "";
  ?>
                  <div class="pro_description"><?php echo $flagicon; ?><?php echo $currencysymbol ?> <?php echo $price ?></div>
                </div>
              </div>
              
</body>
</html>

 

Many thanks,

 

DB

Link to comment
https://forums.phpfreaks.com/topic/245956-showing-mysql-php-results-in-html-table/
Share on other sites
dropbop Member

dropbop

Posted
  • Author
Posted

Ah yes!!, well spotted, never even occured to me....  :)  cheers for that.

 

Here is what I have now and with a little help from css, I have it showing as many columns as will fit :)

 

<?php
mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

$output = "";
$result = mysql_query("SELECT * FROM mcproducts ORDER BY RAND() LIMIT 10");
while($row = mysql_fetch_array($result))
{
  $products_local_id = $row['products_local_id'];
  $productname = $row['product_name'];
  $thumburl = $row['image_from_url'];
  $productlink = $row['product_local_url'];
  $thumbnail = $row['product_image_small'];
  $currencysymbol = $row['product_currency'];
  $price = $row['product_price'];
  $flagicon = $row['product_country_from'];
  $output = "
  <div class=\"productimage\">
                <a href=".$productlink."".$products_local_id."><img src=".$thumburl."".$thumbnail." width=\"150\" height=\"150\"></a>
                </div>
                <div class=\"productdescription\">
                  <div class=\"pro_name\">
		      <a href=".$productlink."".$products_local_id.">".$productname."</a>
                  </div>
                  <div class=\"pro_description\">
                  </div>
                  <div class=\"pro_description\">".$flagicon." ".$currencysymbol." ".$price."</div>
                </div>

         ";

?> 
<html>
<head>
<link href="style/stylesheet.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="displaybox">
                <div class="productimage">
                <a href="<?php echo $productlink; ?><?php echo $products_local_id; ?>"><img src="<?php echo $thumburl; ?><?php echo $thumbnail ?>" width="150" height="150"></a>
                </div>
                <div class="productdescription">
                  <div class="pro_name">
		      <a href="<?php echo $productlink ?><?php echo $products_local_id; ?>"><?php echo $productname; ?></a>
                  </div>
                  <div class="pro_description">
                  </div>
                  <?php
                  if ($flagicon=="Ireland") {
				  $flagicon = "<img src=\"flags/ireland.jpg\">";
				  }
				  
				  elseif ($flagicon=="UK") {
					  $flagicon = "<img src=\"flags/uk.jpg\">";
					  }  else
					  echo "";
  ?>
                  <div class="pro_description"><?php echo $flagicon; ?><?php echo $currencysymbol; ?> <?php echo $price; ?></div>
                </div>
              </div>
              <?php } ?>
</body>
</html>

 

Thanks again AyKay47, that was a quick resonse from you... really appreciated indeed :)

 

DB

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.