File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/GetVehicle.php
Back
<?php if($_GET['id']) { require_once("Connection.php"); $sql = "SELECT `vehicle_table`.`vehicle_id` AS 'ID',`vehicle_table`.`vehicle_no` AS 'NO',CONCAT(`model_master_table`.`model_name`,' ',`mfg_master_table`.`mfg_name`) AS 'MODEL',`vehicle_table`.`mfg_year` AS 'YEAR',`model_master_table`.`picture` AS 'PIC',`vehicle_table`.`fuel_type` AS 'FUEL_TYPE',`vehicle_table`.`km` AS 'KM',`vehicle_table`.`selected` AS 'SELECTED' FROM `vehicle_table`,`model_master_table`,`mfg_master_table` WHERE `vehicle_table`.`mo_id` = `model_master_table`.`model_id` AND `model_master_table`.`mfg_id` = `mfg_master_table`.`mfg_id` AND `vehicle_table`.`owner_id` = '".$_GET['id']."' ORDER BY `vehicle_table`.`selected` DESC"; $rows = $con->query($sql); if($rows->num_rows > 0) { $vehicles["Vehicles"] = array(); while($row = $rows->fetch_assoc()) { $vehicle = array(); $vehicle = $row; array_push($vehicles["Vehicles"],$vehicle); } $vehicles["success"] = 1; } else { $vehicles["success"] = 0; } echo json_encode($vehicles); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings