if ($database) { $select_query = "select * from leafs"; $result = mysql_query($select_query) or die(mysql_error()); if (!empty($result)) { if (mysql_num_rows($result) > 0) { $response["leafs"] = array(); while ($row = mysql_fetch_array($result)) { $leaf = array(); $leaf["id"] = $row["id"]; $leaf["location"] = $row["location"]; $leaf["defect_percentage"] = $row["defect_percentage"]; $leaf["time_stamp"] = $row["time_stamp"]; $leaf["salt_name"] = $row["salt_name"]; array_push($response["leafs"], $leaf); } $response["success"] = 1; echo json_encode($response); } else { $response["success"] = 0; $response["message"] = "No found"; echo json_encode($response); } } } else { echo "Unable to select database."; } } else { echo "Database is connection is failed."; } $connection->disconnect();