Getting value of php that is json_encode

Question

Hello im trying to get the value of an element that is json_encoded.

  public function getDescription($noArticle){
  $stmt = $this->prepare("SELECT description FROM Inventaire WHERE noArticle = '{$noArticle}' ");
  $stmt->execute();
  $result = $stmt->fetchAll();
  return json_encode($result);

This returns me - > [{"description":"BMW M3"}] that is json_encoded.

I want to get only the "BMW M3"" part

I tried :

$allo = $allo->getDescription(1);
$test = json_decode($allo);
echo $test->{"description"};

not working if anyone could help me. Thanks

You have __array of objects__. – u_mulder May 15 '20 at 08:17 — u_mulder, May 15 '20 at 08:17
What about `echo $test[0]->description;`? – A l w a y s S u n n y May 15 '20 at 08:18 — A l w a y s S u n n y, May 15 '20 at 08:18

Buddy Christ · Accepted Answer · 2020-05-15T08:19:28.203

1

Your json is an array of objects, you should use:

$allo = '[{"description":"BMW M3"}]';
$test = json_decode($allo);
echo $test[0]->description;

edited May 15 '20 at 08:19

answered May 15 '20 at 08:18

Buddy Christ

1,364
8
22

score 0 · Answer 2 · answered May 15 '20 at 08:19

0

[{"description":"BMW M3"}] is an object within an array. So this should work:

echo $test[0]->description;

answered May 15 '20 at 08:19

Ben Hillier

2,126
1
10
15

@Anasde That's nice to hear. Could you then follow protocol and upvote the correct answers? Since two people provided a correct answer you should also mark one of them as accepted :-) – Ben Hillier May 15 '20 at 09:30

score 0 · Answer 3 · answered May 15 '20 at 10:03

0

Since your variable $allo is an array of one element, you should get this first element then get your object like this:

$test[0]->description

answered May 15 '20 at 10:03

solikhay

26
3

Getting value of php that is json_encode

3 Answers3