|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/celkcksm/cms.ncriptech.com/../websites/vtti.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$mysqli = new mysqli('localhost','e_campus_cc','e_campus_cc','e_campus_cc');
$resultArray=array();
if(!empty($_POST['ApiType'])){
if($_POST['ApiType']=='country'){
$result = $mysqli->query("SELECT * FROM countries");
$resultArray = $result->fetch_all(MYSQLI_ASSOC);
}else if($_POST['ApiType']=='state' && isset($_POST['CountryId'])){
$result = $mysqli->query("SELECT * FROM states where country_id='".$_POST['CountryId']."'");
$resultArray = $result->fetch_all(MYSQLI_ASSOC);
}else{
$resultArray['status']='error';
$resultArray['msg']='Api Type Not Matched !';
}
}else{
$resultArray['status']='error';
$resultArray['msg']='Please Send ApiType';
}
echo json_encode($resultArray);
?>