Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$query = "SELECT ThumbNailPhoto FROM Product";
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$columns = [];
for ($i = 0; $i < $stmt->columnCount(); $i++) {
$col = $stmt->getColumnMeta($i);
$columns[] = [
'header'=>$col['name'],
'pdo_type'=>$col['pdo_type']
];
}
var_export($columns);
json_encode($rows/*, JSON_PRETTY_PRINT */);