// Fetch categories
$categoriesQuery = "SELECT * FROM categories WHERE categories_status = 1";
$categoriesResult = mysqli_query($con, $categoriesQuery);
// Fetch sub-categories based on category selection
$subCategoriesResult = [];
if (isset($_GET['category_id'])) {
$categoryId = intval($_GET['category_id']);
$subCategoriesQuery = "SELECT * FROM sub_categories WHERE categories_id = $categoryId AND sub_categories_status = 1";
$subCategoriesResult = mysqli_query($con, $subCategoriesQuery);
}
// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$blogCategoriesId = intval($_POST['blog_categories_id']);
$blogSubCategoriesId = intval($_POST['blog_sub_categories_id']);
$blogTitle = mysqli_real_escape_string($con, $_POST['blog_title']);
$blogShortDescription = mysqli_real_escape_string($con, $_POST['blog_short_discription']);
$blogDescription = mysqli_real_escape_string($con, $_POST['blog_discription']);
// Handle image upload
$blogImage = '';
if (isset($_FILES['blog_image']['name']) && $_FILES['blog_image']['error'] == 0) {
$uploadDir = './img/blogs/';
$blogImage = basename($_FILES['blog_image']['name']);
move_uploaded_file($_FILES['blog_image']['tmp_name'], $uploadDir . $blogImage);
}
$sql = "INSERT INTO blog_posts (blog_categories_id, blog_sub_categories_id, blog_image, blog_title, blog_short_discription, blog_discription, blog_status, likes, blog_views, created_by, updated_by)
VALUES ($blogCategoriesId, $blogSubCategoriesId, '$blogImage', '$blogTitle', '$blogShortDescription', '$blogDescription', 3, 0, 0, 1, 1)";
if (mysqli_query($con, $sql)) {
echo "";
} else {
echo "";
}
}
?>
Create Blog Post
Create New Blog Post
