| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566 |
- <?php
- include_once "../../include/DB.php";
- $AssetID="";
- if (isset($_POST["AssetID"]) && !empty($_POST["AssetID"])) {
- $AssetID=$_POST["AssetID"];
- }
- $assetsql = "SELECT *,
- asset.CreatedAt AS AssetCreatedAt,
- asset.UpdatedAt AS AssetUpdatedAt,
- assetcategory.CreatedAt AS AssetCategoryCreatedAt,
- assetcategory.UpdatedAt AS AssetCategoryUpdatedAt
- FROM asset asset
- JOIN assetcategory assetcategory ON assetcategory.AssetCategoryID =asset.AssetCategoryID
- WHERE asset.AssetID='$AssetID'";
- $assetresult = $conn->query($assetsql);
- $assetlistArray= [];
- if ($assetresult!== false && $assetresult->num_rows > 0) {
- while($sassetrow = $assetresult->fetch_assoc()) {
- $assetvalue = array(
- "AssetID"=>$sassetrow["AssetID"],
- "AssetName"=>$sassetrow["AssetName"],
- "AssetCategoryID"=>(int)$sassetrow["AssetCategoryID"],
- "AssetCategory"=>array(
- "AssetCategoryID"=>(int)$sassetrow["AssetCategoryID"],
- "AssetCategoryTitle"=>$sassetrow["AssetCategoryTitle"],
- "AssetCategoryCreatedAt"=>$sassetrow["AssetCategoryCreatedAt"],
- "AssetCategoryUpdatedAt"=>$sassetrow["AssetCategoryUpdatedAt"],
- ),
- "IsInServiceCenter"=>(int)$sassetrow["IsInServiceCenter"],
- "AssetCreatedAt"=>$sassetrow["AssetCreatedAt"],
- "AssetUpdatedAt"=>$sassetrow["AssetUpdatedAt"],
- );
- $assetlistArray[]= $assetvalue;
- }
- $count = count($assetlistArray);
- if($count==1){
- // Use json_encode() function
- $json = json_encode($assetlistArray[0]);
- }else {
- // Use json_encode() function
- $json = json_encode($assetlistArray);
- }
- }else {
- http_response_code(404);
- $errorMesage= $conn->error;
- if ($errorMesage=="") {
- $errorMesage = "AssetID not available";
- if ($AssetID=="") {
- $errorMesage = "AssetID is empty";
- }
- }
- // Declare an array with error message
- $value = array(
- "Message"=>"Failed to get data",
- "Error"=>$errorMesage
- );
- // Use json_encode() function
- $json = json_encode($value);
- }
- // Display the output
- echo($json);
- $conn->close();
|