Menu
Community /Pin to ProfileBookmark
@NogDogFeb 21.2006 — #If you save the Excel file as a CSV file, then it's pretty easy to read/parse the data with PHP's [url=http://www.php.net/fgetcsv]fgetcsv() function[/url] .@NogDogFeb 21.2006 — #Beginning PHP: http://www.zend.com/php/beginners/index.php
From the link I gave in my prior reply:
Trying to input data into a website and allow sorting by users…
I’m wanting to input a data base of input, onto my website and then have my users able to Sort through this data. Basically an Excel File on my website…is this possible, and what would I need or what would I need to do to make this happen?
Thanks Chunky
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogFeb 21.2006 — #If you save the Excel file as a CSV file, then it's pretty easy to read/parse the data with PHP's 0
@NogDogFeb 21.2006 — #Beginning PHP: From the link I gave in my prior reply:
Example 1. Read and print the entire contents of a CSV file
[code=php]
<?php
$row = 1;
$handle = fopen("test.csv", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
echo "<p> $num fields in line $row: <br /></p>n";
$row++;
for ($c=0; $c < $num; $c++) {
echo $data[$c] . "<br />n";
}
}
fclose($handle);
?>
[/code]
[/quote]