PHP : select (return JSON)

Esempio select con ritorno di tipo JSON

<?php

/*
	select.php
	return OK<record>nr.record<record>DataResult
*/

require_once('call_class.php');
$call = new call_class();
/*
	result : JSON
*/
echo "<br /><br />Result : JSON : <br />";
$call->cmd = "
<record>
	<Stmt>select</Stmt>
	<Field>col_idtable, col_user, col_idkey, col_key, col_value,col_file</Field>
	<Where>col_user=?</Where>
	<ParamW>User_1</ParamW>
	<Order>col_user, col_key</Order>
	<OtherCmd>limit 100</OtherCmd>
	<ReturnSelect>JSON</ReturnSelect>
	<QueryType>TABLE</QueryType>
	<ReturnFile>FILEURL</ReturnFile>
</record>
";
$Res = $call->call_curl();
if ( substr($Res, 0, 4) != "#ERR" ) {
	echo $Res;
}else{
	echo "error in Select_json...".$Res;
}
return;

?>

Ritorna : 
[{"col_idtable":2,"col_user":"User_1","col_idkey":1,"col_key":"birthday","col_value":"1966-04-30","col_file":""},{"col_idtable":3,"col_user":"User_1","col_idkey":1,"col_key":"city","col_value":"New York","col_file":""},{"col_idtable":1,"col_user":"User_1","col_idkey":1,"col_key":"name","col_value":"Tom","col_file":""},{"col_idtable":5,"col_user":"User_1","col_idkey":1,"col_key":"photo","col_value":"photo_tom.jpg","col_file":"http:\/\/localhost\/api1.dataindb\/users\/user_3\/files\/P2_5_photo_tom.jpg"},{"col_idtable":4,"col_user":"User_1","col_idkey":1,"col_key":"text_file","col_value":"sample.txt","col_file":"http:\/\/localhost\/api1.dataindb\/users\/user_3\/files\/P2_4_sample.txt"}]

PHP : select (return JSON)

Tutorial