php code example 2
php code example 2
bengi
<?php
// Assuming you have already established a connection to your MySQL database
// JSON data
$jsonData = '{
"users": [
{
"id": 1,
"name": "John Doe",
"email": "johndoe@example.com"
},
{
"id": 2,
"name": "Jane Smith",
"email": "janesmith@example.com"
}
]
}';
// Decode the JSON data into an associative array
$data = json_decode($jsonData, true);
// Access the "users" array within the JSON data
$users = $data['users'];
// Loop through each user and insert into the database
foreach ($users as $user) {
$id = $user['id'];
$name = $user['name'];
$email = $user['email'];
// Prepare the SQL statement
$stmt = $pdo->prepare("INSERT INTO users (id, name, email) VALUES (?, ?, ?)");
// Bind the parameters
$stmt->bindParam(1, $id);
$stmt->bindParam(2, $name);
$stmt->bindParam(3, $email);
// Execute the statement
$stmt->execute();
}
// Close the database connection
$pdo = null;
?>
