| Server IP : 162.0.232.25 / Your IP : 13.59.36.4 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/learn.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();
// Check if we got the field from the user
if (isset($_GET['id'], $_GET['views'])) {
$id = $_GET['id'];
$views= $_GET['views'];
$views+=1;
// Include data base connect class
include "./php/connect.php";
// Fire SQL query to update weather data by id
$result = mysqli_query($conn,"UPDATE `videos` SET `views`= $views WHERE `vid` = $id");
// Check for succesfull execution of query and no results found
if ($result) {
$response["success"] = 1;
$response["message"] = "Views were successfully updated to $views";
// Show JSON response
echo json_encode($response);
} else {
die(mysqli_error($conn));
}
} else {
// If required parameter is missing
$response["success"] = 0;
$response["message"] = "Parameter(s) are missing. Please check the request";
// Show JSON response
echo json_encode($response);
}
?>