PHP와 MySQL은 JSON 데이터를 어떻게 처리합니까?

<?php
// 连接到MySQL数据库
$connection = mysqli_connect('localhost', 'username', 'password', 'database');

// 查询用户表中的所有数据
$query = "SELECT * FROM users";
$result = mysqli_query($connection, $query);

// 创建一个数组来存储查询结果
$data = [];
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = $row;
}

// 将数据转换为JSON格式
$json = json_encode($data);

// 将JSON数据输出
header('Content-Type: application/json');
echo $json;
?>

<?php
// 连接到MySQL数据库
$connection = mysqli_connect('localhost', 'username', 'password', 'database');

// 从JSON文件读取数据
$json = file_get_contents('users.json');

// 将JSON数据解码为PHP数组
$data = json_decode($json, true);

// 将数据插入到用户表中
foreach ($data as $row) {
    $name = $row["name"];
    $age = $row["age"];
    $email = $row["email"];
    
    $query = "INSERT INTO users (name, age, email) VALUES ('$name', '$age', '$email')";
    mysqli_query($connection, $query);
}
?>

<?php
// 连接到MySQL数据库
$connection = mysqli_connect('localhost', 'username', 'password', 'database');

// 查询包含特定关键字的产品
$keyword = 'apple';

$query = "SELECT * FROM products WHERE json_field LIKE '%$keyword%'";
$result = mysqli_query($connection, $query);

// 将查询结果转换为数组
$data = [];
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = $row;
}

// 将数组转换为JSON格式，并输出数据
$json = json_encode($data);

header('Content-Type: application/json');
echo $json;
?>

<?php
// 连接到MySQL数据库
$connection = mysqli_connect('localhost', 'username', 'password', 'database');

// 更新JSON字段中的某个属性
$query = "UPDATE products SET json_field = JSON_SET(json_field, '$.price', '19.99') WHERE id = 1";
mysqli_query($connection, $query);
?>