<?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')");  
        }

          
    } 
?>