<?php include '../includes/dbutil.php'; //extract($_POST); $check_count = get_row_count("tbl_state"); if ($check_count > 0) { $states = select_columns_rows_by_condition("tbl_state t", "t.id,t.state_name", "order by t.id asc"); foreach ($states as $st_info1) { //$product_info=$product_info1; $results[] = $st_info1; } $results['status'] = "success"; echo json_encode($results); } else { echo json_encode(array("status" => "failed")); }
$sq=mysql_query("select * from driver_reg where id='$driver_id'"); $ar=mysql_fetch_array($sq); $driver_name=$ar['driver_name']; $driver_mobile=$ar['mobile']; $sql1=mysql_query("select * from trip_reg where driver_id='$driver_id' and status='0' order by id desc"); //if(mysql_num_rows($sql1)==0){ echo "<div class='admin_faile'>Presently No Cabs found.</div>"; } $arr=mysql_fetch_array($sql1); $trip_id=$arr['id']; $cab_id=$arr['cab_id']; $sql2=mysql_query("select * from cab_reg where id='$cab_id'"); $arr1=mysql_fetch_array($sql2); $cab_type=$arr1['cartype']; $cab_no=$arr1['vehicle_reg'];*/ $count = get_row_count_by_condition("trip_reg", "where status <> 0"); if ($count > 0) { $arr = select_columns_rows_by_condition("trip_reg t INNER JOIN driver_reg d INNER JOIN cab_reg c", "t.*,d.driver_name,d.mobile as driver_mobile, c.vehicle_reg", "on t.cab_id=c.id and t.driver_id=d.id where t.status <> 0"); foreach ($arr as $row) { if ($row['status'] == 0) { $status_loc = "Pending"; } else { if ($row['status'] == 1) { $status_loc = "Cab assigned"; } else { if ($row['status'] == 2) { $status_loc = "In travel"; } else { if ($row['status'] == 3) { $status_loc = "completed"; } else { if ($row['status'] == 4) { $status_loc = "In transit";
<?php include '../includes/dbutil.php'; include 'includes/validation.php'; $parameters = array("state_id"); $is_parameter_available = is_post_parameters_exists($parameters); if ($is_parameter_available == 0) { extract($_POST); $check_count = get_row_count_by_condition("tbl_city", "where state_id='" . $state_id . "' "); if ($check_count > 0) { $cities = select_columns_rows_by_condition("tbl_city t", "t.id,t.city_name", "where t.state_id='" . $state_id . "'"); foreach ($cities as $ct_info1) { //$product_info=$product_info1; $results[] = $ct_info1; } $results['status'] = "success"; echo json_encode($results); } else { echo json_encode(array("status" => "There is no data")); } } else { echo json_encode(array("status" => "failed")); } ?>