File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/APPS/eKisan/Editcity.php
Back
<!DOCTYPE html> <html lang="en" class="loading"> <head> <title>Ekisan</title> <script src="app-assets/vendors/js/sweetalert2.min.js"></script> <link rel="stylesheet" type="text/css" href="app-assets/vendors/css/sweetalert2.min.css"> <link rel="apple-touch-icon" sizes="60x60" href="app-assets/img/ico/apple-icon-60.png"> <link rel="apple-touch-icon" sizes="76x76" href="app-assets/img/ico/apple-icon-76.png"> <link rel="apple-touch-icon" sizes="120x120" href="app-assets/img/ico/apple-icon-120.png"> <link rel="apple-touch-icon" sizes="152x152" href="app-assets/img/ico/apple-icon-152.png"> <link rel="shortcut icon" type="image/x-icon" href="app-assets/img/ico/favicon.ico"> <link rel="shortcut icon" type="image/png" href="app-assets/img/ico/favicon-32.png"> <link href="https://fonts.googleapis.com/css?family=Rubik:300,400,500,700,900%7CMontserrat:300,400,500,600,700,800,900" rel="stylesheet"> <link rel="stylesheet" type="text/css" href="app-assets/fonts/feather/style.min.css"> <link rel="stylesheet" type="text/css" href="app-assets/fonts/simple-line-icons/style.css"> <link rel="stylesheet" type="text/css" href="app-assets/fonts/font-awesome/css/font-awesome.min.css"> <link rel="stylesheet" type="text/css" href="app-assets/vendors/css/perfect-scrollbar.min.css"> <link rel="stylesheet" type="text/css" href="app-assets/vendors/css/prism.min.css"> <link rel="stylesheet" type="text/css" href="app-assets/vendors/css/chartist.min.css"> <link rel="stylesheet" type="text/css" href="app-assets/css/app.css"> </head> <body data-col="2-columns" class=" 2-columns "> <!--ValidateUser--> <?php session_start(); if(!isset($_SESSION['user'])){ $page = "login.php"; header("location:$page"); exit; } if(!isset($_GET['id'])){ if(!isset($_POST['city_name'])) { $page = "marketyard_city.php"; header("location:$page"); exit; } } ?> <?php require_once('Connection.php'); if(isset($_POST['city_name'])) { $id = $_POST['city_id']; $cname = $_POST['city_name']; $fletter = $_POST['city_firstletter']; $ldate = $_POST['last_update_date']; $sql = "UPDATE `city_table` SET `city_id` = '$id', `city_name` = '$cname', `city_firstletter` = '$fletter',`last_update_date` = '$ldate' WHERE `city_table`.`city_id` = $id"; if($con->query($sql) == TRUE) { echo '<script>swal({ title: "Updated!", text: "City Update Successfully", type: "success", confirmButtonText: "OK" }); </script> '; } else { $sql = "UPDATE `city_table` SET `city_name` = '$cname', `city_firstletter` = '$fletter', `last_update_date` = '$ldate' WHERE `city_table`.`city_id` = $id"; if($con->query($sql) == TRUE) { echo '<script>swal({ title: "Updated!", text: "City Update Successfully", type: "success", confirmButtonText: "OK" }); </script> '; } } } ?> <!--Data Fatch--> <?php if(isset($_GET['id'])) { $sql = "SELECT `city_table`.`city_id` AS 'CITY_ID',`city_table`.`city_name` AS 'CITY_NAME',`city_table`.`city_firstletter` AS 'CITY_FLETTER',`city_table`.`last_update_date` AS 'C_LDATE' FROM `city_table` WHERE `city_table`.`city_id` =".$_GET['id']; } else { $sql = "SELECT `city_table`.`city_id` AS 'CITY_ID',`city_table`.`city_name` AS 'CITY_NAME',`city_table`.`city_firstletter` AS 'CITY_FLETTER',`city_table`.`last_update_date` AS 'C_LDATE' FROM `city_table` WHERE `city_table`.`city_id` = ".$id; } $rows = $con->query($sql); $row = $rows->fetch_assoc(); ?> <div class="wrapper"> <!--Side Menu--> <?php include("Menu.php"); ?> <!--Navbar menu--> <?php include("Navbar.php"); ?> <div class="main-panel"> <div class="main-content"> <div class="content-wrapper"> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div class="card"> <div class="card-header"> <div class="card-title-wrap bar-primary"> <h4 class="card-title" id="horz-layout-icons">Update City</h4> </div> </div> <div class="card-body"> <div class="px-3"> <form class="form form-horizontal" action="" method="POST" enctype="multipart/form-data"> <div class="form-body"> <div class="form-group row"> <label class="col-md-3 label-control" for="timesheetinput1">ID: </label> <div class="col-md-9"> <div class="position-relative has-icon-left"> <input type="text" id="timesheetinput1" class="form-control" name="city_id" value="<?php if(isset($row)){ echo $row['CITY_ID']; } ?>" required readonly> <div class="form-control-position"> <i class="icon-user"></i> </div> </div> </div> </div> <div class="form-group row"> <label class="col-md-3 label-control" for="timesheetinput2">City Name: </label> <div class="col-md-9"> <div class="position-relative has-icon-left"> <input type="text" id="timesheetinput2" class="form-control" name="city_name" value="<?php if(isset($row)){ echo $row['CITY_NAME']; } ?>" required> <div class="form-control-position"> <i class="ft-user"></i> </div> </div> </div> </div> <div class="form-group row"> <label class="col-md-3 label-control" for="timesheetinput3">City First Letter: </label> <div class="col-md-9"> <div class="position-relative has-icon-left"> <input type="text" id="timesheetinput3" class="form-control" name="city_firstletter" value="<?php if(isset($row)){ echo $row['CITY_FLETTER']; } ?>" required> <div class="form-control-position"> <i class="ft-user"></i> </div> </div> </div> </div> <div class="form-group row"> <label class="col-md-3 label-control" for="timesheetinput4">Last Update Date: </label> <div class="col-md-9"> <div class="position-relative has-icon-left"> <input type="text" id="timesheetinput4" class="form-control" name="last_update_date" value="<?php if(isset($row)){ echo $row['C_LDATE']; } ?>" required> <div class="form-control-position"> <i class="icon-screen-smartphone"></i> </div> </div> </div> </div> <div class="form-actions right"> <a href="marketyard_city.php"> <button type="button" class="btn btn-danger mr-1"> <i class="icon-action-undo"></i> Back </button> </a> <button type="submit" class="btn btn-success"> <i class="icon-note"></i> Save </button> </div> </form> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <!-- ////////////////////////////////////////////////////////////////////////////--> <!-- BEGIN VENDOR JS--> <script src="app-assets/vendors/js/core/jquery-3.3.1.min.js"></script> <script src="app-assets/vendors/js/core/popper.min.js"></script> <script src="app-assets/vendors/js/core/bootstrap.min.js"></script> <script src="app-assets/vendors/js/perfect-scrollbar.jquery.min.js"></script> <script src="app-assets/vendors/js/prism.min.js"></script> <script src="app-assets/vendors/js/jquery.matchHeight-min.js"></script> <script src="app-assets/vendors/js/screenfull.min.js"></script> <script src="app-assets/vendors/js/pace/pace.min.js"></script> <!-- BEGIN VENDOR JS--> <!-- BEGIN PAGE VENDOR JS--> <script src="app-assets/vendors/js/chartist.min.js"></script> <!-- END PAGE VENDOR JS--> <!-- BEGIN CONVEX JS--> <script src="app-assets/js/app-sidebar.js"></script> <script src="app-assets/js/notification-sidebar.js"></script> <!-- END CONVEX JS--> <!-- BEGIN PAGE LEVEL JS--> <script src="app-assets/js/dashboard-ecommerce.js"></script> <!-- END PAGE LEVEL JS--> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings