D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
newpcjewellers.in
/
newadminpc
/
Filename :
edit_blog.php
back
Copy
<?php // Include database connection include 'config.php'; // Fetch the blog details based on the blog ID passed in the URL if (isset($_GET['id'])) { $blog_id = $_GET['id']; $query = "SELECT * FROM blog WHERE id = $blog_id"; $result = mysqli_query($conn, $query); if ($result) { $blog = mysqli_fetch_assoc($result); } else { echo "<script>alert('Blog not found');window.location.href='blogs.php';</script>"; } } // Update blog details after form submission if (isset($_POST['updateblog'])) { $title = mysqli_real_escape_string($conn, $_POST['title']); $description = mysqli_real_escape_string($conn, $_POST['description']); $description1 = mysqli_real_escape_string($conn, $_POST['description1']); $image_name = $_FILES['image']['name']; $image_temp = $_FILES['image']['tmp_name']; if (!empty($image_name)) { // New image uploaded $image_folder = 'uploads/' . basename($image_name); move_uploaded_file($image_temp, $image_folder); } else { // Use existing image if no new image is uploaded $image_name = $blog['image']; } // Update the blog in the database $update_query = "UPDATE blog SET title = '$title', description = '$description', description1 = '$description1', image = '$image_name' WHERE id = $blog_id"; if (mysqli_query($conn, $update_query)) { echo "<script>alert('Blog updated successfully');window.location.href='blogs.php';</script>"; } else { echo "<script>alert('Error: Could not update blog');window.location.href='edit_blog.php?id=$blog_id';</script>"; } } // Close the database connection mysqli_close($conn); ?> <!DOCTYPE html> <html lang="en"> <head> <?php include 'style.php'; ?> </head> <body> <!-- page-wrapper Start--> <div class="page-wrapper default-wrapper" id="pageWrapper"> <!-- Page Header Start--> <div class="page-header"> <div class="header-wrapper row m-0"> <div class="header-logo-wrapper col-auto p-0"> <div class="logo-wrapper"> <a href="index.php"> <img class="img-fluid for-light" src="assets/images/newpclogo.png" alt=""> <img class="img-fluid for-dark" src="assets/images/newpclogo.png" alt=""> </a> </div> </div> <div class="nav-right col-auto box-col-6 pull-right right-header p-0 ms-auto"> <ul class="nav-menus"> <li class="profile-nav onhover-dropdown p-0"> <div class="d-flex align-items-center profile-media"> <img class="b-r-10 img-40" src="assets/images/dashboard/profile.png" alt=""> <div class="flex-grow-1"> <span>Maa Tara Films</span> <p class="mb-0">Welcome Admin</p> </div> </div> </li> </ul> </div> </div> </div> <!-- Page Header Ends --> <!-- Page Body Start--> <div class="page-body-wrapper default-menu default-menu"> <!-- Page Sidebar Start--> <?php include 'sidebar.php'; ?> <!-- Page Sidebar Ends--> <div class="page-body"> <div class="container-fluid"> <div class="page-title"> <div class="row"> <div class="col-sm-6 ps-0"> <h3>Edit Blog</h3> </div> </div> </div> </div> <!-- Container-fluid starts--> <form action="edit_blog.php?id=<?php echo $blog_id; ?>" method="POST" enctype="multipart/form-data"> <div class="container-fluid"> <div class="row"> <div class="col-sm-12"> <div class="card"> <div class="card-body"> <div class="form theme-form"> <div class="row"> <div class="col"> <div class="mb-3"> <label>Add Title</label> <input class="form-control" type="text" name="title" value="<?php echo $blog['title']; ?>" required> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <label>Write Blog</label> <textarea class="form-control" name="description" rows="4" required><?php echo $blog['description']; ?></textarea> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <label>Write Blog</label> <textarea class="form-control" name="description1" rows="4" required><?php echo $blog['description1']; ?></textarea> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <label>Upload Image</label> <h4>Current Image: <img src="uploads/<?php echo $blog['image']; ?>" alt="Blog Image" style="max-width: 100px;"></h4> <input type="file" name="image" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <small>Leave blank to keep the current image</small> </div> </div> </div> <div class="row"> <div class="col"> <button type="submit" class="btn btn-success" name="updateblog">Update Blog</button> <a href="blogs.php" class="btn btn-outline-secondary">Cancel</a> </div> </div> </div> </div> </div> </div> </div> </div> </form> <!-- Container-fluid Ends--> </div> <!-- footer start--> <?php include 'footer.php'; ?> </div> </div> </body> </html>