CH_JSON TEST

tes.php

<?php 

try {
	$db = new PDO("sqlsrv:server=localhost;Database=rec-booklife","zap","123");
	$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
} catch( PDOException $e ) {
	die( "Error connecting to SQL Server:".$e );
}

$stmt = $db->prepare("select top 100 oid,cname from book");
$stmt->execute();

$result = $stmt->fetchAll(PDO::FETCH_CLASS);

echo json_encode($result);

?>