File manager - Edit - /home/autoph/public_html/tasks/app/classes/brand_class.php
Back
<?php /** * use CRUD for class naming * example: create_ and read_and update_ and delete_ */ class Brand{ function read_brands($search,$brand_access_arr,$utility_class,$db){ $filter_brands_ids = (count($brand_access_arr) > 0) ? implode(",",$brand_access_arr) : "0" ; $filter_brands = " AND id IN ($filter_brands_ids) "; $query = "SELECT `id`, `name` FROM `vehicle_brands` WHERE name LIKE '%$search%' AND status = 1 $filter_brands ORDER BY name ASC;"; return $db->sql_query($query); } function read_brand_by_name($brand_name,$utility_class,$db){ $query = "SELECT * FROM `vehicle_brands` WHERE name = '$brand_name' AND status = 1 ORDER BY name ASC LIMIT 1;"; return $db->sql_query($query); } function read_brand_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `vehicle_brands` WHERE name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_brand_ids($db){ $query = "SELECT id FROM `vehicle_brands` WHERE 1 AND `status` = 1"; return $db->sql_query($query); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings