Convert Recordset Untuk JSON Dan CSV

Fungsi ini mengubah rekord yang ditetapkan dan dikembalikan oleh fungsi mysql_query dalam bentuk string JSON atau ke string CSV.

function convertResult($rs, $type, $jsonmain="") {

// receive a recordset and convert it to csv

// or to json based on "type" parameter.

$jsonArray = array();

$csvString = "";

$csvcolumns = "";

$count = 0;

while($r = mysql_fetch_row($rs)) {

for($k = 0; $k < count($r); $k++) {

$jsonArray[$count][mysql_field_name($rs, $k)] = $r[$k];

$csvString.=",\"".$r[$k]."\"";

}

if (!$csvcolumns) for($k = 0; $k < count($r); $k++) $csvcolumns.=($csvcolumns?",":"").mysql_field_name($rs, $k);

$csvString.="\n";

$count++;

}

$jsondata = "{\"$jsonmain\":".json_encode($jsonArray)."}";

$csvdata = str_replace("\n,","\n",$csvcolumns."\n".$csvString);

return ($type=="csv"?$csvdata:$jsondata);

}

CONTOH:

//... connect ...

$sql = "select * from users limit 0,10";

$rs = mysql_query($sql);

$jsonString = convertResult($rs,"json","users"); // json encoded string

$csvString = convertResult($rs,"csv"); // scv output