|
Server IP : 45.113.226.95 / Your IP : 216.73.216.239 Web Server : LiteSpeed System : Linux bharat.hostitbro.com 5.14.0-611.13.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Dec 11 04:57:59 EST 2025 x86_64 User : digita21 ( 1701) PHP Version : 8.3.30 Disable Function : mail MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF Directory (0755) : /home2/digita21/realpropertyindia.com/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
include("config.php");
if(!isset($_SESSION['auser']))
{
header("location:index.php");
}
///code
$error="";
$msg="";
if(isset($_POST['insert']))
{
$cid = $_GET['id'];
$ustate=$_POST['ustate'];
$ucity=$_POST['ucity'];
if(!empty($ustate) && !empty($ucity))
{
$sql="UPDATE city SET cname = '{$ucity}' ,sid = '{$ustate}' WHERE cid = {$cid}";
$result=mysqli_query($con,$sql);
if($result)
{
$msg="<p class='alert alert-success'>City Updated</p>";
header("Location:cityadd.php?msg=$msg");
}
else
{
$msg="<p class='alert alert-warning'>City Not Updated</p>";
header("Location:cityadd.php?msg=$msg");
}
}
else{
$error = "<p class='alert alert-warning'>* Please Fill all the Fields</p>";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
<title>Real Estate India - Data Tables</title>
<!-- Favicon -->
<link rel="shortcut icon" type="image/x-icon" href="assets/img/favicon.png">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="assets/css/bootstrap.min.css">
<!-- Fontawesome CSS -->
<link rel="stylesheet" href="assets/css/font-awesome.min.css">
<!-- Feathericon CSS -->
<link rel="stylesheet" href="assets/css/feathericon.min.css">
<!-- Datatables CSS -->
<link rel="stylesheet" href="assets/plugins/datatables/dataTables.bootstrap4.min.css">
<link rel="stylesheet" href="assets/plugins/datatables/responsive.bootstrap4.min.css">
<link rel="stylesheet" href="assets/plugins/datatables/select.bootstrap4.min.css">
<link rel="stylesheet" href="assets/plugins/datatables/buttons.bootstrap4.min.css">
<!-- Main CSS -->
<link rel="stylesheet" href="assets/css/style.css">
<!--[if lt IE 9]>
<script src="assets/js/html5shiv.min.js"></script>
<script src="assets/js/respond.min.js"></script>
<![endif]-->
</head>
<body>
<!-- Main Wrapper -->
<!-- Header -->
<?php include("header.php");?>
<!-- /Sidebar -->
<!-- Page Wrapper -->
<div class="page-wrapper">
<div class="content container-fluid">
<!-- Page Header -->
<div class="page-header">
<div class="row">
<div class="col">
<h3 class="page-title">State</h3>
<ul class="breadcrumb">
<li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
<li class="breadcrumb-item active">State</li>
</ul>
</div>
</div>
</div>
<!-- /Page Header -->
<!-- city add section -->
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-header">
<h1 class="card-title">Add City</h1>
<?php echo $error;?>
<?php echo $msg;?>
<?php
if(isset($_GET['msg']))
echo $_GET['msg'];
?>
</div>
<?php
$cid = $_GET['id'];
$sql = "SELECT * FROM city where cid = {$cid}";
$result = mysqli_query($con, $sql);
while($row = mysqli_fetch_row($result))
{
?>
<form method="post">
<div class="card-body">
<div class="row">
<div class="col-xl-6">
<h5 class="card-title">City Details</h5>
<div class="form-group row">
<label class="col-lg-3 col-form-label">State Name</label>
<div class="col-lg-9" >
<select class="form-control" name="ustate">
<option value="">Select</option>
<?php
$query1=mysqli_query($con,"select * from state");
while($row1=mysqli_fetch_row($query1))
{
?>
<option value="<?php echo $row1['0']; ?>">
<?php echo $row1['1']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group row">
<label class="col-lg-3 col-form-label">City Name</label>
<div class="col-lg-9">
<input type="text" class="form-control" name="ucity" value="<?php echo $row['1']; ?>">
</div>
</div>
</div>
</div>
<div class="text-left">
<input type="submit" class="btn btn-primary" value="Submit" name="insert" style="margin-left:200px;">
</div>
</div>
</form>
<?php } ?>
</div>
</div>
</div>
<!----End City add section --->
</div>
</div>
<!-- /Main Wrapper -->
<!---
---->
<!-- jQuery -->
<script src="assets/js/jquery-3.2.1.min.js"></script>
<!-- Bootstrap Core JS -->
<script src="assets/js/popper.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<!-- Slimscroll JS -->
<script src="assets/plugins/slimscroll/jquery.slimscroll.min.js"></script>
<!-- Datatables JS -->
<!-- Datatables JS -->
<script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
<script src="assets/plugins/datatables/dataTables.bootstrap4.min.js"></script>
<script src="assets/plugins/datatables/dataTables.responsive.min.js"></script>
<script src="assets/plugins/datatables/responsive.bootstrap4.min.js"></script>
<script src="assets/plugins/datatables/dataTables.select.min.js"></script>
<script src="assets/plugins/datatables/dataTables.buttons.min.js"></script>
<script src="assets/plugins/datatables/buttons.bootstrap4.min.js"></script>
<script src="assets/plugins/datatables/buttons.html5.min.js"></script>
<script src="assets/plugins/datatables/buttons.flash.min.js"></script>
<script src="assets/plugins/datatables/buttons.print.min.js"></script>
<!-- Custom JS -->
<script src="assets/js/script.js"></script>
</body>
</html>