| Server IP : 162.0.232.25 / Your IP : 18.117.74.47 Web Server : LiteSpeed System : Linux premium276.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : kwacuqig ( 988) PHP Version : 8.2.26 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/kwacuqig/skilltainment.org/ |
Upload File : |
<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");
//Creating Array for JSON response
$response = array();
// Include data base connect class
include "./connect.php";
// Fire SQL query to get all data from weather
$result = mysqli_query($conn, "SELECT * FROM `history` ") or die(mysqli_error($conn));
// Check for succesfull execution of query and no results found
if (mysqli_num_rows($result) > 0) {
$response["history"] = array();
$history = array();
// While loop to store all the returned response in variable
while ($row = mysqli_fetch_array($result)) {
$history["hid"] = $row["hid"];
$history["image"] = $row["image"];
$history["probability"] = $row["probability"];
$history["soil_type"] = $row["soil_type"];
$history["audio"] = $row["audio"];
$history["stamp"] = date('l,d M Y', $row["stamp"]);
// Push all the items
array_push($response["history"], $history);
}
// On success
$response["success"] = 1;
// Show JSON response
echo json_encode($response);
} else {
// If no data is found
$response["success"] = 0;
$response["message"] = "No data on history found";
// Show JSON response
echo json_encode($response);
}