Esempio select con ritorno di tipo CSV
<?php
/*
select.php
return OK<record>nr.record<record>DataResult
*/
require_once('call_class.php');
$call = new call_class();
/*
result : CSV
*/
echo "<br /><br />Result : CSV : <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>CSV</ReturnSelect>
<QueryType>TABLE</QueryType>
<ReturnFile>FILEURL</ReturnFile>
</record>
";
$Res = $call->call_curl();
if ( substr($Res, 0, 4) != "#ERR" ) {
echo $Res;
file_put_contents("x.csv", $Res);
}else{
echo "error in Select_csv...".$Res;
}
return;
?>
Ritorna :
"col_idtable","col_user","col_idkey","col_key","col_value","col_file"
"2","User_1","1","birthday","1966-04-30",""
"3","User_1","1","city","New York",""
"1","User_1","1","name","Tom",""
"5","User_1","1","photo","photo_tom.jpg","http://localhost/api1.dataindb/users/user_3/files/P2_5_photo_tom.jpg"
"4","User_1","1","text_file","sample.txt","http://localhost/api1.dataindb/users/user_3/files/P2_4_sample.txt"