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