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
– u_mulder

2020-05-15 08:17:16 +00:00
Commented May 15, 2020 at 8:17 — u_mulder
– u_mulder, Commented May 15, 2020 at 8:17
What about echo $test[0]->description;?

A l w a y s S u n n y
– A l w a y s S u n n y

2020-05-15 08:18:06 +00:00
Commented May 15, 2020 at 8:18 — A l w a y s S u n n y
– A l w a y s S u n n y, Commented May 15, 2020 at 8:18

Buddy Christ · Accepted Answer · 2020-05-15 08:19:28Z

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, 2020 at 8:19

answered May 15, 2020 at 8:18

Buddy Christ

1,39610 silver badges24 bronze badges

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

Comments

Ben Hillier · Accepted Answer · 2020-05-15 08:19:00Z

0

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

echo $test[0]->description;

answered May 15, 2020 at 8:19

Ben Hillier

2,1041 gold badge11 silver badges15 bronze badges

1 Comment

Ben Hillier Over a year ago

@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 :-)

solikhay · Accepted Answer · 2020-05-15 10:03:57Z

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, 2020 at 10:03

solikhay

263 bronze badges

Collectives™ on Stack Overflow

Getting value of php that is json_encode

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