File manager - Edit - /home/autoph/public_html/connectv1/api/controllers/brand.php
Back
<?php class Brand { function read_brand_id_by_name($name, $db){ return $db -> select("SELECT id FROM `source_brand` WHERE status = 1 AND `name` = '$name' "); } function create_brand($name, $db){ return $db -> sql_query_id("INSERT INTO source_brand (`name`, `logo`, `status`) VALUES ('$name', 'default.png', '1')"); } function create_brand_v2($name, $status,$db){ return $db -> sql_query_id("INSERT INTO source_brand (`name`, `logo`, `status`) VALUES ('$name', 'default.png', '$status')"); } function read_brand_id_by_name_v2($name,$db){ // echo "SELECT id FROM `source_brand` WHERE 1 AND `name` = '$name' "; return $db -> select("SELECT id FROM `source_brand` WHERE 1 AND `name` = '$name' "); } function read_brand_name_by_id($id, $db){ return $db -> select("SELECT name FROM `source_brand` WHERE status = 1 AND `id` = '$id'"); } function read_brands_offered_model($search, $db){ $contents = $db -> return_result("SELECT id, name FROM `source_brand` WHERE status = 1 AND `name` LIKE '%$search%' ORDER BY name ASC LIMIT 10"); $json = []; foreach($contents as $model){ $json[] = ['id'=>$model['id'], 'text'=>$model['name']]; } echo json_encode($json); } function read_brands_offered_model_no_limit($search, $db){ $contents = $db -> return_result("SELECT id, name FROM `source_brand` WHERE status = 1 AND `name` LIKE '%$search%' ORDER BY name ASC"); $json = []; foreach($contents as $model){ $json[] = ['id'=>$model['id'], 'text'=>$model['name']]; } echo json_encode($json); } function create_brands_offered(){ } function read_brand_id_by_name_no_status($name, $db){ return $db -> select("SELECT id FROM `source_brand` WHERE 1 AND `name` = '$name' "); } function create_brand_no_status($name, $db){ return $db -> sql_query_id("INSERT INTO source_brand (`name`, `logo`, `status`) VALUES ('$name', 'default.png', '0')"); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings