Question

In: Computer Science

how to read a csv file in php and make a html table? Acme,Walmart,Ross,BJs,Target,Marshalls,Foot Locker,Giant,Charming Charlie...

how to read a csv file in php and make a html table?

Acme,Walmart,Ross,BJs,Target,Marshalls,Foot Locker,Giant,Charming Charlie

142,160,28,10,5,3,60,0.28,3167

175,180,18,8,4,1,12,0.43,4033

129,132,13,6,3,1,41,0.33,1471

138,140,17,7,3,1,22,0.46,3204

232,240,25,8,4,3,5,2.05,3613

135,140,18,7,4,3,9,0.57,3028

150,160,20,8,4,3,18,4.00,3131

207,225,22,8,4,2,16,2.22,5158

271,285,30,10,5,2,30,0.53,5702

89,90,10,5,3,1,43,0.30,2054

153,157,22,8,3,3,18,0.38,4127

87,90,16,7,3,1,50,0.65,1445

234,238,25,8,4,2,2,1.61,2087

106,116,20,8,4,1,13,0.22,2818

175,180,22,8,4,2,15,2.06,3917

165,170,17,8,4,2,33,0.46,2220

166,170,23,9,4,2,37,0.27,3498

136,140,19,7,3,1,22,0.63,3607

<!DOCTYPE html>

<html>

<head>

   <meta charset="utf-8">

   <title>Stores</title>

   <link rel="stylesheet" href="style.css">

</head>

<body>

<h1>Stores</h1>

<?php

<table>

<tr>

<th>Acme</th>

<th>Walmart</th>

<th>Ross</th>

<th>BJs</th>

<th>Target</th>

<th>Marshalls</th>

<th>Foot Locker</th>

<th>Giant</th>

<th>Charming Charlie</th>

</tr>

$Stores = fopen("stores.csv", "r");

<tr>

<td>$Acme</td>

<td>$Walmart</td>

<td>$Ross</td>

<td>$BJs</td>

<td>$Target</td>

<td>$Marshalls</td>

<td>$Foot Locker</td>

<td>$Giant</td>

<td>$Charming Charlie</td>

</tr>

print "</table>";

?>

</body>

</html>

Solutions

Expert Solution

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Here a new web page with name "Stores.php" is created, which contains following code.

Stores.php :

<!DOCTYPE html>

<html>

<head>

<meta charset="utf-8">

<!-- title for web page -->

<title>Stores</title>

<link rel="stylesheet" href="style.css">

</head>

<body>

<h1>Stores</h1>

<table border=1>

<tr>

<th>Acme</th>

<th>Walmart</th>

<th>Ross</th>

<th>BJs</th>

<th>Target</th>

<th>Marshalls</th>

<th>Foot Locker</th>

<th>Giant</th>

<th>Charming Charlie</th>

</tr>

<?php

//reasing file

$Stores = fopen("stores.csv", "r");

//read each line till end of the file

while(!feof($Stores))

{

?>

<tr>

<?php

//loop for each value from the line

foreach(fgetcsv($Stores) as $celldata)

{

?> <td>

<!-- print each value in the cell -->

<?php echo $celldata?></td>

<?php

}

}

?>

</body>

</html>

======================================================

Output : Open Stores.php in the browser through server and will get the screen as shown below

Screen 1 :Stores.php

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.


Related Solutions

how to read a csv file in php and make a html table? I can't use...
how to read a csv file in php and make a html table? I can't use the PHP function fgetcsv. I can use explode. I can't put a php inside a php. Acme,Walmart,Ross,BJs,Target,Marshalls,Foot Locker,Giant,Charming Charlie 142,160,28,10,5,3,60,0.28,3167 175,180,18,8,4,1,12,0.43,4033 129,132,13,6,3,1,41,0.33,1471 138,140,17,7,3,1,22,0.46,3204 232,240,25,8,4,3,5,2.05,3613 135,140,18,7,4,3,9,0.57,3028 150,160,20,8,4,3,18,4.00,3131 207,225,22,8,4,2,16,2.22,5158 271,285,30,10,5,2,30,0.53,5702 89,90,10,5,3,1,43,0.30,2054 153,157,22,8,3,3,18,0.38,4127 87,90,16,7,3,1,50,0.65,1445 234,238,25,8,4,2,2,1.61,2087 106,116,20,8,4,1,13,0.22,2818 175,180,22,8,4,2,15,2.06,3917 165,170,17,8,4,2,33,0.46,2220 166,170,23,9,4,2,37,0.27,3498 136,140,19,7,3,1,22,0.63,3607 <!DOCTYPE html> <html> <head>    <meta charset="utf-8">    <title>Stores</title>    <link rel="stylesheet" href="style.css"> </head> <body> <h1>Stores</h1> <?php <table> <tr> <th>Acme</th> <th>Walmart</th> <th>Ross</th> <th>BJs</th> <th>Target</th> <th>Marshalls</th> <th>Foot Locker</th>...
how to read a csv file in php not using fgetscsv or fgets. Just using file("Stores.csv");...
how to read a csv file in php not using fgetscsv or fgets. Just using file("Stores.csv"); or fopen("Stores.csv", "r"); and making into a html table? It print but it keeps saying Notice: Undefined offset: , Notice: Undefined offset: 2, etc at the top. Acme,Walmart,Ross,BJs,Target,Marshalls,Foot Locker,Giant,Charming Charlie 142,160,28,10,5,3,60,0.28,3167 175,180,18,8,4,1,12,0.43,4033 129,132,13,6,3,1,41,0.33,1471 138,140,17,7,3,1,22,0.46,3204 232,240,25,8,4,3,5,2.05,3613 135,140,18,7,4,3,9,0.57,3028 150,160,20,8,4,3,18,4.00,3131 207,225,22,8,4,2,16,2.22,5158 271,285,30,10,5,2,30,0.53,5702 89,90,10,5,3,1,43,0.30,2054 153,157,22,8,3,3,18,0.38,4127 87,90,16,7,3,1,50,0.65,1445 234,238,25,8,4,2,2,1.61,2087 106,116,20,8,4,1,13,0.22,2818 175,180,22,8,4,2,15,2.06,3917 165,170,17,8,4,2,33,0.46,2220 166,170,23,9,4,2,37,0.27,3498 136,140,19,7,3,1,22,0.63,3607 148,160,17,7,3,2,13,0.36,3648 151,153,19,8,4,2,24,0.34,3561 180,190,24,9,4,2,10,1.55,4681 293,305,26,8,4,3,6,0.46,7088 167,170,20,9,4,2,46,0.46,3482 190,193,22,9,5,2,37,0.48,3920 184,190,21,9,5,2,27,1.30,4162 157,165,20,8,4,2,7,0.30,3785 110,115,16,8,4,1,26,0.29,3103 135,145,18,7,4,1,35,0.43,3363 567,625,64,11,4,4,4,0.85,12192 180,185,20,8,4,2,11,1.00,3831 183,188,17,7,3,2,16,3.00,3564 185,193,20,9,3,2,56,6.49,3765 152,155,17,8,4,1,33,0.70,3361 148,153,13,6,3,2,22,0.39,3950...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT