How to Parse JSON Responses and Insert Data into a Database Using PHP?

Parsing JSON Responses in PHP

When working with web APIs, JSON (JavaScript Object Notation) is often used as the format for data exchange. PHP provides tools for parsing JSON responses, enabling you to access and manipulate the data effectively.

Question:

How can I parse a JSON response and insert the extracted data into a database?

Answer:

To parse a JSON response in PHP, you can use the json_decode function. For example:

$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);

$json = json_decode($result, true);

The json_decode function will convert the JSON string into a PHP object or array. You can then access the individual properties or elements of the parsed data:

$messageId = $json['MessageID'];
$smsError = $json['SMSError'];

To insert the data into a database, you would typically use a database library such as PHP Data Objects (PDO) or MySQLi. The specific syntax will vary depending on the database you are using. For example, using PDO:

$pdo = new PDO('mysql:host=localhost;dbname=database', 'username', 'password');

$stmt = $pdo->prepare('INSERT INTO messages (message_id, sms_error) VALUES (?, ?)');
$stmt->execute([$messageId, $smsError]);

Note:

• Make sure that the JSON response is valid.
• The json_decode function can return either an object or an array. Use true as the second parameter to specify that you want an array.
• For more information on parsing JSON in PHP, refer to the PHP Manual for json_decode: https://www.php.net/manual/en/function.json-decode.php

The above is the detailed content of How to Parse JSON Responses and Insert Data into a Database Using PHP?. For more information, please follow other related articles on the PHP Chinese website!