assign_complaint.php

<?php

include 'connection.php';

$sql="SELECT ph_no,prob, priority,photo,emp_id,time_date,admin_assign_time,engine_complete_time,closing_time,T1,T2,T3,T4,engineer,sub_prob,descrp,floor,complaint_id,administrator_status ,T4 FROM it";
$db_data=array();

$result=$connect->query($sql);
if ($result->num_rows>0)
{
    while($row=$result->fetch_assoc())
    {
        $db_data[]=$row;

    }

    echo json_encode($db_data);
}

else{

    echo('error');
}

?>