File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/demo.json
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`.`vehicle_picture` AS 'PIC',`vehicle_table`.`mfg_year` AS 'YEAR',`vehicle_table`.`fuel_type` AS 'FUEL_TYPE',`vehicle_table`.`km` AS 'KM' 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']; $sth = $con->query($sql); $products_arr=array(); $products_arr["records"]=array(); // retrieve our table contents // fetch() is faster than fetchAll() // http://stackoverflow.com/questions/2770630/pdofetchall-vs-pdofetch-in-a-loop while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){ // extract row // this will make $row['name'] to // just $name only extract($row); $product_item=array( "id" => $id, "name" => $name, "description" => html_entity_decode($description), "price" => $price, "category_id" => $category_id, "category_name" => $category_name ); array_push($products_arr["records"], $product_item); } // set response code - 200 OK http_response_code(200); // show products data in json format echo json_encode($products_arr); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings