Jump to content

CSV Multidimensional Array


Recommended Posts

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?

Link to comment
Share on other sites

would do something like this.


$storage_array = array();
// Split it into rows
$parts = explode("\n",$file);
// 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);

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.