retrieving data as json

json.php

<?php
header('Content-Type: application/json');


$db = new PDO("mysql:unix_socket=/opt/local/var/run/mariadb/mysqld.sock;dbname=table", "", "");


$result = array('values' => array());

if(isset($_POST["value"]))
{
	$val = $_POST["value"];
	$q = $db->prepare("select * from table where idx=? limit 1");
	$q->bindValue(1, intval(substr($val, 0, 8)), PDO::PARAM_INT);
	$q->setFetchMode(PDO::FETCH_ASSOC);

	if($q->execute())
	if($row = $q->fetch())
		$result['values'][] = $row;
}

echo json_encode($result);

?>