File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/tmp.php
Back
<?php include "connection.php"; $sql = "SELECT `vehicle_table`.`vehicle_id` AS 'VEHICLE_ID',`vehicle_table`.`vehicle_picture` AS 'VEHICLE_PICTURE',`vehicle_table`.`vehicle_no` AS 'VEHICLE_NUMBER',`model_master_table`.`model_name` AS 'VEHICLE_MODEL',`client_table`.`name` AS 'CLIENT_FIRSTNAME',`client_table`.`surname` AS 'CLIENT_LASTNAME',`vehicle_table`.`mfg_year` AS 'VEHICLE_MFGYEAR' FROM `vehicle_table`,`model_master_table`,`client_table` WHERE `vehicle_table`.`mo_id` = `model_master_table`.`model_id` AND `vehicle_table`.`owner_id` = `client_table`.`client_id`"; $rows = $con->query($sql); echo "["; while ($row = $rows->fetch_assoc()) { echo json_encode($row); } echo"]"; ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings