File manager - Edit - /home/autoph/public_html/data03252025consolidation/api/controllers/nature_of_business.php
Back
<?php class NatureOfBusiness { function read_nature_of_business_id_by_name($name, $db) { return $db->select("SELECT id FROM `source_nature_of_business` WHERE status = 1 AND `name` = '$name' "); } function read_nature_of_business($name, $db) { $nobs = $db->return_result("SELECT id,name FROM `source_nature_of_business` WHERE status = 1 AND `name` LIKE '%$name%' AND is_parent = 1 ORDER BY name LIMIT 10 "); $json = []; foreach ($nobs as $nob) { $json[] = ['id' => $nob['name'], 'text' => $nob['name']]; } echo json_encode($json); } function read_nature_of_business_name_by_id($id, $db) { return $db->select("SELECT name FROM `source_nature_of_business` WHERE status = 1 AND `id` = '$id'"); } function create_nature_of_business($name, $db) { return $db->sql_query_id("INSERT INTO source_nature_of_business (`name`, `status`) VALUES ('$name', '1')"); } }
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings