File manager - Edit - /home/autoph/public_html/connectv1/api/controllers/model.php
Back
<?php class Model { function read_model_id_by_name($name, $db){ return $db -> select("SELECT id FROM `source_car_model` WHERE status = 1 AND `name` = '$name' "); } function create_model($name, $db){ return $db -> sql_query_id("INSERT INTO source_car_model (`name`, `status`) VALUES ('$name', '1')"); } function create_model_v2($brand_id,$name, $status,$db){ return $db -> sql_query_id("INSERT INTO source_car_model (`brand_id`,`name`, `status`) VALUES ('$brand_id','$name', '$status')"); } function read_model_id_by_name_v2($brand_id,$name,$db){ return $db -> select("SELECT id FROM `source_car_model` WHERE 1 AND brand_id = '$brand_id' AND `name` = '$name' "); } function read_model_id_by_name_with_brand($name, $brand_id,$db){ return $db -> select("SELECT id FROM `source_car_model` WHERE 1 AND `name` = '$name' AND brand_id= '$brand_id' "); } function create_model_with_brand($name, $brand_id,$db){ return $db -> sql_query_id("INSERT INTO source_car_model (`name`,`brand_id`, `status`) VALUES ('$name','$brand_id', '0')"); } function read_model_name_by_id($id, $db){ return $db -> select("SELECT name FROM `source_car_model` WHERE status = 1 AND `id` = '$id'"); } function read_model_by_brand_id($search,$brand_id, $db){ // echo "SELECT id,name FROM `source_car_model` WHERE name LIKE '%$search%' AND status = 1 AND `brand_id` = '$brand_id'";exit; $models = $db -> return_result("SELECT id,name FROM `source_car_model` WHERE name LIKE '%$search%' AND status = 1 AND `brand_id` = '$brand_id' LIMIT 10"); $json = []; foreach($models as $model){ $json[] = ['id'=>$model['id'], 'text'=>$model['name']]; } echo json_encode($json); } function read_model_by_brand_id_no_limit($search,$brand_id, $db){ // echo "SELECT id,name FROM `source_car_model` WHERE name LIKE '%$search%' AND status = 1 AND `brand_id` = '$brand_id'";exit; $models = $db -> return_result("SELECT id,name FROM `source_car_model` WHERE name LIKE '%$search%' AND status = 1 AND `brand_id` = '$brand_id' "); $json = []; foreach($models as $model){ $json[] = ['id'=>$model['id'], 'text'=>$model['name']]; } echo json_encode($json); } function read_model_variant_id_by_name($name,$model_id, $db){ return $db -> select("SELECT id FROM `source_car_model_variant` WHERE car_model_id = '$model_id' AND status = 1 AND `name` = '$name' "); } function create_model_variant($name,$model_id, $db){ return $db -> sql_query_id("INSERT INTO source_car_model_variant (`name`, `car_model_id`,`status`) VALUES ('$name', '$model_id','1')"); } function read_model_variant_name_by_id($id, $db){ return $db -> select("SELECT name FROM `source_car_model_variant` WHERE status = 1 AND `id` = '$id'"); } function read_model_variant_by_model_id($search,$model_id, $db){ // echo "SELECT id,name FROM `source_car_model_variant` WHERE car_model_id = '$model_id' AND status = 1 AND `name` LIKE '%$search%' ORDER BY name ASC LIMIT 10 "; $variants = $db -> return_result("SELECT id,name FROM `source_car_model_variant` WHERE car_model_id = '$model_id' AND status = 1 AND `name` LIKE '%$search%' ORDER BY name ASC LIMIT 10 "); $json = []; foreach($variants as $variant){ $json[] = ['id'=>$variant['name'], 'text'=>$variant['name']]; } echo json_encode($json); } function read_brands_offered_model($search, $brandOfferedBrand, $db){ $contents = $db -> return_result("SELECT id, name FROM `source_car_model` WHERE brand_id = '$brandOfferedBrand' AND status = 1 AND `name` LIKE '%$search%' ORDER BY name ASC LIMIT 10"); $json = []; foreach($contents as $model){ $json[] = ['id'=>$model['name'], 'text'=>$model['name']]; } echo json_encode($json); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings