|
Server : LiteSpeed System : Linux terra.hostitbro.com 5.14.0-611.54.3.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu May 7 16:31:24 EDT 2026 x86_64 User : outerorb ( 1091) PHP Version : 8.1.34 Disable Function : mail Directory : /home2/outerorb/dev.outerorbittech.com/erp/admin/ | |
|
Path: /home2/outerorb/dev.outerorbittech.com/erp/admin/adupdate.php
Size: 13.22 KB
Permissions: 0644
<!doctype html>
<html class="no-js" lang="">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>UPDATE FORM</title>
<link rel="icon" type="image/png" href="images/ric.png"/>
<meta name="description" content="Ela Admin - HTML5 Admin Template">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/normalize.css@8.0.0/normalize.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.1.3/dist/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/font-awesome@4.7.0/css/font-awesome.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/lykmapipo/themify-icons@0.1.2/css/themify-icons.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/pixeden-stroke-7-icon@1.2.3/pe-icon-7-stroke/dist/pe-icon-7-stroke.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/flag-icon-css/3.2.0/css/flag-icon.min.css">
<link rel="stylesheet" href="assets/css/cs-skin-elastic.css">
<link rel="stylesheet" href="assets/css/style.css">
<link href="https://cdn.jsdelivr.net/npm/chartist@0.11.0/dist/chartist.min.css" rel="stylesheet">
<link href="https://cdn.jsdelivr.net/npm/jqvmap@1.5.1/dist/jqvmap.min.css" rel="stylesheet">
<link href="https://cdn.jsdelivr.net/npm/weathericons@2.1.0/css/weather-icons.css" rel="stylesheet" />
<link href="https://cdn.jsdelivr.net/npm/fullcalendar@3.9.0/dist/fullcalendar.min.css" rel="stylesheet" />
<style>
#weatherWidget .currentDesc {
color: #ffffff!important;
}
.traffic-chart {
min-height: 335px;
}
#flotPie1 {
height: 150px;
}
#flotPie1 td {
padding:3px;
}
#flotPie1 table {
top: 20px!important;
right: -10px!important;
}
.chart-container {
display: table;
min-width: 270px ;
text-align: left;
padding-top: 10px;
padding-bottom: 10px;
}
#flotLine5 {
height: 105px;
}
#flotBarChart {
height: 150px;
}
#cellPaiChart{
height: 160px;
}
/* CSS PART OF ADD CLIENT */
/* Importing fonts from Google */
@import url('https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700;800;900&display=swap');
/* Reseting */
* {
margin: 0;
padding: 0;
box-sizing: border-box;
font-family: 'Poppins', sans-serif;
}
body {
background: #ecf0f3;
}
.wrapper {
max-width: 350px;
min-height: 500px;
margin: 80px auto;
padding: 40px 30px 30px 30px;
background-color: #ecf0f3;
border-radius: 15px;
box-shadow: 13px 13px 20px #cbced1, -13px -13px 20px #fff;
}
.logo {
width: 80px;
margin: auto;
}
.logo img {
width: 100%;
height: 80px;
object-fit: cover;
border-radius: 50%;
box-shadow: 0px 0px 3px #5f5f5f,
0px 0px 0px 5px #ecf0f3,
8px 8px 15px #a7aaa7,
-8px -8px 15px #fff;
}
.wrapper .name {
font-weight: 600;
font-size: 1.4rem;
letter-spacing: 1.3px;
padding-left: 10px;
color: #555;
}
.wrapper .form-field input {
width: 100%;
display: block;
border: none;
outline: none;
background: none;
font-size: 1.2rem;
color: #666;
padding: 10px 15px 10px 10px;
/* border: 1px solid red; */
}
.wrapper .form-field {
padding-left: 10px;
margin-bottom: 20px;
border-radius: 20px;
box-shadow: inset 8px 8px 8px #cbced1, inset -8px -8px 8px #fff;
}
.wrapper .form-field .fas {
color: #555;
}
.wrapper .btn {
box-shadow: none;
width: 100%;
height: 40px;
background-color: #03A9F4;
color: #fff;
border-radius: 25px;
box-shadow: 3px 3px 3px #b1b1b1,
-3px -3px 3px #fff;
letter-spacing: 1.3px;
}
.wrapper .btn:hover {
background-color: #039BE5;
}
.wrapper a {
text-decoration: none;
font-size: 0.8rem;
color: #03A9F4;
}
.wrapper a:hover {
color: #039BE5;
}
@media(max-width: 380px) {
.wrapper {
margin: 30px 20px;
padding: 40px 15px 15px 15px;
}
}
</style>
</head>
<body>
<!-- Left Panel -->
<aside id="left-panel" class="left-panel">
<nav class="navbar navbar-expand-sm navbar-default">
<div id="main-menu" class="main-menu collapse navbar-collapse">
<ul class="nav navbar-nav">
<li class="">
<a href="index.php"><i class="menu-icon fa fa-dashcube"> </i>Dashboard </a>
</li>
<li class="">
<a href="data.php"><i class="menu-icon fa fa-user"></i>CLIENT LIST </a>
</li>
<li class="active">
<a href="add.php"><i class="menu-icon fa fa-money"></i>ADD CLIENT </a>
</li>
<li class="">
<a href="../end.php"><i class="menu-icon fa fa-sign-out"></i>LOGOUT </a>
</li>
</div><!-- /.navbar-collapse -->
</nav>
</aside>
<!-- /#left-panel -->
<!-- Right Panel -->
<div id="right-panel" class="right-panel">
<!-- Header-->
<header id="header" class="header">
<div class="top-left">
<div class="navbar-header">
<a class="navbar-brand" href="./"><img src="../images/logo.png" alt="Logo"></a>
<a class="navbar-brand hidden" href="./"><img src="../images/logo2.png" alt="Logo"></a>
<a id="menuToggle" class="menutoggle"><i class="fa fa-bars"></i></a>
</div>
</div>
<div class="top-right">
<div class="header-menu">
<div class="header-left">
<button class="search-trigger"><i class="fa fa-search"></i></button>
<!-- //search -->
<div class="form-inline">
<form class="search-form">
<input class="form-control mr-sm-2" type="text" placeholder="Search ..." aria-label="Search">
<button class="search-close" type="submit"><i class="fa fa-close"></i></button>
</form>
</div>
</div>
<div class="user-area dropdown float-right">
<a href="#" class="dropdown-toggle active" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
<img class="user-avatar rounded-circle" src="../images/logo2.png" alt="User">
</a>
<div class="user-menu dropdown-menu">
<a class="nav-link" href="../end.php" style="color:red; font-weight:700;"><i class="fa fa-power -off"></i>LOGOUT</a>
</div>
</div>
</div>
</div>
</header>
<?php
if(isset($_POST['submit']))
{
$id=$_GET['id'];
$type=trim($_POST['type']);
$name=trim($_POST['name']);
$street=trim($_POST['street']);
$city=trim($_POST['city']);
$state=trim($_POST['state']);
$zip=trim($_POST['zip']);
$email=trim($_POST['email']);
$alt=trim($_POST['alt']);
$date=trim($_POST['date']);
$amt=trim($_POST['amt']);
include"connection.php";
$qv="update client
set type= '".$type."', name='".$name."', street='".$street."', city='".$city."', state='".$state."', zip='".$zip."', email='".$email."', altemail='".$alt."',date='".$date."',amount='".$amt."'where aid='".$id."'";
$sqv=mysqli_query($cn,$qv);
if($sqv)
{
echo '<script> alert("UPDATE SUCCESSFULLY");
window.location="data.php"; </script>';
}
else
{
// function to show sql query error
echo'<br>'.mysqli_error($cn);
}
}
?>
<?php
if(isset($_GET['id']))
{
$id=$_GET['id'];
include"connection.php";
$q="select * from client where aid='".$id."'";
$sq=mysqli_query($cn,$q);
if($sq)
{
// check if any value found or not
if(mysqli_fetch_array($sq)>0)
{
$sq=mysqli_query($cn,$q);
while($row=mysqli_fetch_array($sq))
{
//
?>
<div class="wrapper">
<div class="logo">
<img src="images/ric.png" alt="">
</div>
<div class="text-center mt-4 name">
EDIT CLIENT INFO
</div>
<form action="" class="p-3 mt-3" method="POST" enctype="multipart/form-data">
<div class="form-field d-flex align-items-center">
<input name="invno" class="form-control" placeholder="Inv no." type="text" value="<?php echo $row['invno']; ?>" style="color:black" readonly>
</div>
<div class="form-field d-flex align-items-center">
<select name="type" class="form-control" required style="
width: 100%;
display: block;
border: none;
outline: none;
background: none;
font-size: 1.2rem;
color: #666;
padding: 5px 15px 10px 10px;
">
<option value="">Type Of Client</option>
<option value="Company" <?php $type = $row['type']; if ($type=='Company') { echo "SELECTED"; } ?> >Company</option>
<option value="Individual" <?php $type = $row['type']; if ($type=='Individual') { echo "SELECTED"; } ?>>Individual</option>
</select>
</div>
<div class="form-field d-flex align-items-center">
<input name="name" class="form-control" placeholder="Full name" type="text" value="<?php echo $row['name']; ?>">
</div>
<div class="form-field d-flex align-items-center">
<input name="street" class="form-control" placeholder="Street Name" type="text" value="<?php echo $row['street']; ?>">
<input name="city" class="form-control" placeholder="City Name" type="text" value="<?php echo $row['city']; ?>">
</div>
<div class="form-field d-flex align-items-center">
<input name="state" class="form-control" placeholder="State" type="text" value="<?php echo $row['state']; ?>">
<input name="zip" class="form-control" placeholder="Zip Code" type="text" value="<?php echo $row['zip']; ?>">
</div>
<div class="form-field d-flex align-items-center">
<input name="email" class="form-control" placeholder="Email address" type="text" value="<?php echo $row['email']; ?>">
</div>
<div class="form-field d-flex align-items-center">
<input name="alt" class="form-control" placeholder="Alt. Email address" type="text" value="<?php echo $row['altemail']; ?>">
</div>
<div class="form-field d-flex align-items-center">
<input name="date" class="form-control" placeholder="Date Of Reg." type="date" value="<?php echo $row['date']; ?>">
</div>
<div class="form-field d-flex align-items-center">
<input name="amt" class="form-control" placeholder="Amount" type="Text" value="<?php echo $row['amount']; ?>">
</div>
<button class="btn mt-3" name="submit" style="background-color:green">UPDATE</button>
</form>
</div>
<?php
}
}
else
{
echo '<br> no record found ';
}
}
else
{
echo '<br>'.mysqli_error($cn);
}
}
else
{
header("location:data.php");
}
?>
<script src="https://cdn.jsdelivr.net/npm/jquery@2.2.4/dist/jquery.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.14.4/dist/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.1.3/dist/js/bootstrap.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/jquery-match-height@0.7.2/dist/jquery.matchHeight.min.js"></script>
<script src="assets/js/main.js"></script>
<!-- Chart js -->
<script src="https://cdn.jsdelivr.net/npm/chart.js@2.7.3/dist/Chart.bundle.min.js"></script>
<!--Chartist Chart-->
<script src="https://cdn.jsdelivr.net/npm/chartist@0.11.0/dist/chartist.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/chartist-plugin-legend@0.6.2/chartist-plugin-legend.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/jquery.flot@0.8.3/jquery.flot.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/flot-pie@1.0.0/src/jquery.flot.pie.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/flot-spline@0.0.1/js/jquery.flot.spline.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/simpleweather@3.1.0/jquery.simpleWeather.min.js"></script>
<script src="assets/js/init/weather-init.js"></script>
<script src="https://cdn.jsdelivr.net/npm/moment@2.22.2/moment.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/fullcalendar@3.9.0/dist/fullcalendar.min.js"></script>
<script src="assets/js/init/fullcalendar-init.js"></script>