How to create a table in HTML using PHP

Question

I have 5 pictures stored in a folder and their links stored on the database. I want to put them in a table of three columns on each row.

<body>
<center>
<table border='1'>
<?php
$host="";
$username="";
$password="";
$db_name="fruits_db";
$tbl_name="fruits_tbl";
$connection=mysqli_connect("$host","$username","$password","$db_name");
if (mysqli_connect_errno())
{
    echo "The application has failed to connect to the mysql database server: " .mysqli_connect_error();
}
$result = mysqli_query($connection, "SELECT * FROM fruits_tbl")or die("Error: " . mysqli_error($connection));
$num_rows=mysqli_num_rows($result);
$rows =  $num_rows/3;

for($i=1; $i<=$rows ; $i++)
{
    echo "<tr>";
    for($j=1; $j<=3; $j++)
    {
        while($row = mysqli_fetch_array($result))
        {
            echo
            ("<td width='180px' height='200px'>"
             ."<div class = 'fruit_image'>"
             ."<img src='"
             .$row['fruit_image']
             ."'/>"
             ."</div>"
             ."<div class = 'fruit_title'>"
             .$row['fruit_name']
             ."</div>"
             ."</td>"
            );
        }
    }
    echo "</tr>";
}

mysqli_close($connection);
?>
</table>
</center>
</body>
</html>

The above code I created, contains two FOR loops. The script should count the number of rows in the table, and then divide by 3(the number of columns on each row in the HTML table). I wonder where I'm going wrong wit this code.

Your inner while() loop is doing to completely consume the DB results, so the 2nd and subsequent $j loops are going to have NO data to work with, because there's no results left from the query. — Marc B
– Marc B, Commented Jun 2, 2013 at 2:25

Sean · Accepted Answer · 2013-06-02 01:27:06Z

1

With your while($row = mysqli_fetch_array($result)){} inside your 1st for loop it will run through all your rows, before the outside loop runs 2nd/3rd time.

Here is another way to do it -

$counter = 1;
// start 1st row
echo "<tr>";
while($row = mysqli_fetch_array($result)){
// if the 4th cell, end last row, and start new row
    if ($counter%3==1){
        echo "</tr><tr>";
    }
    echo
        "<td width='180px' height='200px'>"
        ."<div class = 'fruit_image'>"
        ."<img src='"
        .$row['fruit_image']
        ."'/>"
        ."</div>"
        ."<div class = 'fruit_title'>"
        .$row['fruit_name']
        ."</div>"
        ."</td>";
    // increase the counter
    $counter++;
}
// close the last row
echo "</tr>";

edited Jun 2, 2013 at 1:27

answered Jun 2, 2013 at 1:17

Sean

12.4k3 gold badges31 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jcsanyi · Accepted Answer · 2013-06-02 01:14:34Z

0

You're looping through all the results in the first table cell. Try something like this instead:

for($i=1; $i<=$rows ; $i++) {
    echo "<tr>";
    for($j=1; $j<=3; $j++) {
        $row = mysqli_fetch_array($result);
        if ($row) {
            echo(
                "<td width='180px' height='200px'>"
                ."<div class = 'fruit_image'>"
                ."<img src='"
                .$row['fruit_image']
                ."'/>"
                ."</div>"
                ."<div class = 'fruit_title'>"
                .$row['fruit_name']
                ."</div>"
                ."</td>"
            );
        }
    }
    echo "</tr>";
}

answered Jun 2, 2013 at 1:14

jcsanyi

8,2042 gold badges31 silver badges52 bronze badges

4 Comments

Eli Skywalker Over a year ago

thanks a lot... It's working. I also had to change the $rows = $num_rows/3; to $rows = $num_rows%3;

jcsanyi Over a year ago

That actually won't work for larger numbers. It should be $rows = ceil($num_rows / 3);

Eli Skywalker Over a year ago

Thanks, so this should always round it up to the next highest integer value. Been looking for this...

Eli Skywalker Over a year ago

By the way, is there a way in the loop I could load only 6 cells (3 columns per row) on each page, and have it pick up from where it left off in the previous page?... i.e, load all items from 1 - 6 rows on the database and then on the next page, load rows 7 - 12 and rows 13 - 18 on the next, etc...

Revent · Accepted Answer · 2013-06-02 01:27:16Z

0

If you just want to format the display with a new row after every 3 records, you could use the modulus operator:

$cntr = 0;
echo '<tr>';
while($row = mysqli_fetch_array($result)) {
   $cntr++;
   echo '
      <td width="180px" height="200px">
         <div class="fruit_image">
            <img src="'.$row['fruit_image'].'" />
         </div>
         <div class="fruit_title">'.$row['fruit_name'].'</div>
      </td>';
   if ($cntr % 3 == 0 && $cntr != $num_rows)
      echo '</tr><tr>';
}
echo '</tr>';

Keep in mind however that all the solutions presented so far may leave you with a last row with one or two td elements. You can fill this if you desire with empty <td> </td> columns.

answered Jun 2, 2013 at 1:27

Revent

2,0922 gold badges20 silver badges33 bronze badges

2 Comments

Eli Skywalker Over a year ago

thanks. I will try this code too. However I am not so much worried about the missing td elements as I won't be using that area. But for the sake of pure html principle, maybe I should be worried...?

Revent Over a year ago

As long as the display is ok, it doesn't really matter.

rajratna maitry · Accepted Answer · 2015-02-10 08:43:11Z

0

    print "<center><table border=1>
        <tr>
        <td>id</td>
        <td>name</td>
        <td>company</td>
        <td>branch</td>
        <td>job title</td>
        <td>contact</td>
        <td>email</td>
        <td>mgs</td>
        </tr>";

    while($row=mysql_fetch_array($query))
    {
        print "<tr>";
       for ($i=0;$i<=(count($row)/2);$i++)
              {
               print "<td>$row[$i]</td>";
               } print"</tr>";
   }

    }
    else{echo " <p>No Records Found</p>";}

answered Feb 10, 2015 at 8:43

rajratna maitry

5084 silver badges11 bronze badges

1 Comment

rajratna maitry Over a year ago

How to fetch and print table with minimum line of code this code. it can be use in function and in class also.

Mishari · Accepted Answer · 2019-04-14 07:42:42Z

0

<?php
function studentTable($name,$grade){
echo "<tr> <td>$name</td><td>$grade</td></tr>";
}
?>
    <table style="width:100%" border="solid">
<tr>
<th>Name</th>
<th>Grade</th> 
 </tr>
 <?php studentTable("Sarah", 90) ?>

answered Apr 14, 2019 at 7:42

Mishari

1

Collectives™ on Stack Overflow

How to create a table in HTML using PHP

5 Answers 5

Comments

4 Comments

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

4 Comments

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related