php-pdoInsert JSON into table with PHP PDO
We have test table with data text column which we will store data in JSON format.
$json = ['some' => 'value', 'key' => 'okay'];
$st = $pdo->prepare('INSERT INTO test SET data = :json');
$st->execute([':json' => json_encode($json)]);ctrl + c$jsonexample array to save as JSON in the table | $pdo->prepareprepare given query to execute |
$st->execute(run query on the server | json_encode($json)we encode array to a |
Usage example
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
$json = ['some' => 'value', 'key' => 'okay'];
$st = $pdo->prepare('INSERT INTO test SET data = :json');
$st->execute([':json' => json_encode($json)]);
echo $pdo->lastInsertId();output
9More of Php Pdo
- Set charset in PHP PDO
- Fetch single column value with PHP PDO
- Commit transaction in PHP PDO
- How to get results after PHP PDO statement execute()
- Set execution timeout with PHP PDO
- Bind current datetime with PHP PDO
- Get last query error with PHP PDO
- Escape string with PHP PDO
- Get current database name with PHP PDO
See more codes...