Creating a file with html table

[Drongo_III]

Hi Guys

 

I'm trying to create a little script that can read in a csv file and then write this as html to a text file.

 

I'm ok reading in the csv and generating the html table in browser but i'm at a loss as to how i can pass this newly create html table into a variable to pass to the filewrite.

 

What i want to acheive is a text file with the html code for the table.

 

echo "<table>\n";

$row = 0;
$handle = fopen("testfile.csv", "r");

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    if ($row == 0) {
        // this is the first line of the csv file
        // it usually contains titles of columns
        $num = count($data);
        echo "<thead>\n<tr>";
        $row++;
        for ($c=0; $c < $num; $c++) {
            echo "<th>" . $data[$c] . "</th>";
        }
        echo "</tr>\n</thead>\n\n<tbody>";
    } else {
        // this handles the rest of the lines of the csv file
        $num = count($data);
        echo "<tr>";
        $row++;
        for ($c=0; $c < $num; $c++) {
            echo "<td>" . $data[$c] . "</td>";
        }
        echo "</tr>\n";
    }
}
fclose($handle);

echo "</tbody>\n</table>";

 

Still very new to php so any advice or help would be appreciated.

 

Thanks,

 

Drongo

[Drongo_III]

Well solved this noob problem now!

 

For anyone who may, at the start of the php career, be similarly perplexed here is what i did...

 

 

<?php

$builder = "<table>\n";





$row = 0;
$handle = fopen("testfile.csv", "r");

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    if ($row == 0) {
        // this is the first line of the csv file
        // it usually contains titles of columns
        $num = count($data);
        $builder = $builder . "\n<tr>";

        $row++;
        for ($c=0; $c < $num; $c++) {
            

		$builder = $builder .  "<td>" . $data[$c] . "</td>";


        }

	$builder = $builder . "</tr>\n\n<tbody>";
      
    } else {
        // this handles the rest of the lines of the csv file
        $num = count($data);
	$builder = $builder . "<tr>";
    
        $row++;
        for ($c=0; $c < $num; $c++) {
    
		$builder = $builder . "<td>" . $data[$c] . "</td>";

        }
   
	$builder = $builder . "</tr>\n";
    }
}
fclose($handle);


$builder = $builder . "</tbody>\n</table>";


echo $builder;


$myFile = "testFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");
fwrite($fh, $builder);
fclose($fh);





?>

 

Sorry for posting such a silly question i just couldn't figure it at first :/

 

Drongo