|
Server IP : 103.191.208.227 / Your IP : 3.21.105.119 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/mhmsfzcs/vflyorions.com/.well-known/../../ssl/../invoice.vflyorion.com/all/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'db.php';
$id = $_GET['edit'];
$sql = "SELECT * FROM all_invoice WHERE id=$id";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$invoice = $result->fetch_assoc();
$fullname = $invoice['fullname'];
$contact = $invoice['contact'];
$email = $invoice['email'];
$address = $invoice['address'];
$plan = $invoice['plan'];
$price = $invoice['price'];
$rprice = $invoice['r_price'];
$offer = $invoice['offer'];
$date = $invoice['date'];
$id = $invoice['id'];
}
if (isset($_POST['update'])) {
$id = $_POST['id']; // Assuming you are passing an ID to identify the record to update
$fullname = $_POST['fullname'];
$email = $_POST['email'];
$contact = $_POST['contact'];
$plan = $_POST['plan'];
$date = $_POST['date'];
$price = $_POST['price'];
$price1 = $_POST['price1'];
$offer = $_POST['offer'];
$address = $_POST['address'];
// Prepare and bind the statement for update
$stmt = $conn->prepare("UPDATE all_invoice SET fullname = ?, email = ?, contact = ?, plan = ?, price = ?, r_price = ?, offer = ?, address = ?, date = ? WHERE id = ?");
$stmt->bind_param("sssssssssi", $fullname, $email, $contact, $plan, $price, $price1, $offer, $address, $date, $id);
// Execute the statement
if ($stmt->execute()) {
$_SESSION['status'] = "Updated Successfully";
$_SESSION['status_code'] = "success";
} else {
$_SESSION['status'] = "Oops something went wrong!!";
$_SESSION['status_code'] = "error";
}
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Vflyorions Invoice</title>
<!-- Google Font: Source Sans Pro -->
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
<!-- Font Awesome -->
<link rel="stylesheet" href="../../plugins/fontawesome-free/css/all.min.css">
<!-- icheck bootstrap -->
<link rel="stylesheet" href="../../plugins/icheck-bootstrap/icheck-bootstrap.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="../../dist/css/adminlte.min.css">
</head>
<body class="mb-8 my-4">
<div class="container-fluid p-3">
<a href="table.php" class="btn btn-info">Back</a>
<div class="row">
<div class="col-sm-3">
</div>
<div class="col-sm-6">
<div class="register-box" style="width:380px;"></div>
<div class="card card-outline card-primary">
<div class="card-header text-center">
<a href="" class="h1"><b>Edit Invoice</b></a>
</div>
<div class="card-body">
<form method="post" enctype="multipart/form-data">
<div class="input-group mb-3">
<input type="date" class="form-control" name="date" value="<?= $date; ?>">
<input type="hidden" class="form-control" name="id" value="<?= $id; ?>">
<div class="input-group-append">
<div class="input-group-text">
<span class="fas fa-user"></span>
</div>
</div>
</div>
<div class="input-group mb-3">
<input type="text" class="form-control" placeholder="Full name" name="fullname" value="<?= $fullname; ?>">
<div class="input-group-append">
<div class="input-group-text">
<span class="fas fa-user"></span>
</div>
</div>
</div>
<div class="input-group mb-3">
<input type="email" class="form-control" placeholder="Email Id" name="email" value="<?= $email; ?>" >
<div class="input-group-append">
<div class="input-group-text">
<span class="fas fa-envelope"></span>
</div>
</div>
</div>
<div class="input-group mb-3">
<input type="text" class="form-control" placeholder="Contact No." name="contact" value="<?= $contact; ?>" >
<div class="input-group-append">
<div class="input-group-text">
<span class="fas fa-phone"></span>
</div>
</div>
</div>
<div class="input-group mb-3">
<input type="text" class="form-control" placeholder="Services" name="plan" value="<?= $plan; ?>">
<div class="input-group-append">
<div class="input-group-text">
<span class="fas fa-pen"></span>
</div>
</div>
</div>
<div class="input-group mb-3">
<input type="text" class="form-control" placeholder="Grand Total" name="price" value="<?= $price; ?>" >
<div class="input-group-append">
<div class="input-group-text">
<span class="fas fa-pen"></span>
</div>
</div>
</div>
<div class="input-group mb-3">
<input type="text" class="form-control" placeholder="Received Amount" name="price1" value="<?= $rprice; ?>" >
<div class="input-group-append">
<div class="input-group-text">
<span class="fas fa-pen"></span>
</div>
</div>
</div>
<div class="input-group mb-3">
<!--<input type="text" class="form-control" placeholder="Amount" name="price" required>-->
<lable class="form">GST :</lable>
<input type="radio" class="form" name="offer" value="Yes"> <lable class="form">Yes </lable>
<input type="radio" class="form" name="offer" value="No" checked> <lable class="form" >No </lable>
</div>
<div class="input-group mb-3">
<input type="text" class="form-control" placeholder="Address" name="address" value="<?= $address; ?>" >
<div class="input-group-append">
<div class="input-group-text">
<span class="fas fa-address-book"></span>
</div>
</div>
</div>
<div class="row">
<div class="col-4">
</div>
<!-- /.col -->
<div class="col-4">
<button type="submit" class="btn btn-primary btn-block m-2" name="update">Edit</button>
</div>
<div class="col-4">
</div>
<!-- /.col -->
</div>
</form>
<!--<a href="login.html" class="text-center">I already have a membership</a>-->
</div>
<!-- /.form-box -->
</div><!-- /.card -->
</div>
<div class="col-sm-3">
</div>
</div>
</div>
<!-- /.register-box -->
<!-- jQuery -->
<script src="../../plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="../../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<?php if(isset($_SESSION['status']) && $_SESSION['status']!='') { ?>
<script>
new swal({
title: "<?php echo $_SESSION['status'];?>",
//text: "You clicked the button!",
icon: "<?php echo $_SESSION['status_code'];?>",
button: "OK",
}).then(function() {
window.location = "table.php";
});
</script>
<?php
unset($_SESSION['status']);
}
?>
</body>
</html>