How Can I Parse JSON Data from cURL and Insert It into a Database?

JSON Data Parsing and Database Insertion

Utilizing curl to send HTTP requests and receive JSON responses often poses the challenge of parsing and interpreting the JSON data effectively. This article addresses this challenge by guiding you through the process of parsing JSON results and storing them within a database.

Parsing JSON Data

To parse the JSON response, you can employ the json_decode function, which converts the JSON string into a PHP array or object. By specifying the true argument, the function will return an associative array representation of the JSON data:

$json = json_decode($result, true);

This will create an array named $json that can be accessed using standard PHP array syntax:

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

Inserting JSON Data into a Database

Once the JSON data has been parsed, you can insert it into a database using a database library such as PDO or MySQLi. The specific approach will depend on your database and server configuration. Here's an example using PDO:

$pdo = new PDO('mysql:host=localhost;dbname=my_database', 'username', 'password');
$query = $pdo->prepare('INSERT INTO my_table (message_id, sm_error) VALUES (:message_id, :sm_error)');
$query->bindParam(':message_id', $json['MessageID']);
$query->bindParam(':sm_error', $json['SMSError']);
$query->execute();

By utilizing these techniques, you can parse JSON data and store it within a database, enabling you to seamlessly integrate external data into your application.

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