File manager - Edit - /home/autoph/public_html/connectv1/api/controllers/city.php
Back
<?php class City{ function read_all_city($db){ $cities = $db -> return_result("SELECT ac.`id`,astate.provDesc, ac.`citymunDesc` FROM `all_city` ac LEFT OUTER JOIN all_state astate ON ac.provCode = astate.provCode WHERE ac.status = 1 ORDER by ac.`citymunDesc` ASC"); $json = []; foreach($cities as $city){ $json[] = ['id'=>$city['id'], 'text'=>$city['citymunDesc'].' - ('.$city['provDesc'].')' ]; } echo json_encode($json); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings