Multidimensional array fetch using curl shows invalid argument in foreach

Question

I have an array like this which I fetch using file_get_content and here is other side url (http://sample.com/change.php)code from where I fetch array.

$a=array();
$a=Db::getInstance()->ExecuteS("SELECT *
FROM tablename
LIMIT 0 , 2
;");

$a=(array)$a;
print_r($a);

Then i use

$result = file_get_contents('http://sample.com/change.php');

That is the output of $result:

Array
(
    [0] => Array
        (
            [id_stock_available] => 1
            [id_product] => 1
            [id_product_attribute] => 0
            [id_shop] => 1
            [id_shop_group] => 0
            [quantity] => 3
            [depends_on_stock] => 0
            [out_of_stock] => 2
        )

    [1] => Array
        (
            [id_stock_available] => 2
            [id_product] => 2
            [id_product_attribute] => 0
            [id_shop] => 1
            [id_shop_group] => 0
            [quantity] => 1
            [depends_on_stock] => 0
            [out_of_stock] => 2
        )

)

When I apply foreach for $result:

foreach ($result as $value) {
    var_dump($value);
    //var_dump($value['installed'];
}

it shows me Invalid argument supplied for foreach().

It shows me output string(614) "Array ( [0] => Array ( [id_stock_available] => 1 [id_product] => 1 [id_product_attribute] => 0 [id_shop] => 1 [id_shop_group] => 0 [quantity] => 3 [depends_on_stock] => 0 [out_of_stock] => 2 ) [1] => Array ( [id_stock_available] => 2 [id_product] => 2 [id_product_attribute] => 0 [id_shop] => 1 [id_shop_group] => 0 [quantity] => 1 [depends_on_stock] => 0 [out_of_stock] => 2 ) ) " — user3450650
– user3450650, Commented Apr 29, 2014 at 8:44
have your tried this? $result = (array) $result; then do a var_dump again — Gian Carlo
– Gian Carlo, Commented Apr 29, 2014 at 8:56
if you look carefully, $result is actually a string. it says on your var_dump — user1978142
– user1978142, Commented Apr 29, 2014 at 9:01
@GianCarlo it shows me array(1) { [0]=> string(614) "Array ( [0] => Array ( [id_stock_available] => 1 [id_product] => 1 [id_product_attribute] => 0 [id_shop] => 1 [id_shop_group] => 0 [quantity] => 3 [depends_on_stock] => 0 [out_of_stock] => 2 ) [1] => Array ( [id_stock_available] => 2 [id_product] => 2 [id_product_attribute] => 0 [id_shop] => 1 [id_shop_group] => 0 [quantity] => 1 [depends_on_stock] => 0 [out_of_stock] => 2 ) ) " } now foreach invaid argument not showing but it is also showing correct array in foreach loop like am using foreach ($result as $csv) {} — user3450650
– user3450650, Commented Apr 29, 2014 at 9:10

user1978142 · Accepted Answer · 2014-04-29 09:39:00Z

1

On your php file you must change it to this:

// your query here
$a = Db::getInstance()->ExecuteS("SELECT * FROM tablename LIMIT 0 , 2;");
// then output it as JSON
header('Content-Type: application/json');
echo json_encode($a);

Then to get it on the other php:

$result = file_get_contents('http://sample.com/change.php');
$values = json_decode($result, true);

The values should be on $values as an array

answered Apr 29, 2014 at 9:39

user1978142

7,9683 gold badges19 silver badges20 bronze badges

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

2 Comments

user1978142 Over a year ago

Your welcome and no problem, so a tip: next time try to add and post relevant code, because this might be very helpful in solving the problem.

Leri Over a year ago

@user3450650 Also read-up on why singleton is bad practice: stackoverflow.com/questions/4595964/…

xdazz · Accepted Answer · 2014-04-29 09:34:13Z

0

file_get_contents returns the content of response (return false on fail), which is a string, but not an array.

You have to parse the result of print_r back to array, which is not a good idea.

So use some encode/decode strategy to do this:

echo json_encode($a);

and

$result = file_get_contents('http://sample.com/change.php');
$result = json_decode($result, true);

answered Apr 29, 2014 at 9:34

xdazz

161k38 gold badges255 silver badges278 bronze badges

Comments

Leri · Accepted Answer · 2014-04-29 09:45:59Z

0

print_r is not a proper way for serializing data for Web Services because serializing data means that it should be deserialized on the receiving end. As you know there's not a function that deserializes data outputted by print_r i.e. takes a string created by print_r and returning array that was passed in. Also from the docs:

print_r — Prints human-readable information about a variable

Human-readable doesn't mean computer-readable as well.

You have 2 alternatives:

php's serialize/unserialize:

// web service.
$a=(array)$a;
serialize($a);

// receiving end.
$result = file_get_contents('http://sample.com/change.php');
var_dump(unserialize($result);

json_encode/json_decode:

// web service.
$a=(array)$a;
json_encode($a);

// receiving end.
$result = file_get_contents('http://sample.com/change.php');
var_dump(json_decode($result);

I recommend using json because almost every platform can be client of your web service. While with native serializing, consumer of your WS will be client written in php also.

edited Apr 29, 2014 at 9:45

answered Apr 29, 2014 at 9:35

Leri

12.6k7 gold badges46 silver badges60 bronze badges

1 Comment

Leri Over a year ago

@user3450650 You're welcome. You need to mark answer which helped you with a tick on the left hand-side of answer.

Collectives™ on Stack Overflow

Multidimensional array fetch using curl shows invalid argument in foreach

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related