Displaying CSV File in a Table Using PHP

Dev Shed Forums Sponsor:

January 31st, 2013, 03:08 PM

Gazza58

Registered User

Join Date: Jan 2013

Posts: 3

Time spent in forums: 38 m 43 sec
Reputation Power: 0

PHP-General - Displaying CSV File in a Table Using PHP

Hello Can anyone advise me on how I can display a CSV File in a Table Using PHP.

I can display the data in a line using the following:-

PHP Code:


		
			
<html>

<head>

<title>A BASIC HTML FORM</title>

<body>



<?PHP

 

$file_handle = fopen("csv/pins.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] . $line_of_text[3] . $line_of_text[4] ."<BR>";

 

}

 

fclose($file_handle);

 

?>

</body>

</html>

I want to move text[0], text[1] etc into cells in a table

Any assistance would be appreciated

Thanks

January 31st, 2013, 03:19 PM

ManiacDan

Likely to be eaten by a grue.

Dev Shed God 10th Plane (9500 - 9999 posts)

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,805

Folding Points: 127430 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 2 Months 3 Weeks 17 h 43 m 13 sec
Reputation Power: 6112

PHP Code:


		
			
print '<tr><td>' . $line_of_text[0] . '</td><td>' . $line_of_text[1]. //etc

__________________
HEY! YOU! Read the New User Guide and Forum Rules

"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.

January 31st, 2013, 03:36 PM

Gazza58

Registered User

Join Date: Jan 2013

Posts: 3

Time spent in forums: 38 m 43 sec
Reputation Power: 0

Quote:

Originally Posted by ManiacDan

PHP Code:


		
			
print '<tr><td>' . $line_of_text[0] . '</td><td>' . $line_of_text[1]. //etc

I appear to be missing something, I've tried this but it doesn't work can you advise

PHP Code:


		
			
<html>

<head>

<title>A BASIC HTML FORM</title>

<body>



<?PHP

 

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

 

while (!feof($file_handle) ) {

 

$line_of_text = fgetcsv($file_handle, 1024);

 



print '<p><div align="center"><table border cellpadding="2" cellspacing="0" width="676" bordercolor="gray" bordercolordark="gray" bordercolorlight="gray"><tr><td>' . $line_of_text[0] . '</td><td>' . $line_of_text[1]. '<tr><td>' . $line_of_text[2] . '</td><td>' . $line_of_text[3]. '<tr><td>' . $line_of_text[4] . '</td></tr></table></div>'





}

 

fclose($file_handle);

 

?>





</body>

</html>

January 31st, 2013, 03:51 PM

ManiacDan

Likely to be eaten by a grue.

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,805

Time spent in forums: 2 Months 3 Weeks 17 h 43 m 13 sec
Reputation Power: 6112

You need to learn some HTML before you try PHP. DIV and P tags cannot be placed inside a table, and a table requires a <table> tag.

PHP Code:


		
			
<html> 

<head> 

<title>A BASIC HTML FORM</title> 

<body> 

<table border=1>

<?PHP 

  

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

  

while (!feof($file_handle) ) { 

  

$line_of_text = fgetcsv($file_handle, 1024); 



    echo '<tr><td>' . $line_of_text[0] . '</td><td>' . $line_of_text[1] . '</td><td>' . $line_of_text[2] . '</td><td>' . $line_of_text[3] . '</td><td>' . $line_of_text[4] . '</td></tr>';



} 

  

fclose($file_handle); 

  

?> 



</table>



</body> 

</html>

February 1st, 2013, 01:26 AM

Gazza58

Registered User

Join Date: Jan 2013

Posts: 3

Time spent in forums: 38 m 43 sec
Reputation Power: 0

Thanks for your help, I see where I went wrong, sorted now

PHP-General - Displaying CSV File in a Table Using PHP

Developer Shed Advertisers and Affiliates