How to Parse cURL JSON Responses and Access Data for Database Insertion?

How to Parse JSON and Access Results

When using cURL to send requests with a JSON response, parsing the data may seem challenging. Here's a step-by-step guide to effectively parse JSON responses and insert them into a database:

1. Parse the Response:

If the response from cURL is a JSON string, such as:

{
    "Cancelled": false,
    "MessageID": "402f481b-c420-481f-b129-7b2d8ce7cf0a",
    "Queued": false,
    "SMSError": 2,
    "SMSIncomingMessages": null,
    "Sent": false,
    "SentDateTime": "/Date(-62135578800000-0500)/"
}

Use json_decode to convert the string into an accessible 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);

2. Access the JSON Data:

The parsed JSON can be accessed as an array, allowing you to extract specific values:

echo $json['MessageID']; // Outputs "402f481b-c420-481f-b129-7b2d8ce7cf0a"
echo $json['SMSError']; // Outputs "2"

3. Insert the Data into a Database:

Once you have access to the JSON data, you can use database-specific queries to insert it into your database tables. The exact syntax and methods will vary depending on your database and framework.

References:

• [JSON Functions | PHP Manual](https://www.php.net/manual/en/book.json.php)

The above is the detailed content of How to Parse cURL JSON Responses and Access Data for Database Insertion?. For more information, please follow other related articles on the PHP Chinese website!