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