在灯塔php中插入数据类型JSON

<?php
// 创建数据库连接
$db = new \Laravel\Lumen\Database\DatabaseManager([
    'driver' => 'mysql',
    'host' => 'localhost',
    'database' => 'your_database',
    'username' => 'your_username',
    'password' => 'your_password',
    'charset' => 'utf8',
    'collation' => 'utf8_unicode_ci',
    'prefix' => '',
]);

// 准备插入数据
$data = [
    'name' => 'John Doe',
    'email' => 'john@example.com',
    'address' => [
        'street' => '123 Main St',
        'city' => 'New York',
        'state' => 'NY',
        'zip' => '10001'
    ]
];

// 转换为JSON字符串
$jsonData = json_encode($data);

// 执行插入操作
$db->table('users')->insert(['data' => $jsonData]);

echo "Data inserted successfully!";
?>