0){ $ref_no='DE'.str_pad($set_main['id'], 4, "0", STR_PAD_LEFT); $url=''.$ref_no.''; $data[] = array('sl_no' => ++$i,'order_no'=>$url, 'order_date' => $set_main['order_date_time'],'dealer'=>$set_deal['name'],'contact'=>$set_deal['phone'],'items'=>$check_sub, 'id'=>$set_main['id'], 'city'=>$set_deal['city']); } } mysqli_close($conn); if(!empty($data)) { echo json_encode(array( "aaData"=>$data)); } else { echo json_encode(array('aaData'=>[])); } ?>