How to parse JSON and access results

Question

I am using CURL to send a request  The response dataType is json  How can I parse this data and insert it into the database    lt  php   url    http   sms2 cdyne com sms svc SimpleSMSsendWithPostback         PhoneNumber 18887477474 amp Message test amp LicenseKey LICENSEKEY     cURL   curl init     curl setopt  cURL  CURLOPT URL   url   curl setopt  cURL  CURLOPT HTTPGET  true    curl setopt  cURL  CURLOPT HTTPHEADER  array       Content-Type  application json        Accept  application json        result   curl exec  cURL    curl close  cURL      print r  result      gt    JSON Output          Cancelled   false       MessageID    402f481b-c420-481f-b129-7b2d8ce7cf0a        Queued   false       SMSError   2       SMSIncomingMessages   null       Sent   false       SentDateTime     Date -62135578800000-0500

User · Answer

Try    result   curl exec  cURL    result   json decode  result true     Now you can access MessageID from  result  MessageID     As for the database  it s simply using a query like so   INSERT INTO  tableName   Cancelled   Queued   SMSError   SMSIncommingMessage   Sent   SentDateTime   VALUES                         Prepared

User · Answer

If your  result variable is a string json like  you must use json decode function to parse it as an object or array    result      Cancelled  false  MessageID   402f481b-c420-481f-b129-7b2d8ce7cf0a   Queued  false  SMSError  2  SMSIncomingMessages  null  Sent  false  SentDateTime     Date -62135578800000-0500         json   json decode  result  true   print r  json     OUTPUT  Array        Cancelled    gt        MessageID    gt  402f481b-c420-481f-b129-7b2d8ce7cf0a      Queued    gt        SMSError    gt  2      SMSIncomingMessages    gt        Sent    gt        SentDateTime    gt   Date -62135578800000-0500       Now you can work with  json variable as an array   echo  json  MessageID    echo  json  SMSError       other stuff     References    json decode - PHP Manual

User · Answer

The main problem with your example code is that the  result variable you use to store the output of curl exec   does not contain the body of the HTTP response - it contains the value true  If you try to print r   that  it will just say  quot 1 quot   The curl exec   reference explains   Return Values Returns TRUE on success or FALSE on failure  However  if the CURLOPT RETURNTRANSFER option is set  it will return the result on success  FALSE on failure   So if you want to get the HTTP response body in your  result variable  you must first run curl setopt  cURL  CURLOPT RETURNTRANSFER  true    After that  you can call json decode   on  result  as other answers have noted  On a general note - the curl library for PHP is useful and has a lot of features to handle the minutia of HTTP protocol  and others   but if all you want is to GET some resource or even POST to some URL  and read the response - then file get contents   is all you ll ever need  it is much simpler to use and have much less surprising behavior to worry about

[php] How to parse JSON and access results

Examples related to php

Examples related to json

Examples related to curl