php-pdoGet JSON from table with PHP PDO
We have test table with data text column which stores data in JSON format.
$st = $pdo->prepare('SELECT data FROM test WHERE id = 8');
$st->execute();
$json = json_decode($st->fetchColumn(), 1);ctrl + c$pdo->prepareprepare given query to execute | $st->execute(run query on the server |
json_decode(converts JSON string to associative array | $st->fetchColumn()return single column ( |
$json =will store resulting JSON array | |
Usage example
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
$st = $pdo->prepare('SELECT data FROM test WHERE id = 8');
$st->execute();
$json = json_decode($st->fetchColumn(), 1);
print_r($json);output
Array
(
[some] => value
[key] => okay
)
More of Php Pdo
- How to install PHP PDO for Mysql in Ubuntu 22.04
- Bind current datetime with PHP PDO
- Get current database name with PHP PDO
- Fetch single column value with PHP PDO
- Set execution timeout with PHP PDO
- Connect to MariaDB using PHP PDO
- How to get results after PHP PDO statement execute()
- How to bind table name in PHP PDO
- Connect to Mysql with PHP PDO
- Escape string with PHP PDO
See more codes...