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