change_asset.php 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. <?php
  2. include_once "../../include/DB.php";
  3. $AssetID="";
  4. $IsInServiceCenter=0;
  5. if (isset($_POST["AssetID"]) && !empty($_POST["AssetID"])) {
  6. $AssetID=$_POST["AssetID"];
  7. }
  8. if (isset($_POST["IsInServiceCenter"]) && !empty($_POST["IsInServiceCenter"])) {
  9. $IsInServiceCenter=$_POST["IsInServiceCenter"];
  10. }
  11. $AssetUpdateSql = "UPDATE asset SET IsInServiceCenter='$IsInServiceCenter' WHERE AssetID='$AssetID'";
  12. $AssetUpdateResult = $conn->query($AssetUpdateSql);
  13. if ($AssetUpdateResult === TRUE) {
  14. $value = array(
  15. "AssetID"=>$AssetID,
  16. "IsInServiceCenter"=>(int)$IsInServiceCenter,
  17. "Message"=>"Asset data saved successfully",
  18. );
  19. // Use json_encode() function
  20. $json = json_encode($value);
  21. }else {
  22. http_response_code(404);
  23. $errorMesage= $conn->error;
  24. // Declare an array with error message
  25. $value = array(
  26. "Message"=>"Something went wrong",
  27. "Error"=>$errorMesage
  28. );
  29. // Use json_encode() function
  30. $json = json_encode($value);
  31. }
  32. // Display the output
  33. echo ($json);
  34. $conn->close();