JezK
Edit File: ajax_lc.php
<?php include('admin_functions.php'); $admin=new adm_functions(); if($_REQUEST['mode'] == "addState"){ $add_state2=str_replace(";"," ",$_REQUEST['state']); $insert = $admin->insert_state2($add_state2); $optionstates=''; if($insert == 200){ $statesdata = $admin->get_states(); $optionstates .='<option value="">Select State</option>'; foreach($statesdata as $key=>$val){ $optionstates .= '<option value="'.$val['stateid'].'">'.$val['statename'].'</option>'; } } echo $optionstates; } //getStateName if($_REQUEST['mode'] == "stateID") { $edit_state=str_replace(";"," ",$_REQUEST['edit_state']); $insert = $admin->get_statename($edit_state); if($insert!='') echo $insert; else echo ""; } //Update State if($_REQUEST['mode'] == "updateState") { $edit_state=str_replace(";"," ",$_REQUEST['state']); $edit_stid=$_REQUEST['edit_stid']; $insert = $admin->update_state2($edit_state,$edit_stid); $optionstates=''; if($insert == 200){ $statesdata = $admin->get_states(); $optionstates .='<option value="">Select State</option>'; foreach($statesdata as $key=>$val){ $optionstates .= '<option value="'.$val['stateid'].'">'.$val['statename'].'</option>'; } } echo $optionstates; } //addDistrict if($_REQUEST['mode'] == "addDistrict") { $new_district_name=str_replace(";"," ",$_REQUEST['new_district_name']); $dis_id=$_REQUEST['dis_id']; $insert = $admin->insert_district2($new_district_name,$dis_id); $districts_data = $admin->get_alldistricts(); $optionstates=''; if($insert == 200){ foreach($districts_data as $key=>$val){ $optionstates .= '<option value="'.$val['id'].'">'.$val['districtname'].'</option>'; } } echo $optionstates; } if($_REQUEST['mode'] == "updateDistrict") { $edit_new_district2=str_replace(";"," ",$_REQUEST['edit_new_district2']); $edit_dis_sid=$_REQUEST['edit_dis_sid']; $edit_dis_id=$_REQUEST['edit_dis_id']; $insert=$admin->update_district2($edit_dis_sid,$edit_dis_id,$edit_new_district2); if($insert == 200){ echo "1"; } else { echo ""; } } if($_REQUEST['mode'] == "addMandal") { $add_new_mandal2=str_replace(";"," ",$_REQUEST['add_new_mandal2']); $mandal_district_id=$_REQUEST['mandal_district_id']; $insert=$admin->insert_mandal2($mandal_district_id,$add_new_mandal2); if($insert == 200){ echo "1"; } else { echo ""; } } //add mandal if($_REQUEST['mode'] == "updateEditMandal") { $edit_new_mandal2=str_replace(";"," ",$_REQUEST['edit_new_mandal2']); $emandal_district_id=$_REQUEST['emandal_district_id']; $edit_mandal_id=$_REQUEST['edit_mandal_id']; $insert=$admin->update_mandal2($edit_mandal_id,$emandal_district_id,$edit_new_mandal2); if($insert == 200){ echo "1"; } else { echo ""; } } if($_REQUEST['mode'] == "addCity") { $new_city_name=str_replace(";"," ",$_REQUEST['new_city_name2']); $mandal=$_REQUEST['mandal']; $insert=$admin->insert_city2($mandal,$new_city_name); if($insert == 200){ echo "1"; } else { echo ""; } } if($_REQUEST['mode'] == "UpdateCityData") { $edit_city_name2=str_replace(";"," ",$_REQUEST['edit_city_name2']); $mandal=$_REQUEST['mandal']; $cityid=$_REQUEST['cityid']; $insert=$admin->update_city2($cityid,$mandal,$edit_city_name2); if($insert == 200){ echo "1"; } else { echo ""; } } if($_REQUEST['mode'] == "deleteImg") { $insert=$admin->deleteMultipleImage($_POST['id']); if($insert == 1) { $getMultipleImages=$admin->getNewsMultipleImagesWithID($_POST['cat']); if(count($getMultipleImages)>0) { foreach($getMultipleImages as $img){ ?> <image height="150px" width="100px" class="removeimg" src="http://<?php echo $_SERVER['HTTP_HOST'].'/kaburu/'.$img['image'];?>" ></image><a href="javascript:void(0)" class="delsty" onclick="return delimg('<?php echo $img['image_id'];?>','<?php echo $_POST['cat'];?>','<?php echo $_POST['media'];?>')">X</a> <?php } } else if($_POST['media']!='') {?> <image height="150px" width="100px" class="removeimg" src="http://<?php echo $_SERVER['HTTP_HOST'].'/kaburu/'.$newsdata['media'];?>" ></image> <?php } else { echo ""; } } else { echo ""; } } //statePhoneNumbers if($_REQUEST['mode'] == "getStatenums") { $insert=$admin->getUserPhoneNumbers($_POST['s'],$_POST['ustype']); if($insert!='') echo $insert; else echo "No users Found"; } //state+district Phonenumbers if($_REQUEST['mode'] == "getDistname") { $insert=$admin->getUserDistrictwithStatePhones($_POST['s'],$_POST['ustype'],$_POST['dest']); if($insert!='') echo $insert; else echo "No users Found"; } //state+district+mandal Phonenumbers if($_REQUEST['mode'] == "getManData") { $insert=$admin->getUserDistrictStatewithMandalPhones($_POST['s'],$_POST['ustype'],$_POST['dest'],$_POST['mandal']); if($insert!='') echo $insert; else echo "No users Found"; } //state+district+mandal+city Phonenumbers if($_REQUEST['mode'] == "getCitData") { $insert=$admin->getUserDistrictStateMandalwithCityPhones($_POST['s'],$_POST['ustype'],$_POST['dest'],$_POST['mandal'],$_POST['city']); if($insert!='') echo $insert; else echo "No users Found"; } ?>