PHP curl Response string splitting

Question

So here is the issue. I am pulling a CSV file from an API and need to place it into an array. Here is my current code:

$url = "https://www.*****************";
$myvars = 'username=*********&password=*************';

$ch = curl_init( $url );
curl_setopt( $ch, CURLOPT_POST, 1);
curl_setopt( $ch, CURLOPT_POSTFIELDS, $myvars);
curl_setopt( $ch, CURLOPT_FOLLOWLOCATION, 1);
//curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text'));
curl_setopt( $ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); 
curl_setopt($ch, CURLOPT_VERBOSE, true); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

if(!curl_exec($ch)){
    die('Error: "' . curl_error($ch) . '" - Code: ' . curl_errno($ch));
} else {
    $response = curl_exec($ch);
    $exploded = nl2br($response);   
    //echo $response."<br>";
    var_dump($exploded);
}
curl_close($ch);

The problem is I am getting the response:

string(245) ""Number","Name","Description","Type","Fixed Width Boolean","Quote Character","Delimiter Character","End of Line Sequence","Header Boolean","Column Count" "1","All Calls","All Call Data","Call","false","None",",","\r\n","true","14" "

This is two lines in the CSV, but comes out in a single string line. I tried exploding it, but it seems to have two delimiters and I tried splitting it, but it will not find the second delimiter. I want it to generate like this:

array(
"Number" => 1,
"Name" => "All Calls",
"Description" => "All Call Data",
"Type" => "Call",
"Fixed Width Boolean" => false,
"Quote Character" => "None",
"Delimiter Character" => ",",
"End of Line Sequence" => "\r\n",
"Header Boolean" => true,
"Column Count" => 14
);

The first line of the CSV is the headers and the data underneath is the data it needs to align to. Also future requests will have multiple lines of data and they need to match with the headers too. Any ideas?

So you tried exploding like this? $exploded = explode(",", $response); — VIDesignz
– VIDesignz, Commented Dec 3, 2015 at 23:15
You should show the contents of the file using code formatting. Also, no need to show output from var_dump(), just show a few lines from the file itself. — miken32
– miken32, Commented Dec 3, 2015 at 23:26
Unrelated to your problem but you are executing the http request twice with your two curl_exec calls. — Josh J
– Josh J, Commented Dec 4, 2015 at 0:12
Yes the first thought was just to explode on the "," but since there is a break in the string here: "Column Count" "1" I need to somehow get it to start a new line or array. — griff4594
– griff4594, Commented Dec 4, 2015 at 15:03

miken32 · Accepted Answer · 2019-07-24 15:49:13Z

2

If you're dealing with CSV, try using the built-in function for such. Then use array_combine to stick your headers in as keys:

$response = curl_exec($ch);
$csv_data = array_map('str_getcsv', explode("\n", $response));
$headers = array_shift($csv_data);
foreach ($csv_data as $v) {
    $data[] = array_combine($headers, $v);
}

As an example:

$response = <<< CSV
"Number","Name","Description","Type","Fixed Width Boolean","Quote Character","Delimiter Character","End of Line Sequence","Header Boolean","Column Count"
"1","All Calls","All Call Data","Call","false","None",",","\\r\\n","true","14"
CSV;
$csv_data = array_map('str_getcsv', explode("\n", $response));
$headers = array_shift($csv_data);
foreach ($csv_data as $v) {
    $data[] = array_combine($headers, $v);
}
print_r($data);

Output:

Array
(
    [0] => Array
        (
            [Number] => 1
            [Name] => All Calls
            [Description] => All Call Data
            [Type] => Call
            [Fixed Width Boolean] => false
            [Quote Character] => None
            [Delimiter Character] => ,
            [End of Line Sequence] => \r\n
            [Header Boolean] => true
            [Column Count] => 14
        )

)

edited Jul 24, 2019 at 15:49

answered Dec 3, 2015 at 23:23

miken32

42.5k16 gold badges127 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

miken32 Over a year ago

If you edit your question to include 10 lines from your file, as requested in comments, you'll get much better advice.

Josh J · Accepted Answer · 2015-12-04 16:19:15Z

1

You can also turn your csv string into a file pointer and use fgetcsv on it. Here is an example of how it works:

Josh:~$ php -a
Interactive shell

php > $data = <<<CSV
<<< > "col1","col2"
<<< > "d1",","
<<< > CSV;
php > echo $data;
"col1","col2"
"d1",","
php > $fp = fopen('data://text/plain,' . $data, 'r');
php > while (($row = fgetcsv($fp)) !== false) {
php {   var_dump($row);
php { }
array(2) {
  [0]=>
  string(4) "col1"
  [1]=>
  string(4) "col2"
}
array(2) {
  [0]=>
  string(2) "d1"
  [1]=>
  string(1) ","
}

Using your example it would be similar to the following

$response = <<<CSV
"Number","Name","Description","Type","Fixed Width Boolean","Quote Character","Delimiter Character","End of Line Sequence","Header Boolean","Column Count"
"1","All Calls","All Call Data","Call","false","None",",","\r\n","true","14"
CSV;
$fp = fopen('data://text/plain,' . $response, 'r');
$data = [];
$header = fgetcsv($fp); // first row is column headers
while (($row = fgetcsv($fp)) !== false) {
    $data[] = array_combine($header, $row);
}
print_r($data); // list of rows with keys set to column names from $header
/*
Array
(
    [0] => Array
        (
            [Number] => 1
            [Name] => All Calls
            [Description] => All Call Data
            [Type] => Call
            [Fixed Width Boolean] => false
            [Quote Character] => None
            [Delimiter Character] => ,
            [End of Line Sequence] =>

            [Header Boolean] => true
            [Column Count] => 14
        )

)
*/

answered Dec 4, 2015 at 16:19

Josh J

6,9033 gold badges28 silver badges49 bronze badges

3 Comments

griff4594 Over a year ago

I thought I had the answer but yours is perfect. Thanks a ton. I have been stuck on this for 3 days.

Josh J Over a year ago

You're welcome. I've been using the data:// + fgetcsv trick when I got sick of failing to parse them myself.

griff4594 Over a year ago

Can I get a +1 for the question? LOL? This was a learning experience. I have been coding for a long time but I hate doing curl requests because response data is always just so inconsistant.

VIDesignz · Accepted Answer · 2015-12-04 00:03:09Z

-2

Well, this is a bit "hacky" but it works....

PHP Fiddle

 $response = '"Number","Name","Description","Type","Fixed Width Boolean","Quote Character","Delimiter Character","End of Line Sequence","Header Boolean","Column Count","1","All Calls","All Call Data","Call","false","None",",","\r\n","true","14"'; 

 $response = preg_replace('/[,]/', "*", $response);
 $response = str_replace('*"*"*', '*","*', $response);

 $exploded = explode("*", $response);

 $count = count($exploded)/2;

 $newArray = [];

 for($i=0; $i<$count; ++$i){
     $newArray[$exploded[$i]] = $exploded[$i+$count];
 }

 print_r($newArray);

Which prints

 Array
 (
     ["Number"] => "1"
     ["Name"] => "All Calls"
     ["Description"] => "All Call Data"
     ["Type"] => "Call"
     ["Fixed Width Boolean"] => "false"
     ["Quote Character"] => "None"
     ["Delimiter Character"] => ","
     ["End of Line Sequence"] => "\r\n"
     ["Header Boolean"] => "true"
     ["Column Count"] => "14"
 )

edited Dec 4, 2015 at 0:03

answered Dec 3, 2015 at 23:41

VIDesignz

4,8133 gold badges30 silver badges38 bronze badges

4 Comments

Josh J Over a year ago

Do not parse csv this way. Use the built in fgetcsv or str_getcsv as needed.

VIDesignz Over a year ago

@JoshJ Don't down vote an answer that works...I can parse a csv anyway I would like really. I even said it was a bit "hacky"...geeez.

Josh J Over a year ago

That's the way the forums are supposed to work. Vote up the best practices, vote down bad ideas. Nothing personal. I'm sure you know your stuff and provide a lot of help around here.

VIDesignz Over a year ago

@JoshJ Actually, when you downvote, it should be if "This answer is not useful" but my answer is. Not elegant, but it works, therefore can be useful :)

Collectives™ on Stack Overflow

PHP curl Response string splitting

3 Answers 3

1 Comment

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related