JezK
Edit File: contactsbook.php
<?php include('admin_functions.php'); if($_SESSION['username']=='') { echo "<script>location.replace('index.php');</script>" ; } ?> <link href="assets/css/jquery.lightbox-0.5.css" rel="stylesheet"/> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <script type="text/javascript" src="https://www.google.com/jsapi"> </script> <?php $admin=new adm_functions(); $state_id=''; $optionstates=''; $statesdata = $admin->get_states(); foreach($statesdata as $key=>$val){ $state=''; if($val['stateid']==$state_id) {$state="selected"; } $optionstates .= '<option value="'.$val['stateid'].'" '.$state.'>'.$val['statename'].'</option>'; } $currentPage='sendsms'; include"header.php"; ?> <div class="main-panel"> <nav class="navbar navbar-default"> <div class="container-fluid"> <div class="navbar-header"> <button type="button" class="navbar-toggle"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar bar1"></span> <span class="icon-bar bar2"></span> <span class="icon-bar bar3"></span> </button> <a class="navbar-brand" href="#">Contacts Book</a> </div> </div> <div class="collapse navbar-collapse"> </div> </nav> <div class="content"> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div class="row form-group"> <label for="category" class="col-md-3 label-control">User Type:</label> <div class="col-md-4"> <select class="form-control" id="user_type" name="user_type" onchange="return checkempty()"> <option value="">Select</option> <option value="0">All</option> <option value="1">Active</option> <option value="2">Inactive</option> <option value="3">Not Verified</option> <option value="4">Blocked</option> <option value="5">Guest Users</option> </select> </div> </div> <div class="row form-group"> <label for="category" class="col-md-3 label-control">State:</label> <div class="col-md-4"> <select id="state" name="state" onchange="districts_data(this.value);gotnums1(this.value)" class="form-control"> <option value="" >Select State</option> <?php echo $optionstates; ?> </select> </div> </div> <div class="row form-group"> <label for="category" class="col-md-3 label-control">District:</label> <div class="col-md-4"> <select id="district" name="district" onchange="mandals_data(this.value);gotnums2(this.value);" class="form-control"> <option value="" >Select District</option> <?php echo $optionstates2; ?> </select> </div> </div> <div class="row form-group"> <label for="category" class="col-md-3 label-control">Mandal:</label> <div class="col-md-4"> <select class="form-control" id="mandal" name="mandal" onchange="city_data(this.value);gotnums3(this.value);"> <option value="">Select Mandal</option> <?php echo $optionstates1; ?> </select> </div> </div> <div class="row form-group"> <label for="category" class="col-md-3 label-control">City Name:</label> <div class="col-md-4"> <select class="form-control" id="cityname" name="cityname" onchange="gotnums4(this.value);"> <option value="">Select City Name</option> <?php echo $optionstates1; ?> </select> </div> </div> <div class="row form-group"> <label for="category" class="col-md-3 label-control">Available Users:</label> <div class="col-md-4"> <textarea cols="50" rows="10" name="phonenums" id="phonenums" readonly></textarea> </div> </div> <div class="row form-group col-md-3 col-md-offset-3" > <input class="btn btn-primary" type="button" value="Copy Phone Numbers" id="copyme"> </div> </div> </div> </div> </div> <?php include"footer.php" ?> <link rel="stylesheet" type="text/css" href="./jquery.datetimepicker.css"/> <style type="text/css"> .custom-date-style { background-color: red !important; } .input{ } .input-wide{ width: 500px; } .bk_color { background-color:white; } #state_pop,#edit_district_pop,#edit_state_pop,#edit_city_pop,#add_city_pop,#edit_mandal_pop,#add_mandal{ padding:10px; } #add_state,#edit_state,#edit_new_district,#edit_city_name,#new_city_name,#add_new_mandal,#edit_new_district,#new_district,#edit_new_mandal{ width:100%; } </style> <script src="./jquery.js"></script> <script src="assets/js/jquery_003.js"></script> <script type="text/javascript" src="assets/js/jquery.lightbox_me.js"></script> <script> function districts_data(stateid){ $.ajax({ url: "ajaxcalls.php", type:"POST", data:"mode="+"getdistricts"+"&state="+stateid, success: function(result) { $("#district").html(result); //section_option += '<option value="'+result2[i].section_id+'">'+result2[i].section_name+'</option>'; } }); } function mandals_data(district){ $.ajax({ url: "ajaxcalls.php", type:"POST", data:"mode="+"getmandals"+"&district="+district, success: function(result) { $("#mandal").html(result); //section_option += '<option value="'+result2[i].section_id+'">'+result2[i].section_name+'</option>'; } }); } function city_data(mandalid) { $('#mandalExcelID').val(mandalid); $.ajax({ url: "ajaxcalls.php", type:"POST", data:"mode="+"getcityData"+"&mandal="+mandalid, success: function(result) { $("#cityname").html(result); //section_option += '<option value="'+result2[i].section_id+'">'+result2[i].section_name+'</option>'; } }); } function validate_postform(){ var state=$('#state').val(); var district=$('#district').val(); var mandal=$('#mandal').val(); var cityname=$('#cityname').val(); $('span.error').remove(); if(state=='') { $('#state').after('<span style="color:red" class="error">Select state</span>'); $('#state').focus(); return false; } else if(district=='') { $('#district').after('<span style="color:red" class="error">Select district</span>'); $('#district').focus(); return false; } else if(mandal=='') { $('#mandal').after('<span style="color:red" class="error">Select mandal</span>'); $('#mandal').focus(); return false; } else if(cityname=='') { $('#cityname').after('<span style="color:red" class="error">Required city</span>'); $('#cityname').focus(); return false; } } function gotnums1(v) { var state=v; var ustype=$('#user_type').val(); $.ajax({ url: "ajax_lc.php", type:"POST", data:"mode="+"getStatenums"+"&s="+state+'&ustype='+ustype, success: function(result) { $('#phonenums').html(''); $('#phonenums').html(result); } }); } function gotnums2(v) { var dest=v; var ustype=$('#user_type').val(); var state=$('#state').val(); $.ajax({ url: "ajax_lc.php", type:"POST", data:"mode="+"getDistname"+"&s="+state+'&ustype='+ustype+'&dest='+dest, success: function(result) { $('#phonenums').html(''); $('#phonenums').html(result); } }); } function gotnums3(v) { var mandal=v; var ustype=$('#user_type').val(); var state=$('#state').val(); var dest=$('#district').val(); $.ajax({ url: "ajax_lc.php", type:"POST", data:"mode="+"getManData"+"&s="+state+'&ustype='+ustype+'&dest='+dest+'&mandal='+mandal, success: function(result) { $('#phonenums').html(''); $('#phonenums').html(result); } }); } function gotnums4(v) { var city=v; var ustype=$('#user_type').val(); var state=$('#state').val(); var dest=$('#district').val(); var mandal=$('#mandal').val(); $.ajax({ url: "ajax_lc.php", type:"POST", data:"mode="+"getCitData"+"&s="+state+'&ustype='+ustype+'&dest='+dest+'&mandal='+mandal+'&city='+city, success: function(result) { $('#phonenums').html(''); $('#phonenums').html(result); } }); } function checkempty() { $('#state').prop('selectedIndex',0); $('#district').prop('selectedIndex',0); $('#mandal').prop('selectedIndex',0); $('#cityname').prop('selectedIndex',0); $('#phonenums').html(''); } $("#copyme").click(function(){ $("textarea").select(); document.execCommand('copy'); }); </script>