File manager - Edit - /home/autoph/public_html/connectv1/api/controllers/media_publication.php
Back
<?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')"); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings