Creating several tables from CSV with PHP

Question

The following code works with the CSV-file.

But I want to create more than one table and the values are in the same CSV.

How should I use the $rowcount in the second table, that should look like the first one, only with other first-value for th and the following values for the td's.

<a name="akademische-berufe"></a> 
<table class="table-vocabulary">
<tbody>   
<?php 
$file = new SplFileObject("arbeit.csv");
$file->setFlags(SplFileObject::READ_CSV);

$rowcount = 0;
foreach ($file as $row) {
  $rowcount++;
  if ($rowcount == 1) {
  list($vokabel_en, $vokabel_de) = $row;      
    printf('
    <tr>
      <th><img src="/bilder/symbole/play.png" data-text="%1$s" data-lang="'.$lang_code1.'" class="trigger_play"> %1$s</th> 
      <th><img src="/bilder/symbole/play.png" data-text="%2$s" data-lang="'.$lang_code2.'" class="trigger_play"> %2$s</th>
    </tr>', $vokabel_en, $vokabel_de);
    continue;
}  
  if ($rowcount >= 31) break;
  list($vokabel_en, $vokabel_de) = $row;      
    printf('
    <tr>
      <td><img src="/bilder/symbole/play.png" data-text="%1$s" data-lang="'.$lang_code1.'" class="trigger_play"> %1$s</td> 
      <td><img src="/bilder/symbole/play.png" data-text="%2$s" data-lang="'.$lang_code2.'" class="trigger_play"> %2$s</td>
    </tr>', $vokabel_en, $vokabel_de); 
}  
?>
</tbody>
</table>

Santhos · Accepted Answer · 2014-07-12 07:38:01Z

3

Create a function with the parameters you want. Let the function also echo (print) the table tag and you are done.

User-defined php functions: http://www.php.net/manual/en/functions.user-defined.php

The code could then look like this:

<a name="akademische-berufe"></a>  
<?php
function CreateLangTable($csvFile, $startRow, $endRow) {
  if ($endRow < $startRow) {
    return;
  }

  echo '<table class="table-vocabulary"><tbody>';

  $csvFile->seek($startRow);

  vprintf('
      <tr>
        <th><img src="/bilder/symbole/play.png" data-text="%1$s" data-lang="'.$lang_code1.'" class="trigger_play"> %1$s</th> 
        <th><img src="/bilder/symbole/play.png" data-text="%2$s" data-lang="'.$lang_code2.'" class="trigger_play"> %2$s</th>
      </tr>', 
      $csvFile->current());

  while ($csvFile->key() <= $endRow) {
    $csvFile->next();

    vprintf('
      <tr>
        <td><img src="/bilder/symbole/play.png" data-text="%1$s" data-lang="'.$lang_code1.'" class="trigger_play"> %1$s</td> 
        <td><img src="/bilder/symbole/play.png" data-text="%2$s" data-lang="'.$lang_code2.'" class="trigger_play"> %2$s</td>
      </tr>', 
      $csvFile->current());
  }

  echo '</tbody></table>';
}

$file = new SplFileObject("arbeit.csv");
$file->setFlags(SplFileObject::READ_CSV);

CreateLangTable($file, 1, 31);

CreateLangTable($file, 33, 58);
?>

EDIT: In case you have empty rows dividing the tables then instead of

while ($csvFile->key() <= $endRow)

you can use

while (!empty($csvFile->current()))

you can then obviously omit/remove the function parameter $endRow

edited Jul 12, 2014 at 7:38

answered Jul 10, 2014 at 11:43

Santhos

3,5285 gold badges33 silver badges49 bronze badges

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

8 Comments

Grischa Over a year ago

Thank you, but I don't know how? Can you show me it?

Santhos Over a year ago

Ok, no problem. Give me few minutes.

Santhos Over a year ago

How exactly would you like to change the values in th and td? What should change there?

Grischa Over a year ago

first table th 1 td's 2-31, second table th 33, td's 34-58

Santhos Over a year ago

Yes, well list is a pretty old construction that should not be used at all in php in my opinion. And since you use the SplFileObject, maybe it would be wise to do the whole thing in an object...but the function will do fine as well. There are some basic design mistakes in the code though, but you will learn that in time and practise.

|

Collectives™ on Stack Overflow

Creating several tables from CSV with PHP

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related