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