<?php
class MediaPublication{ 
    function read_media_publications_content($search,$db){ 
             $media_publications = $db -> return_result("SELECT id,name FROM `source_media_publications` WHERE status=1 AND `name` LIKE '%$search%' ORDER BY name ASC LIMIT 10");
                    $json = [];
                    foreach($media_publications as $media_publication){
                         $json[] = ['id'=>$media_publication['name'], 'text'=>$media_publication['name']];
                    }
                    echo json_encode($json); 
    } 

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

    function create_media_publication($name,$db){
                    return $db -> sql_query_id("INSERT INTO source_media_publications (name,date_added,status) VALUES ('$name',NOW(),'1')");  
    }
 
} 
?>