How to get Csv File Data in php

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt;
<html xmlns=”http://www.w3.org/1999/xhtml”&gt;
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
<title>Untitled Document</title>
</head>

<body>
<table>
<tbody>
<tr>
<th>Name:</th>
<th>Email:</th>
<th>Contact:</th>
<th>Gender:</th>
</tr>
<?Php
$file_handle = fopen(“test.csv”, “r”);
while (!feof($file_handle) ) {
$text = fgetcsv($file_handle, 1024);
?>
<tr><td><?php echo $text[0];?></td><td><?php echo $text[1];?></td><td><?php echo $text[2];?></td><td><?php echo $text[3];?></td></tr>

<?php }

fclose($file_handle);

?>
</tbody>
</table>
</body>
</html>
<style>

table {
border: 1px solid;
border-collapse: collapse;
margin: 0 auto;
width: 40%;
}
th {
text-align: left;
background:#333;
color:#fff;
}

td {
border: 1px solid;
text-align: left;
}
</style>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s