store the data of the csv file into a 2d array

Question

suppose I have the following csv file called mycsv.csv

   "Date"      "order 1"   "order 2"   "order 3"          "total cost"
   01/04/2006   4 tires      1 oil       6 sparks plugs    "434.00$'
   03/08/2006   3 tires      2 oil       2 sparks plugs    "234.00$'
   03/12/2006   2 tires      0 oil       1 sparks plugs    "134.00$'

I want to know how to store the those data in a 2d array, any help will be greatly appreciated!

Answer 1

You might use fgetcsv(see: http://php.net/manual/en/function.fgetcsv.php). The difference to str_getcsv is that it takes a File resource as parameter and not a String.

You might also store each row in another Array to have a 2D Array e.g. (adjusted manual page example)

$twoDarray = array();
if (($handle = fopen("mycsv.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $twoDarray[] = $data;
    }
    fclose($handle);
}