parsing csv text array into db from http

terrypeck36

i am recieving a response from an http post as a csv seperated text array...i need to be able to take this data, and parse it so i can insert it into my db, does anyone know how to go about doing this...this is what the data looks like below. thanks for any help..:

Data will be returned in CSV (text/x-comma-separated-values MIME type)

"SITE_TAG","MEMBER_ID","MEMBER_STATUS"
"TEST1","1003","ACTIVE"
"TEST1","1005","ACTIVE"
"TEST1","1004","ACTIVE"

bradgrafelman

So this is posted to you via a form? Seems simple enough...

$data = explode("\n", str_replace("\r\n", "\n", $_POST['data']));

$fields = array_shift($data);
$fields = str_replace('"', '`', $fields);

$values = '';
foreach($data as $line)
	$values .= '(' . $line . '), ';
$values = rtrim($values, ', ');


$query = "INSERT INTO `myTable` ($fields) VALUES $values";

Note that this assumes that the field list will be the very first line of the data.

EDIT: I added a bit on to my code to account for \r\n line endings.. though the $data line might be better (and more efficiently?) written as:

$data = preg_split('/\r?\n/', $_POST['data']);

terrypeck36

hmm its not being sent in a form its is being posted back from a processor so they said this is what the data is going to look like in the response when i send a request so it is not form data....

bradgrafelman

Regardless of where it comes from, I assumed it was POST'ed to your script. If that isn't the case, then you'll need to adjust the explode() function accordingly.

terrypeck36

does it matter what is inside the post variable, so does it have to be named data

$_POST['data']

bradgrafelman

It can be named whatever you want to name it... however you're receiving the data.

Weedpacket

[man]fgetcsv[/man]. And if you need to send a POST request to get this CSV back and you don't want to do http protocol yourself, use [man]cURL[/man] and save the response to a temporary file so that fgetcsv() can read it.