cardetails.php

<?php

include("dbconnect.php");

$query="select car.carid,name,cartype,status,images from car left join images on car.carid=images.carid and
 images=(select images from images where carid=car.carid limit 1) order by uploadedtime desc"; //to select cars along with its status

if($result = $conn->query($query))
{   
    $arr = array();

    while($row = $result->fetch_array(MYSQLI_ASSOC))
    {

        if($row["cartype"]==='new')
        {
        $discountquery = "select discount from newcar where newcarid=".$row['carid'];

        if($ex= mysqli_query($conn, $discountquery)) 
        {
            $discountresult= mysqli_fetch_assoc($ex);
    
            if($discountresult["discount"]!==null)
            {
                $row["discount"]=$discountresult["discount"];
            }
            else
            {
                $row["discount"]="0";
            }
            
        }
        }

        else if($row["cartype"]==='resale')
        {
        $discountquery = "select discount from preownedcar where preownedcarid=".$row['carid'];

        
        if($ex= mysqli_query($conn, $discountquery)) 
        {
            $discountresult= mysqli_fetch_assoc($ex);
    
            if($discountresult["discount"]!==null)
            {
                $row["discount"]=$discountresult["discount"];
            }
            else
            {
                $row["discount"]="0";
            }
            
        }
        }

        else
        {
             $row["discount"]="0";
        }




        if($row["images"]===null)
        {
            $row["images"]="dummy.png";
        }
        //setting link 
        if($row["cartype"]==='new')
        {
            $row["link"]="newcar.php?carid=".$row["carid"];
        }

        else if($row["cartype"]==='resale')
        {
            $row["link"]="resalecar.php?carid=".$row["carid"];
        }

        else
        {
            $row["link"]="rentalcar.php?carid=".$row["carid"];
        }


        $featurequery = "select features from features where carid=".$row["carid"]." limit 3";
        $featureresult = $conn->query($featurequery);
        $featuresarr= array();

        if($featureresult)
        {
        while($features = $featureresult->fetch_array(MYSQLI_ASSOC))
        {
               $featuresarr[] = $features["features"];   
        }

        $row["features"] =  $featuresarr;
        }
    
        $arr[] = $row;
    }
    
    echo json_encode($arr);
}

?>