File manager

File manager - Edit - /home/autoph/public_html/connectv1/api/controllers/variant.php

Back
<?php class Variant { function read_variant_id_by_name($name, $db){ return $db -> select("SELECT id FROM `source_car_model_variant` WHERE status = 1 AND `name` = '$name' "); } function create_variant($name, $db){ return $db -> sql_query_id("INSERT INTO source_car_model_variant (`name`, `status`) VALUES ('$name', '1')"); } function read_variant_name_by_id($id, $db){ return $db -> select("SELECT name FROM `source_car_model_variant` WHERE status = 1 AND `id` = '$id'"); } function read_variant_by_model_id($search, $model_id, $db){ $variants = $db -> return_result("SELECT id, name FROM `source_car_model_variant` WHERE name LIKE '%$search%' AND status = 1 AND `car_model_id` = '$model_id' LIMIT 10"); $json = []; foreach($variants as $variant){ $json[] = ['id'=>$variant['id'], 'text'=>$variant['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