How to import csv file in PHP?

Question

I am very new to web development. In fact, I am just starting to learn.

Can somebody please give a complete but very simple example on how to import CSV file in PHP? I tried the one I got from the internet but I'm very confused because it's complicated for me. I am using the WAMP server with PHP 5.3.5, Apache 2.2.17, and MySQL 5.5.8. Please help.

I tried to paste the code but it's messy. Honestly, I am also very new to StackOverflow.

Answer 1

From the PHP manual:

<?php $row = 1; if (($handle = fopen("test.csv", "r")) !== FALSE) {     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); } ?> 

Answer 2

I know that this has been asked more than three years ago. But the answer accepted is not extremely useful.

The following code is more useful.

<?php $File = 'loginevents.csv';  $arrResult  = array(); $handle     = fopen($File, "r"); if(empty($handle) === false) {     while(($data = fgetcsv($handle, 1000, ",")) !== FALSE){         $arrResult[] = $data;     }     fclose($handle); } print_r($arrResult); ?>