D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
u384067285
/
domains
/
cauldronsisterss.com
/
public_html
/
admin
/
Filename :
edit_company_contact.php
back
Copy
<?php session_start(); error_reporting(0); include 'connection.php'; if (strlen($_SESSION['bpmsaid'] == 0)) { header("Location: logout.php"); } if (isset($_POST['update'])) { /* Fetch Requests from input box */ $company_email = $_POST['company_email']; $company_phone_number = $_POST['company_phone_number']; $company_address = $_POST['company_address']; /* Add Requests */ $eid = $_GET['editid']; /* Update Requests */ $sql = "UPDATE tblcompanyinfo SET company_email = '$company_email', company_phone_number = '$company_phone_number', company_address = '$company_address' WHERE company_email = '$eid'"; if ($conn->query($sql) === TRUE) { $msg = "Info. Update Successfully"; } else { $msg = $conn->error; } } ?> <!DOCTYPE html> <html lang="en"> <head> <!-- Required meta tags --> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <title>Cauldron Sisterss | Edit Company Contact</title> <!-- plugins:css --> <link rel="stylesheet" href="vendors/feather/feather.css"> <link rel="stylesheet" href="vendors/mdi/css/materialdesignicons.min.css"> <link rel="stylesheet" href="vendors/ti-icons/css/themify-icons.css"> <link rel="stylesheet" href="vendors/typicons/typicons.css"> <link rel="stylesheet" href="vendors/simple-line-icons/css/simple-line-icons.css"> <link rel="stylesheet" href="vendors/css/vendor.bundle.base.css"> <!-- endinject --> <!-- Plugin css for this page --> <link rel="stylesheet" href="vendors/select2/select2.min.css"> <link rel="stylesheet" href="vendors/select2-bootstrap-theme/select2-bootstrap.min.css"> <!-- End plugin css for this page --> <!-- inject:css --> <link rel="stylesheet" href="css/vertical-layout-light/style.css"> <!-- endinject --> <?php include 'favicon.php'; ?> </head> <body> <div class="container-scroller"> <!-- partial:../../partials/_navbar.php --> <?php include 'header.php'; ?> <!-- partial --> <div class="container-fluid page-body-wrapper"> <!-- partial:../../partials/_sidebar.html --> <?php include 'sidebar.php'; ?> <!-- partial --> <div class="main-panel"> <div class="content-wrapper"> <div class="row"> <div class="col-md-12 grid-margin stretch-card"> <div class="card"> <div class="card-body"> <h4 class="card-title">Edit Company Contact Info. <span style = "color:red;"> <?php echo $msg; ?> </span> </h4> <form class="forms-sample" method="post"> <?php $cid = $_GET['editid']; $sql = "SELECT * FROM tblcompanyinfo WHERE company_email = '$cid'"; $result = $conn->query($sql); while ($row = mysqli_fetch_array($result)) { ?> <div class="form-group"> <label for="email">Email address</label> <input type="email" class="form-control" id="email" placeholder="Email" name="company_email" value = "<?php echo $row['company_email']; ?>" required> </div> <div class="form-group"> <label for="phone">Phone Number</label> <input type="tel" class="form-control" id="phone" placeholder="Mobile" name="company_phone_number" value = "<?php echo $row['company_phone_number']; ?>" required> </div> <div class="form-group"> <label for="address">Address</label> <textarea class="form-control" id="address" rows="3" placeholder="Address" name="company_address" required><?php echo $row['company_address']; ?></textarea> </div> <button type="submit" class="btn btn-primary me-2" name="update">Update</button> <a href="company_contact.php" class="btn btn-success">Cancel</a> <?php } ?> </form> </div> </div> </div> </div> <div class="row"> <div class="col-lg-12 grid-margin stretch-card"> <div class="card"> <div class="card-body"> <h4 class="card-title">Manage Company Contact Info. </h4> <div class="table-responsive"> <table class="table table-hover"> <thead> <tr> <th>#</th> <th>Company Email</th> <th>Company Mobile</th> <th>Action</th> </tr> </thead> <tbody> <?php $cid = $_GET['editid']; $sql = "SELECT * FROM tblcompanyinfo WHERE company_email = '$cid'"; $result = $conn->query($sql); $cnt = 1; while ($row = mysqli_fetch_array($result)) { ?> <tr> <td><?php echo $cnt; ?></td> <td><?php echo $row['company_email']; ?></td> <td><?php echo $row['company_phone_number']; ?></td> <td> <label class="badge badge-warning"> <a href = "edit_company_contact.php?editid=<?php echo $row['company_email']; ?>" style="text-decoration:none; color:black;">Edit</a> </label> <label class="badge badge-danger"> <a href = "delete_company_contact.php?id=<?php echo $row['company_email']; ?>" style="text-decoration:none; color:black;">Delete</a> </label> </td> </tr> <?php $cnt = $cnt + 1; } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> <!-- content-wrapper ends --> <!-- partial:../../partials/_footer.html --> <?php include 'footer.php'; ?> <!-- partial --> </div> <!-- main-panel ends --> </div> <!-- page-body-wrapper ends --> </div> <!-- container-scroller --> <!-- plugins:js --> <script src="vendors/js/vendor.bundle.base.js"></script> <!-- endinject --> <!-- Plugin js for this page --> <script src="vendors/typeahead.js/typeahead.bundle.min.js"></script> <script src="vendors/select2/select2.min.js"></script> <script src="vendors/bootstrap-datepicker/bootstrap-datepicker.min.js"></script> <!-- End plugin js for this page --> <!-- inject:js --> <script src="js/off-canvas.js"></script> <script src="js/hoverable-collapse.js"></script> <script src="js/template.js"></script> <script src="js/settings.js"></script> <script src="js/todolist.js"></script> <!-- endinject --> <!-- Custom js for this page--> <script src="js/file-upload.js"></script> <script src="js/typeahead.js"></script> <script src="js/select2.js"></script> <!-- End custom js for this page--> </body> </html>