[
MAINHACK
]
Mail Test
BC
Config Scan
HOME
Create...
New File
New Folder
Viewing / Editing File: add_location.php
<?php include('header.php'); ?> <style type="text/css"> #fli,#fli1 { width: 79%; height: 42px; } #display { position:absolute; width:303; margin-left:0; margin-top:0; padding:2px; display:none; border-top:0px; overflow:auto; border:1px #CCC solid; background-color: white; z-index:1000; } .show11,.show12 { padding:7px; border-bottom:1px #999 dashed; font-size:13px; } .show11:hover,.show1:hover { background:#1da1f2; color:#000; cursor:pointer; } .widget{ overflow:visible !important; } </style> <script> function get_sub_category_name() { var category_id = $('#district').val(); $.ajax({ type: "POST", url: "ajax_check.php", // Name of the php files data: "district="+category_id, success: function(html) { $("#show").html(html); document.getElementById("hide_k").style.display="none"; } }); } </script> <div class="main-panel"> <div class="content"> <div class="container-fluid"> <div class="row"> <div class="col-md-6"> <div class="card"> <div class="card-header"> <div class="card-title">Add Location</div> </div> <form method="post" id="exampleValidation" data-toggle="validator" enctype="multipart/form-data" > <div class="card-body"> <div class="form-group form-show-validation row"> <label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 text-right">District Name <span class="required-label">*</span></label> <div class="col-lg-8 col-md-9 col-sm-8"> <select class="form-control" id="district" onChange="get_sub_category_name();" name="district"> <option value="">District Name</option> <?php // $table1='designation'; //$sq="select * from designation where position>$position and position<=8"; //$stmt=$con->prepare($sq); // $stmt->execute(); $table="district"; $stmt=$show->readAll_clause('city','group by district order by id asc'); $num=$stmt->rowCount(); if($num>0){ while($row=$stmt->fetch(PDO::FETCH_ASSOC)){ echo "<option value='".$row['district']."'>".$row['district']."</option>"; } } ?> </select> </div> </div> <div class="form-group form-show-validation row"> <label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 text-right">City</label> <div class="col-lg-8 col-md-9 col-sm-8"> <div id="show"></div> <div id="hide_k"> <select class="form-control" name="City"> <option value="">City</option> </select></div> </div> </div> <div class="form-group form-show-validation row"> <label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 text-right">Location Name <span class="required-label">*</span></label> <div class="col-lg-8 col-md-9 col-sm-8"> <input type="text" class="form-control" name="locality" placeholder="Location Name " required> </div> </div> <div class="form-group form-show-validation row"> <label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 text-right">Pincode <span class="required-label">*</span></label> <div class="col-lg-8 col-md-9 col-sm-8"> <input type="number" steps="any" class="form-control" name="pincode" placeholder="Pincode " required> </div> </div> <div class="card-action"> <div class="row"> <div class="col-md-12"> <input class="btn btn-success" type="submit" name="sub" value="Submit"> <button class="btn btn-danger">Cancel</button> </div> </div> </div> </div> </form> </div> </div> <?php if(isset($_POST['sub'])){ $sq=$con->prepare("select id from district where locality='".$_POST['locality']."' and pincode='".$_POST['pincode']."'"); $sq->execute(); $c=$sq->rowCount(); if($c>0){ echo '<script> setTimeout(function() { swal({ title: "oops!", text: "Locality and pincode exists", type: "error" }, function() { window.location = "'.$_SERVER['REQUEST_URI'].'"; }); }, 1000); </script>'; }else{ $data = array( 'locality' => htmlentities(strip_tags($_POST['locality'])), 'district' => htmlentities(strip_tags($_POST['district'])), 'pincode' => htmlentities(strip_tags($_POST['pincode'])), 'city' => htmlentities(strip_tags($_POST['city'])), ); if($show->insert('district',$data)){ echo '<script> setTimeout(function() { swal({ title: "Thank You!", text: "Location has been added", type: "success" }, function() { window.location = "'.$_SERVER['REQUEST_URI'].'"; }); }, 1000); </script>'; //echo "<script>swal('Thank you for Registration.');window.location.href='".$_SERVER['request_uri']."';</script>"; } } }?> <div class="col-md-6"> <div class="card"> <div class="card-body"> <div class="table-responsive"> <h5 class="page-title">All Locations</h5> <table id="basic-datatables" class="display table table-striped table-hover"> <thead> <tr> <th>Sl</th> <th>Locality</th> <th>District</th> <th>City</th> <th>Pincode</th> <th>Delete</th> </tr> </thead> <tbody> <?php $sr='district'; $stmt =$show->readAll($sr); $num = $stmt->rowCount(); if($num>0){ $count=1; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){ extract($row); $id=$row['id']; echo "<tr> <td>$count</td> <td>".$row['locality']."</td> <td>".$row['district']."</td> <td>".$row['city']."</td> <td>".$row['pincode']."</td> " ; ?> <td> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-danger" data-original-title="Remove"> <a href="delete_menu.php?id=<?=$id?>&table=<?=$sr?>&url=<?=$_SERVER['REQUEST_URI']?>" class="btn btn-link btn-danger"onclick="return send();"><i class='la la-times'></i></a> </button> </td> <?php echo"</tr>"; ++$count; } } ?> </tbody></table> </div> </div> </div> </div> </div> </div> <!--footer--> <?php include('footer.php'); ?>
Save Changes
Cancel / Back
Close ×
Server Info
Hostname: server05.hostinghome.co.in
Server IP: 192.168.74.40
PHP Version: 7.4.33
Server Software: Apache
System: Linux server05.hostinghome.co.in 3.10.0-962.3.2.lve1.5.81.el7.x86_64 #1 SMP Wed May 31 10:36:47 UTC 2023 x86_64
HDD Total: 1.95 TB
HDD Free: 677.49 GB
Domains on IP: N/A (Requires external lookup)
System Features
Safe Mode:
Off
disable_functions:
None
allow_url_fopen:
On
allow_url_include:
Off
magic_quotes_gpc:
Off
register_globals:
Off
open_basedir:
None
cURL:
Enabled
ZipArchive:
Disabled
MySQLi:
Enabled
PDO:
Enabled
wget:
Yes
curl (cmd):
Yes
perl:
Yes
python:
Yes
gcc:
Yes
pkexec:
No
git:
Yes
User Info
Username: itsweb
User ID (UID): 1619
Group ID (GID): 1621
Script Owner UID: 1619
Current Dir Owner: 1619