CSV Multidimensional Array

[verdrm]

I need to extract data from a CSV file and insert it into a MySQL database. I am able to extract the data, however I cannot figure out how to group it.

 

Sample File:

01  ISBN  Name of Book  Price

02  ISBN  Name of Book  Price

 

So far I have an array with the entire file (reading file with PHP):

 

Array ([0] => 01 [1] => 12345678X [2] => Title [3] => 120.00 ...etc.

 

How can I modify the array to create groups of four for each item? Each item is its own array?

[n3r0x]

would do something like this.

 

$storage_array = array();
// Split it into rows
$parts = explode("\n",$file);
$x=0;
// For each row
foreach ($parts AS $v) {
// This one depends on the format of your file if they use tab it should have \t and so on
// Split into elements
$storage_array[$x] = explode("\t",$v);
++$x;
}