bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<?php
    require_once 'lib/core.php';

//ADDING CAB DATA

if(isset($_POST["name"]))
        {
			$name=test_input($_POST['name']);
			$type=test_input($_POST['type']);
			$rc_no=test_input($_POST['rc_no']);
			$car_no=test_input($_POST['car_no']);
			$vendor=test_input($_POST['vendor']);
            $sql="insert into cabs (cab_name,cab_type_id,rc_no,car_no,vendor_id) values('$name',$type,'$rc_no','$car_no',$vendor)";            
            if($conn->query($sql))
            {
              echo "success";
            }
            else
            {
              echo "error";
            }
        }
//DELETING CAB DATA

if(isset($_POST['delete_id']))
        {
			$id_d=$_POST["delete_id"];
			$sql="delete from cabs where id=$id_d";
			if($conn->query($sql))
			{
                echo "success";
			
			}
			else
				echo "error";
        }

//UPDATING CAB DATA

if(isset($_POST["edit"]))
        {
            $cab_id=$_POST["edit"];
			$name=test_input($_POST['ename']);
			$type=test_input($_POST['etype']);
			$rc_no=test_input($_POST['erc_no']);
			$car_no=test_input($_POST['ecar_no']);
			$vendor=test_input($_POST['evendor']);
            $sql="update cabs set cab_name='$name',cab_type_id=$type,rc_no='$rc_no',car_no='$car_no',vendor_id=$vendor where id=$cab_id";
            if($conn->query($sql))
            {
              echo "success";
            }
            else
            {
              echo $conn->error;
            }
        }

//FETCHING CAB DETAILS

if(isset($_POST['cab_details']))
{
    // $sql="select c.id,c.cab_type_id,c.cab_name,c.rc_no,c.rc_img,c.rc_back_img,c.insurance,c.cab_img, t.type ,c.car_no ,v.full_name as full_name ,v.vendor_id from cabs c,cab_types t,vendor_profile v where c.cab_type_id=t.id and c.vendor_id=v.vendor_id ";
    $sql = "SELECT *,cabs.id as id FROM cabs LEFT JOIN cab_types ON cab_types.id=cabs.cab_type_id LEFT JOIN vendor_profile ON vendor_profile.vendor_id=cabs.vendor_id";

if($result=$conn->query($sql))
    {
        if($result->num_rows>0)
        {
         
              while($row=$result->fetch_assoc())
              {
                 $cabs[]=$row;
              }
            echo json_encode($cabs);
          }
        else
            echo "unable to fetch data";
    }    
}
?>