D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
u384067285
/
domains
/
cauldronsisterss.com
/
public_html
/
admin
/
Filename :
edit_media.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 $upload_date = $_POST['upload_date']; $media_name = htmlentities($_POST['media_name']); $aLink = $_POST['aLink']; // Update Requests $eid = $_GET['editid']; // Prepare the SQL statement $stmt = $conn->prepare("UPDATE tblmediacoverage SET upload_date = ?, media_name = ?, aLink = ? WHERE id = ?"); // Bind parameters $stmt->bind_param("sssi", $upload_date, $media_name, $aLink, $eid); // Execute the statement if ($stmt->execute()) { $msg = "Media Updated Successfully"; header("Location: https://cauldronsisterss.com/admin/media.php"); exit; } else { $msg = $stmt->error; } // Close the statement $stmt->close(); } ?> <!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 | Manage Media Coverage</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">Manage Media Coverage <span style = "color:red;"> <?php echo $msg; ?> </span> </h4> <form class="forms-sample" method="post" enctype="multipart/form-data"> <?php $cid = $_GET['editid']; $sql = "SELECT * FROM tblmediacoverage WHERE id = '$cid'"; $result = $conn->query($sql); $cnt = 1; while ($row = mysqli_fetch_array($result)) { ?> <div class="form-group"> <label for="name">Name</label> <input type="text" class="form-control" id="name" placeholder="Name" name="media_name" required value = "<?php echo $row['media_name']; ?>"> </div> <div class="form-group col-lg-6"> <label for="name">Source Link</label> <textarea class = "form-control" placeholder = "Paste Source Link" name = "aLink"><?php echo $row['aLink']; ?></textarea> </div> <div class="form-group col-lg-6"> <label for="image1">Date</label> <input type = "date" class="form-control" name = "upload_date" value = "<?php echo $row['upload_date']; ?>" required> </div> <!-- <div class="row"> <div class="col-md-6"> <div class="form-group row"> <label class="col-sm-3 col-form-label">Image1</label> <div class="col-sm-9"> <input type="file" class="form-control" name = "image1" /> </div> </div> </div> <div class="col-md-6"> <div class="form-group row"> <label class="col-sm-3 pt-0 col-form-label"> <img height = "50" width = "50" src="images/media/"> </label> </div> </div> </div> --> <button type="submit" class="btn btn-primary me-2" name="update">Update</button> <a href = "media.php" class="btn btn-primary me-2">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 Media Coverage </h4> <div class="table-responsive"> <table class="table table-hover"> <thead> <tr> <th>Date</th> <th>Image</th> <th>Name</th> <th>Action</th> </tr> </thead> <tbody> <?php $sql = "SELECT * FROM tblmediacoverage ORDER BY upload_date DESC"; $result = $conn->query($sql); while ($row = mysqli_fetch_array($result)) { ?> <tr> <td><?php echo $row['upload_date']; ?></td> <td> <img src="images/media/<?php echo $row['image1']; ?>" alt="<?php echo $row['image1']; ?>"> </td> <td><?php echo $row['media_name']; ?></td> <td> <label class="badge badge-warning"> <a href = "edit_media.php?editid=<?php echo $row['media_name']; ?>" style="text-decoration:none; color:black;">Edit</a> </label> <label class="badge badge-danger"> <a href = "delete_media.php?id=<?php echo $row['media_name']; ?>" style="text-decoration:none; color:black;">Delete</a> </label> </td> </tr> <?php } ?> </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>