How can I parse php using sql SUM in JSON in Android?
How can I parse php using sql SUM in Android
here is my PHP code
<?php
mysql_connect("localhost","root","");
mysql_select_db("mydatabase");
$query = "SELECT SUM(OrderPrice) as total FROM tbl_user";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
$new_arr[] = $row{'total'};
}
echo json_encode($new_arr);
?>
how can I show the total sum on a textView?
No comments:
Post a Comment