File manager - Edit - /home/autoph/public_html/connectv1/api/controllers/sme_group.php
Back
<?php class SmeGroup{ function read_sme_groups_content($search,$db){ $sme_groups = $db -> return_result("SELECT id,name FROM `source_sme_groups` WHERE status=1 AND `name` LIKE '%$search%' ORDER BY name ASC LIMIT 10"); $json = []; foreach($sme_groups as $sme_group){ $json[] = ['id'=>$sme_group['name'], 'text'=>$sme_group['name']]; } echo json_encode($json); } function read_sme_group_id_by_name($name,$db){ return $db -> select("SELECT id FROM `source_sme_groups` WHERE status=1 AND `name` = '$name' "); } function create_sme_group($name,$db){ return $db -> sql_query_id("INSERT INTO source_sme_groups (name,date_added,status) VALUES ('$name',NOW(),'1')"); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings