CODEWITHSUNDEEP
phphtmlexcel
Andrea Self
Andrea Self

Reputation: 1

Populate table from excel file using php

I am trying to use data from an excel spreasheet to populate an html table using php. I am a beginner at PHP. I have tried to use code from other questions, and they were close but not quite what I needed. The excel document will be periodically updated by another person.

Here's an example of code I've used: 

$file = file("/calendar.txt");

print "<table> 
<tr><td>Date</td><td>Start Time</td><td>Venue</td><td>Description</td></tr>";

foreach($file as $line){ 
$line = trim($line); 
$split = mb_split("\t",$line); 

print "<tr><td>$split[3]</td><td>$split[4]</td><td>$split[5]</td><td>$split[6]</td></tr>"; 
}

print "</table>";

?>

But the above example does not allow for auto-population. So I tried this:

<table>
<?php
if (($handle = fopen("/calendar.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {
      $num = count($data);
      for ($c=0; $c < $num; $c++) {
        print "<tr><td> $data[$c] </td></tr>";
    }

}
fclose($handle);
}
?> 
</table>

But I couldn't get the columns I wanted. Plus both examples did not allow for a new row/column created at the end of the last column from the source file (i.e. the data from the last column in the first row is combined with the first column of the second row).

I would also like to echo the line, "There are no upcoming dates currently. Please check back soon!" if there is no information to display. And is there a way to do a colspan in php? Here are my failed attempts: http://www.tonejones.com/calendar3.php
I want the table to look like this: http://www.tonejones.com/calendar.php

Upvotes: 0

Views: 2373

Answers (2)

Abhay Anand
Abhay Anand

Reputation: 602

To populate Data from Excel to Table. First We need to retrieve all data into Array then we will render all Array values into table.Get reference to retrieve data into array. https://www.studytutorial.in/how-to-upload-or-import-an-excel-file-into-mysql-database-using-spout-library-using-php. IF you get array then use below code 

<table>
   <?php foreach($rows as $value){ ?>
  <tr>
    <td><?php echo $value; ?></td>
  </tr>
  <?php } ?>
</table>

Upvotes: 1

Mark Baker
Mark Baker

Reputation: 212412

Your block should go around the collection of cells, not each individual cell:

print "<table>    
<tr><td>Date</td><td>Start Time</td><td>Venue</td><td>Description</td></tr>";
<?php 
if (($handle = fopen("/calendar.csv", "r")) !== FALSE) { 
    while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) { 
        $num = count($data); 
        print "<tr>";
        for ($c=3; $c < $num; $c++) { 
            print "<td> $data[$c] </td>"; 
        } 
        print "<tr>"; 
    } 
    fclose($handle); 
} else {
    print "<tr><tdcolspan="4">
              There are no upcoming dates currently. Please check back soon!
           </td></tr>";
}
?>  
</table>

Upvotes: 0

Related Questions