PHP curl API request works. Using explode to make array, not giving key value pairs desired

Question

Like the title says I am getting the API response just fine. I've cleaned the response data up several different ways. When attempting to use explode, I cannot get it to assign the string as the key and value pairs needed. I'll post some of the data below. If I need to delimit the data differently for ease, I will. Tried dozens of examples over the last fourteen hours. Please help!

# Find the part of the string after the description
$mysearchstring = 'color';

# Minus one keeps the quote mark in front of color
$position = (stripos($response, $mysearchstring)-1);

    
#This selects the text after the description to the end of the file
$after_descrip = substr($response, $position);

echo "</br>__________Show the data after the description________________</br>";
echo $after_descrip;


echo "</br>__________Show the cleaned data________________</br>";
$cleaned = $after_descrip;
$cleaned1 = str_replace('{', "", $cleaned);
$cleaned2 = str_replace('}', "", $cleaned1);
$cleaned3 = str_replace('[', "", $cleaned2);
$cleaned4 = str_replace(']', "", $cleaned3);
$cleaned5 = str_replace('https://', "", $cleaned4);
$cleaned6 = str_replace('"', "", $cleaned5);

echo $cleaned6;

    
echo "</br>__________Explode is next________________</br>";

#Turn the string into an array but not the array I want 
$last_half = explode(':', $cleaned6);
print_r($last_half);

}

The cleaned data looks like this:

color:#3C3C3D,iconType:vector,iconUrl:cdn.coinranking.com/rk4RKHOuW/eth.svg,websiteUrl:www.ethereum.org,socials:name:ethereum,url:twitter.com/ethereum,type:twitter,name:ethereum,url:www.reddit.com/r/ethereum/

The resulting array looks like this:

Array ( [0] => color [1] => #3C3C3D,iconType [2] => vector,iconUrl [3] => cdn.coinranking.com/rk4RKHOuW/eth.svg,websiteUrl [4] => www.ethereum.org,socials [5] => name [6] => ethereum,url [7] => twitter.com/ethereum,type [8] => twitter,name [9] => ethereum,url [10] => www.reddit.com/r/ethereum/,type [11] => reddit,name [12] => ethtrader,url [13] =>

Color should be the first key, #3C3C3D should be the first value. The rest of the data should follow that format.

What do you think is the best way to go? Thank you.

-Rusty

Mike Foxtech · Accepted Answer · 2020-11-05 21:15:11Z

1

You should use json_decode function. https://www.php.net/manual/en/function.json-decode.php

This function can decode json to array and object

answered Nov 5, 2020 at 21:15

Mike Foxtech

1,6511 gold badge8 silver badges7 bronze badges

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

Comments

Alex Alvarado · Accepted Answer · 2020-11-05 21:32:47Z

0

Just one more step...

$last_half = explode(',', $cleaned6);
foreach($last_half as $item){
    list($k, $v) = explode(':', $item);
    $result[$k] = $v;    
}
print_r($result);

edited Nov 5, 2020 at 21:32

answered Nov 5, 2020 at 21:17

Alex Alvarado

1313 bronze badges

1 Comment

Rusty Mullin Over a year ago

Hey Alex, Thank you very much! I had even tried using that example, but just was not getting it right. This works perfect. You rock!

intxcc · Accepted Answer · 2020-11-05 21:17:10Z

0

So you want an array where "color" -> "#3C3C3D" ?

Thats the way:

$last_half = explode(',', $last_half);
$new_array = [];
foreach ($last_half as $item) {
    [$key, $value] = explode(':', $item, 2);
    $new_array[$key] = $value;
}

Now new array should be like you want :)

But wait, just noticed that initially you have json, so you should always go with native functions and use that to parse this string. (as the other answer says)

Best, intxcc

answered Nov 5, 2020 at 21:17

intxcc

597 bronze badges

Collectives™ on Stack Overflow

PHP curl API request works. Using explode to make array, not giving key value pairs desired

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related