1#@!#!123s

22527 1#@!#!123s
: / var / www / html / webadmin /
Filename : edit_blog.php
back
<?php 
ob_start();
include('header.php');

include_once('db.php');
ini_set('display_errors', 1);
error_reporting(E_ALL);

$id = $_GET['id'] ?? null;

if (!$id) {
    echo "Invalid blog ID!";
    exit;
}

// Get blog data
$stmt = $conn->prepare("SELECT * FROM blog WHERE id = ?");
$stmt->execute([$id]);
$blog = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$blog) {
    echo "Blog not found!";
    exit;
}

// Handle update form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $meta_title = $_POST['meta_title'];
    $meta_description = $_POST['meta_description'];
    $meta_keywords = $_POST['meta_keywords'];
    $page_name = $_POST['page_name'];
    $title = $_POST['title'];
    $description = $_POST['description'];
    $blog_date = $_POST['blog_date'];
    $url = $_POST['url'];
    
    $banner = $blog['banner'];
    if (!empty($_FILES['banner']['name'])) {
        $upload_dir = "uploads/";
        
        $banner = $upload_dir . basename($_FILES["banner"]["name"]);
        move_uploaded_file($_FILES["banner"]["tmp_name"], $banner);
        $url="https://onliinematkaplay.com/webadmin/";
        $furl = $url . $banner;
    }

    $update = $conn->prepare("UPDATE blog SET meta_title=?, meta_description=?, meta_keywords=?, page_name=?, title=?, description=?, blog_date=?, url=?, banner=? WHERE id=?");
    $success = $update->execute([
        $meta_title, $meta_description, $meta_keywords,
        $page_name, $title, $description, $blog_date, $url,
        $furl, $id
    ]);

    
        header("Location: blog.php"); // replace with your list page
        exit();
    
}
?>

<!-- HTML Form -->
<style>
.ck.ck-editor__main>.ck-editor__editable {
    background: #ebe8e8;
    border-radius: 0;
}
</style>

<div class="container-fluid">
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <form method="post" enctype="multipart/form-data">
                    <div class="card-body">
                        <h4 class="card-title">Edit Blog</h4>

                        <div class="form-group row">
                            <label class="col-sm-3 text-end">Meta Title</label>
                            <div class="col-sm-9">
                                <input type="text" class="form-control" name="meta_title"
                                    value="<?= $blog['meta_title'] ?>" required>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-sm-3 text-end">Meta Description</label>
                            <div class="col-sm-9">
                                <input type="text" class="form-control" name="meta_description"
                                    value="<?= $blog['meta_description'] ?>" required>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-sm-3 text-end">Meta Keywords</label>
                            <div class="col-sm-9">
                                <input type="text" class="form-control" name="meta_keywords"
                                    value="<?= $blog['meta_keywords'] ?>" required>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-sm-3 text-end">Page Name(PERMALINK)</label>
                            <div class="col-sm-9">
                                <input type="text" class="form-control" name="page_name"
                                    value="<?= $blog['page_name'] ?>" required>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-sm-3 text-end">Title</label>
                            <div class="col-sm-9">
                                <input type="text" class="form-control" name="title" value="<?= $blog['title'] ?>"
                                    required>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-sm-3 text-end">Description</label>
                            <div class="col-sm-9">
                                <textarea id="privacy_policy" name="description" class="form-control" rows="5"
                                    required><?= $blog['description'] ?></textarea>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-sm-3 text-end">Blog Date</label>
                            <div class="col-sm-9">
                                <input type="date" class="form-control" name="blog_date"
                                    value="<?= $blog['blog_date'] ?>" required>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-sm-3 text-end">URL</label>
                            <div class="col-sm-9">
                                <input type="url" class="form-control" name="url" value="<?= $blog['url'] ?>" required>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-sm-3 text-end">Banner</label>
                            <div class="col-sm-9">
                                <input type="file" class="form-control" name="banner">
                                <br>
                                <img src="<?= $blog['banner'] ?>" width="100">
                            </div>
                        </div>

                    </div>
                    <div class="border-top">
                        <div class="card-body">
                            <input type="submit" class="btn btn-primary" value="Update Blog">
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

<?php include('footer.php');
ob_end_flush();
 ?>
<script src='ckeditor.js'></script>
<script>
ClassicEditor.create(document.querySelector('#privacy_policy'))
    .catch(error => {
        console.error(error);
    });
</script>