<?php
class Affiliations{ 
    function read_affiliations_content($search,$affiliationsCategory,$db){ 
             $contents = $db -> return_result("SELECT id,name FROM `customer_affiliations_content` WHERE affiliation_id = '$affiliationsCategory' AND status=1 AND `name` LIKE '%$search%' ORDER BY name ASC LIMIT 10");
                    $json = [];
                    foreach($contents as $content){
                         $json[] = ['id'=>$content['name'], 'text'=>$content['name']];
                    }
                    echo json_encode($json); 
    } 

        
     function read_affiliations_id_by_name($id,$name,$db){
        return $db -> select("SELECT id FROM `customer_affiliations_content` WHERE status=1 AND `name` = '$name' AND affiliation_id = '$id' ");  
    } 

    function create_affiliations($id,$name,$db){
                    return $db -> sql_query_id("INSERT INTO customer_affiliations_content (affiliation_id,name,status) VALUES ('$id','$name','1')");  
    }
 

} 
?>