01.<?php
02. $objConnect = mysqli_connect("localhost","root","1234","testdb");
03.
04. $objDB = mysqli_select_db($objConnect,"testdb") or die (mysqli_error());
05.
06. $strSQL = "SELECT * FROM customer WHERE 1 ORDER BY CustomerID DESC ";
07. $objQuery = mysqli_query($objConnect,$strSQL);
08. $intNumField = mysqli_num_fields($objQuery);
09. $resultArray = array();
10. while($obResult = mysqli_fetch_array($objQuery))
11. {
12. $arrCol = array();
13. for($i=0;$i<$intNumField;$i++)
14. {
15. $arrCol[mysqli_fetch_field_direct($objQuery,$i)] = $obResult[$i];
16. }
17. array_push($resultArray,$arrCol);
18. }
19.
20. mysqli_close($objConnect);
21.
22. echo json_encode($resultArray);
23.?>
