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
- Connect to Mysql with PHP PDO
- Set charset in PHP PDO
- Get last query error with PHP PDO
- Commit transaction in PHP PDO
- Escape string with PHP PDO
- Transaction example with PHP PDO
- Connect to MariaDB using PHP PDO
- Bind current datetime with PHP PDO
- Fetch single column value with PHP PDO
- Get current database name with PHP PDO
See more codes...