Hi I am trying to use the fgetcsv function to display a csv file in a "results" page.

The page is here http://www.rhinoracks.co.uk/test.php

Is it possible to format the output of this file, so the the data is displayed in a tabular form with colum and row shading?? like in the example table below the out put?

code is here... (also my pound signs are showing as squares so i guess ive got to add aline to the top of the page to sort this??)

<?PHP

$file_handle = fopen("./csv/berlingo.csv", "r");

while (!feof($file_handle) ) {


$line_of_text = fgetcsv($file_handle, 1024);

print $line_of_text[0] . $line_of_text[1]. $line_of_text[2] . "<BR>";

}

fclose($file_handle);

?>

Hi,

your code should looks something like:

PHP Code:

echo '<style type="text/css">
<!--
.style5 {font-family: Arial, Helvetica, sans-serif; font-size: 11px; color: #FFFFFF; }
.style6 {color: #CCCCCC}
-->
</style>';

echo '<table width="612" border="0" cellspacing="2" cellpadding="0">
  <tr>
    <td width="68" bgcolor="#000033"><div align="center"><span class="style5">Make</span></div></td>
    <td width="170" bgcolor="#000033"><div align="center"><span class="style5">Product Code </span></div></td>
    <td width="130" bgcolor="#000033"><div align="center"><span class="style5">Description</span></div></td>
    <td width="58" bgcolor="#000033"><div align="center"><span class="style5">Price</span></div></td>
    <td width="186" bgcolor="#000033"><div align="center"><span class="style5">Price inc VAT </span></div></td>
  </tr>';
  
$file_handle = fopen("./csv/berlingo.csv", "r");

$odd = true;


$colors = array('#E0E0E0', '#FFFFFF');

while (!feof($file_handle) ) {

    $line_of_text = fgetcsv($file_handle, 1024);
    $odd = true;
    while ($line_of_text)
    {   
        if ($odd) 
            {
                $clr = $colors[0];
                $odd = false;                
            }
        else
            {
                $clr = $colors[1];
                $odd = true;                                
            }            
    echo '
    <tr>
            <td bgcolor="'.$clr.'">'.$line_of_text[0].'</td>
            <td bgcolor="'.$clr.'">'.$line_of_text[1].'</td>
            <td bgcolor="'.$clr.'">'.$line_of_text[2].'</td>
            <td bgcolor="'.$clr.'">'.htmlentities($line_of_text[3]).'</td>
            <td bgcolor="'.$clr.'">&nbsp;</td>
    </tr>';
    $line_of_text = fgetcsv($file_handle, 1024);
    }
  
}

fclose($file_handle);                        
echo '</table>'; 


Hmmm, that just produced loads of code at the top of the page...

I've changed the code slightly now to this, so it displays in a table but still cant figure out how to format it...

<?
//Define what you want the seperator to be, this could be new line, (\n) a tab (\t) or any other char, for obvious reasons avoid using chars that will be present in the string.  Id suggest a comma, or semicolon.
$sep = ",";

//define file to read
$file = "./csv/berlingo.csv";

//read the file into an array
$lines = file($file);

//count the array
$numlines = count($lines);

//explode the first (0) line which will be the header line
$headers = explode($sep, $lines[0]);

//count the number of headers
$numheaders = count($headers);

$i = 0;

//start formatting output
echo "<table border = 1 cellpadding = 2><tr>";

//loop through the headers outputting them into their own <TD> cells
while($i<$numheaders){
        $headers = str_replace("\"", "", $headers);
        echo "<td>".$headers[$i]."</td>";
        $i++;
        }

echo "</tr>";

$y = 1;

//Output the data, looping through the number of lines of data and also looping through the number of cells in each line, as this is a dynamic number the header length has to be reread.
while($y<$numlines){
        $x=0;
        echo "<TR>";
                while($x<$numheaders){
                $fields = explode($sep, $lines[$y]);
                $fields = str_replace("\"", "", $fields);
                echo "<TD>&nbsp;".$fields[$x]." </TD>";
                $x++;
                        }
        $y++;
        echo "</TR>";
        }

//close the table.
echo "</table>";
?>

What did you mean by word "format"? Do you need to apply style to the table to make odd and even row different color? If so, why don't you just use CSS?

thats exactly what im trying to do...!

but thats the part im struggling on where and how to put the css...

example results canbe found here http://www.autorack.co.uk/results.ph...here+to+search.

basically, we have the csv that runs that site and need a simplified version.

then you might want think about building a code that separate the actual data from the html in the cvs

I'd suggest using fread instead of using fgetcsv and formatting the data from there by using explode() to split the values in the CSV file.

Thanks, I'll have a read up on those commands today.... (and I thought this was going to be easy...!)

Ok hit a wall here...

Can anyone give an example code of how to go about this???

Ive read up on fread and explode() but its not making sense to what im trying to do...

right think im getting somewhere...

Have a look at http://www.rhinoracks.co.uk/data.php this is ok and I can customise the look and fit it into my pages fine...

Can someone help with adjusting the code to my fields though... Im getting nowhere with it!

I need 1 less colum so that it would be

"product code" "description" "price(ex vat)" "price inc vat"

When I try and edit fields it throughs it all out!!

code here

<html><body>
<table border='1' cellspacing='0' cellpadding='5'
       width="440" style="border-collapse:collapse;
       font-family:sans-serif;">
<tr style="background-color:gainsboro"><th colspan="2">
Employee</th><th>Sex</th>
<th>Hired</th><th>Salary</th></tr>
<colgroup>
<col span="2" align="left" />
<col span="1" align="center" />
<col span="2" align="right" />
<?PHP
$oddColor='whitesmoke';
$evenColor='azure';
$ID=0; $FirstName=1; $LastName=2; $HireDate=3;
$ReviewDate=4; $Salary=5; $Sex=6; $IsSelected=6;
$TheFile = fopen ("info.txt", "r");
if($TheFile){
    $row = 0;
    $Employee = strval(fgets($TheFile, 4096));
    while (!feof ($TheFile)) {
        $rec = explode("~",$Employee);
        if($row % 2 == 0) {
            $rowStart = "<tr style='background-color:".$evenColor."'><td>"; }
        else {
            $rowStart = "<tr style='background-color:".$oddColor."'><td>"; }
        print $rowStart;
        print $rec[$FirstName]. "</td><td>" ;
        print $rec[$LastName]. "</td><td>" ;
        print $rec[$Sex]. "</td><td>" ;
        print $rec[$HireDate]. "</td><td>" ;
        print "$".$rec[$Salary]. "</td></tr>";
        $row++;
        $Employee = strval(fgets($TheFile, 4096));
    }
    fclose ($TheFile);
}
?>
</table></body></html>

Solved it...

http://www.rhinoracks.co.uk/berlingo.php

thanks for your help guys!

Check your code, your pound sign not displayed. Add semicolon after '&pound' in code.