Preview: add-state.php
Size: 8.18 KB
/home/urbanman/hindustansecurity.in/admin/add-state.php
<?php
error_reporting(0);
include("common.php");
include("config.php");
$id = $_GET[id];
$r7 = sprintf("SELECT * from state WHERE id = '$id'");
$resdata7 = $conn->query($r7);
$row=mysqli_fetch_assoc($resdata7);
?>
<script>
setTimeout(function(){
$('#myData').hide();
}, 3000);
</script>
<!-- START: Template CSS-->
<link rel="stylesheet" href="dist/vendors/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.min.css">
<link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.theme.min.css">
<link rel="stylesheet" href="dist/vendors/simple-line-icons/css/simple-line-icons.css">
<link rel="stylesheet" href="dist/vendors/flags-icon/css/flag-icon.min.css">
<link rel="stylesheet" href="dist/vendors/flag-select/css/flags.css">
<!-- END Template CSS-->
<!-- START: Page CSS-->
<link rel="stylesheet" href="dist/vendors/quill/quill.snow.css" />
<!-- END: Page CSS-->
<!-- START: Custom CSS-->
<link rel="stylesheet" href="dist/css/main.css">
<!-- END: Custom CSS-->
<!-- START: Main Content-->
<main>
<div class="container-fluid">
<!-- START: Breadcrumbs-->
<div class="row ">
<div class="col-12 align-self-center">
<div class="sub-header mt-3 py-3 px-3 align-self-center d-sm-flex w-100 rounded">
<?php if($_GET[id]==""){?>
<div class="w-sm-100 mr-auto"><h5 class="mb-0">Add State</h5></div>
<?php } else {?>
<div class="w-sm-100 mr-auto"><h5 class="mb-0">Update State</h5></div>
<?php } ?>
<?php
if($_GET[flag]=="del") {?>
<center><div style="font-size:16px;" id="myData" >
<span class="label label-success">
<font color="red">Record deleted successfully!</font></span></font></div></center> <br/>
<?php }
if($_GET[flag]=="dn") {?>
<center><div style="font-size:16px;" id="myData" >
<span class="label label-success">
<font color="green">Record added successfully!</font></span></font></div></center> <br/>
<?php }
if($_GET[flag]=="up") {?>
<center><div style="font-size:16px;" id="myData" >
<span class="label label-success">
<font color="blue">Record updated successfully!</font></span></font></div></center> <br/>
<?php }
?>
</div>
</div>
</div>
<!-- END: Breadcrumbs-->
<!-- START: Card Data-->
<div class="row">
<div class="col-12 col-sm-12 mt-3">
<div class="card">
<div class="card-body">
<form class="form-row" action="submit-state.php" method="post" enctype="multipart/form-data">
<div class="form-group col-md-12">
<td style="width:3%"> State Name <font color="red">*</font> </td>
<td> <input type="text" class="form-control" value="<?php echo $row[state];?>" placeholder="Enter" required name="state"></td>
</div>
<br>
<div class="form-group col-md-12">
<button type="submit" class="btn5" > Submit </button>
<a href="welcome.php"><button type="button" class="btn6" > Back to page </button></a>
<?php $id = $row[id]; if($id==""){?>
<input type="hidden" value="add" name="mode" >
<?php }else{?>
<input type="hidden" value="<?php echo $id;?>" name="id" >
<?php }?>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- END: Card DATA-->
<!-- START: Card Data-->
<div class="row">
<div class="col-12 mt-3">
<div class="card">
<div class="card-header justify-content-between align-items-center">
<h4 class="card-title"> State List</h4>
</div>
<div class="card-body">
<div class="table-responsive">
<table id="example" class="display table dataTable table-bordered" >
<thead>
<tr>
<th>Sr</th>
<th>State Name</th>
<th> Action</th>
</tr>
</thead>
<tbody>
<?php
error_reporting(0);
include("config.php");
$query="select * from state order by state ASC";
$result = $conn->query($query);
while($prow=mysqli_fetch_assoc($result)){
$count ++;
?>
<tr>
<td><?php echo $count;?></td>
<td><?php echo ucfirst($prow[state]);?></td>
<td>
<a href="add-state.php?id=<?php echo $prow[id];?>"><i class="fa fa-edit"></i></a>
<a class="btn3" title="delete" href="submit-state.php?flag=del&id=<?php echo $prow[id];?>"onclick="if(confirm('Do You Want To Delete This ?')){return true;}else{return false;}">
<i class="fa fa-trash icon-white"></i>
</a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</main>
<!-- END: Content-->
<!-- START: Template JS-->
<script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
<script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
<script src="dist/vendors/moment/moment.js"></script>
<script src="dist/vendors/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script>
<!-- END: Template JS-->
<!-- START: APP JS-->
<script src="dist/js/app.js"></script>
<!-- END: APP JS-->
<!-- START: Page Vendor JS-->
<script src="dist/vendors/quill/quill.min.js"></script>
<!-- END: Page Vendor JS-->
<!-- START: Page Script JS-->
<script src="dist/js/mail.script.js"></script>
<!-- END: Page Script JS-->
<style>
.btn5{
padding:2px;
background-color:#fc2210;
color:#fff;
border-radius:2px;
padding-left:10px;padding-right:10px;
border:2px solid #fc2210;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
width:100px;
}
.btn6{
padding:2px;
background-color:#4a3937;
color:#fff;
border-radius:2px;
padding-left:10px;padding-right:10px;
border:2px solid #4a3937;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
width:120px;
}
</style>
</body>
</html>
Directory Contents
Dirs: 5 × Files: 42