관리-도구

편집 파일: add-blog.php

<!DOCTYPE html>
<html lang="en" dir="ltr">

<head>
    <?php include('include/head_admin.php');

$title = '';
    $short_description = '';
    $image = '';
    $image_alt_tag = '';
    $description = '';
    $url = '';
    $author = '';
    $meta_title = '';
    $meta_description = '';
    $keyword = '';
    $canonical_tag = '';

if (isset($_GET['id']) && $_GET['id'] != '') {
        $id = get_safe_value($con, $_GET['id']);
        $image_required = '';
        $res = mysqli_query($con, "select * from blogs where id='$id'");
        $check = mysqli_num_rows($res);
        if ($check > 0) {
            $row = mysqli_fetch_assoc($res);
            $title = $row['title'];
            $short_description = $row['short_description'];
            $image = $row['image'];
            $image_alt_tag = $row['image_alt_tag'];
            $description = $row['description'];
            $url = $row['url'];
            $author = $row['author'];
            $meta_title = $row['meta_title'];
            $meta_description = $row['meta_description'];
            $keyword = $row['keyword'];
            $canonical_tag = $row['canonical_tag'];
        } else {
            header('location:all-blog.php');
            die();
        }
    }

if (isset($_POST['submit_blog'])) {
        // prx($_POST);
        $title = get_safe_value($con, $_POST['title']);
        $short_description = get_safe_value($con, $_POST['short_description']);
        $image_alt_tag = get_safe_value($con, $_POST['image_alt_tag']);
        $description = get_safe_value($con, $_POST['description']);
        $author = get_safe_value($con, $_POST['author']);
        $meta_title = get_safe_value($con, $_POST['meta_title']);
        $meta_description = get_safe_value($con, $_POST['meta_description']);
        $keyword = get_safe_value($con, $_POST['keyword']);
        $canonical_tag = get_safe_value($con, $_POST['canonical_tag']);

if (isset($_GET['id']) && $_GET['id'] == 0) {
            if ($_FILES['image']['type'] != 'image/png' && $_FILES['image']['type'] != 'image/jpg' && $_FILES['image']['type'] != 'image/jpeg' && $_FILES['image']['type'] != 'image/webp') {
                $msg = "Please select only png, jpg, webp and jpeg image format";
            }
        } else {
            if ($_FILES['image']['type'] != '') {
                if ($_FILES['image']['type'] != 'image/png' && $_FILES['image']['type'] != 'image/jpg' && $_FILES['image']['type'] != 'image/jpeg' && $_FILES['image']['type'] != 'image/jpeg') {
                    $msg = "Please select only png, jpg, webp and jpeg image format";
                }
            }
        }

$msg = "";

if ($msg == '') {
            if (isset($_GET['id']) && $_GET['id'] != '') {
                $url = get_safe_value($con, $_POST['url']);
                if ($_FILES['image']['name'] != '') {
                    $image =  $_FILES['image']['name'];
                    move_uploaded_file($_FILES['image']['tmp_name'], "../media/blogs/" . $image);
                    mysqli_query($con, "UPDATE `blogs` SET `title`='$title',`short_description`='$short_description', `image`='$image',`image_alt_tag`='$image_alt_tag',`description`='$description', `url`='$url',`author`='$author',`meta_title`='$meta_title',`meta_description`='$meta_description',`keyword`='$keyword',`canonical_tag`='$canonical_tag' WHERE `id`='$id'");
                } else {
                    $update_query = "UPDATE `blogs` SET `title`='$title',`short_description`='$short_description', `image`='$image',`image_alt_tag`='$image_alt_tag',`description`='$description', `url`='$url',`author`='$author',`meta_title`='$meta_title',`meta_description`='$meta_description',`keyword`='$keyword',`canonical_tag`='$canonical_tag' WHERE `id`='$id'";

mysqli_query($con, $update_query);
                }
            } else {
                $url = generate_seo_friendly_title($title);
                $image = rand(111111111, 999999999) . '_' . $_FILES['image']['name'];
                move_uploaded_file($_FILES['image']['tmp_name'], "../media/blogs/" . $image);
                $insert_query = "INSERT INTO `blogs`(`title`, `short_description`, `image`,`image_alt_tag`, `description`, `url`, `author`, `meta_title`,`meta_description`, `keyword`, `canonical_tag`) 
        VALUES ('$title','$short_description', '$image','$image_alt_tag','$description','$url', '$author', '$meta_title','$meta_description','$keyword','$canonical_tag')";
                mysqli_query($con, $insert_query);
            }
            header('location:all-blog.php');
            die();
        }
    }

function generate_seo_friendly_title($title)
    {
        // Convert the title to lowercase
        $title = strtolower($title);

// Replace spaces with dashes
        $title = str_replace(' ', '-', $title);

// Remove special characters
        $title = preg_replace('/[^A-Za-z0-9\-]/', '', $title);

return $title;
    }
    ?>
</head>

<div class="page-wrapper compact-wrapper" id="pageWrapper">
        
        <?php include('include/header_admin.php'); ?>

<div class="page-body-wrapper">
            
            <?php include('include/sidebar_admin.php'); ?>

<div class="container-fluid">
                    <div class="row">
                        <div class="col-12">
                            <div class="row">
                                <div class="col-sm-8 m-auto">
                                    <div class="card">
                                        <div class="card-body">
                                            <div class="card-header-2">
                                                <h5>Blog Details</h5>
                                            </div>
                                            <form method="post" enctype="multipart/form-data">
                                                <div class="theme-form theme-form-2 mega-form">
                                                    <?php if ($url != '') { ?>
                                                        <div class="mb-4 row align-items-center">
                                                            <label class="form-label-title col-sm-3 mb-0">Blog Url</label>
                                                            <div class="col-sm-9">
                                                                <input class="form-control" name="url" type="text" placeholder="Blog Url" value="<?php echo $url ?>">
                                                            </div>
                                                        </div>
                                                    <?php } ?>
                                                    <div class="mb-4 row align-items-center">
                                                        <label class="form-label-title col-sm-3 mb-0">Blog Author</label>
                                                        <div class="col-sm-9">
                                                            <input class="form-control" name="author" type="text" placeholder="Blog Author" value="<?php echo $author ?>">
                                                        </div>
                                                    </div>
                                                    <div class="mb-4 row align-items-center">
                                                        <label class="form-label-title col-sm-3 mb-0">Blog Title</label>
                                                        <div class="col-sm-9">
                                                            <input class="form-control" name="title" type="text" placeholder="Blog Title" value="<?php echo $title ?>">
                                                        </div>
                                                    </div>
                                                    <div class="mb-4 row align-items-center">
                                                        <label class="form-label-title col-sm-3 mb-0">Short Description</label>
                                                        <div class="col-sm-9">
                                                            <input class="form-control" name="short_description" type="text" placeholder="Short Description" value="<?php echo $short_description ?>">
                                                        </div>
                                                    </div>

<div class="mb-4 row align-items-center">
                                                        <label class="col-sm-3 col-form-label form-label-title">Blog Image</label>
                                                        <div class="form-group col-sm-9">
                                                            <input class="form-control" type="file" name="image" placeholder="Blog Image" value="<?php echo $image ?>" <?php echo $image ?>>

<?php
                                                            if ($image != '') {
                                                                echo "<a target='_blank' href='" . "../media/blogs/" . $image . "'><img width='150px' src='" . "../media/blogs/" . $image . "'/></a>";
                                                            }
                                                            ?>
                                                        </div>

</div>

<div class="mb-4 row align-items-center">
                                                        <label class="col-sm-3 col-form-label form-label-title">Image Alt Text</label>
                                                        <div class="form-group col-sm-9">
                                                            <input class="form-control" type="text" name="image_alt_tag" <?php echo $image_alt_tag ?> placeholder="Image Alt Text" value="<?php echo $image_alt_tag ?>">

</div>
                                                    </div>
                                                    <div class="row">
                                                        <label class="form-label-title col-sm-12 mb-0">Product
                                                            Description</label>
                                                        <div class="col-sm-12">
                                                            <textarea id="editor" name="description"><?php echo $description ?></textarea>
                                                        </div>
                                                    </div>

</div>
                                                <div class="card">
                                                    <div class="card-body">
                                                        <div class="card-header-2">
                                                            <h5>Search Engine Listing</h5>
                                                        </div>

<div class="mb-4 row align-items-center">
                                                            <label class="form-label-title col-sm-3 mb-0">Meta title</label>
                                                            <div class="col-sm-9">
                                                                <input class="form-control" name="meta_title" value="<?= $meta_title ?>" type="text" placeholder="Meta title">
                                                            </div>
                                                        </div>

<div class="mb-4 row">
                                                            <label class="form-label-title col-sm-3 mb-0">Meta
                                                                Description</label>
                                                            <div class="col-sm-9">
                                                                <textarea class="form-control" name="meta_description" rows="3"><?= $meta_description ?></textarea>
                                                            </div>
                                                        </div>
                                                        <div class="mb-4 row">
                                                            <label class="form-label-title col-sm-3 mb-0">Keyword</label>
                                                            <div class="col-sm-9">
                                                                <input class="form-control" name="keyword" value="<?= $keyword ?>" type="text" placeholder="Keyword">
                                                            </div>
                                                        </div>
                                                        <div class="mb-4 row">
                                                            <label class="form-label-title col-sm-3 mb-0">Canonical Tag</label>
                                                            <div class="col-sm-9">
                                                                <input class="form-control" name="canonical_tag" value="<?= $canonical_tag ?>" type="text" placeholder="Canonical Tag">
                                                            </div>
                                                        </div>

</div>
                                                </div>
                                                <button class="btn btn-solid" name="submit_blog" type="submit">Submit</button>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<?php include('include/footer_admin.php'); ?>
                
            </div>
            
        </div>
        
    </div>

<?php include('include/foot_admin.php'); ?>
</body>

</html>