Untitled

<?php require "../includes/header.php"; ?>
<?php require "../config/config.php"; ?>

<?php

    $categories = $conn->query("SELECT * FROM categories");
    $categories ->execute();
    $category = $categories->fetchAll(PDO::FETCH_OBJ);





    if(isset($_POST['submit'])){
        if(empty($_POST['title']) OR empty($_POST['subtitle'])  OR empty($_POST['body']) OR empty($_POST['category_id']) ){
            echo 'input can not be empty';
        }else{

            $title = $_POST['title'];
            $subtitle = $_POST['subtitle'];
            $body = $_POST['body'];
            $category_id = $_POST['category_id'];
            $img = $_FILES['img']['name'];
            $user_id = $_SESSION['user_id'];
            $user_name = $_SESSION['username'];




            $dir = 'images/' .basename($img);

                $insert = $conn->prepare("INSERT INTO posts (title, subtitle, body, category_id, img, user_id, user_name)
                VALUES (:title, :subtitle, :body, :category_id, :img, :user_id, :user_name)");

                $insert->execute([
                    ':title' => $title,
                    ':subtitle' => $subtitle,
                    ':body' => $body,
                    ':category_id' => $category_id,
                    ':img' => $img,
                    ':user_id' => $user_id,
                    ':user_name' => $user_name,

            ]);


            //Will update this part._Shanto
            if(move_uploaded_file($_FILES['img']['tmp_name'], $dir)){
                //echo "done";
                header('location: http://localhost/Blog/index.php');
            }


        }
    }


?>



<form method="POST" action="create.php" enctype="multipart/form-data">
    <!-- Email input -->
    <div class="form-outline mb-4">
        <input type="text" name="title" id="form2Example1" class="form-control" placeholder="title" />

    </div>

    <div class="form-outline mb-4">
        <input type="text" name="subtitle" id="form2Example1" class="form-control" placeholder="subtitle" />
    </div>

    <div class="form-outline mb-4">
        <textarea type="text" name="body" id="form2Example1" class="form-control" placeholder="body"
            rows="8"></textarea>
    </div>

    <div class="form-outline mb-4">

        <select name="category_id" class="form-select" aria-label="Default select example">
            <option selected>Select Category</option>

            <?php foreach($category as $cat): ?>

            <option value=" <?php echo $cat->id; ?>"> <?php echo $cat->name; ?> </option>
            <?php endforeach; ?>
        </select>
    </div>


    <div class="form-outline mb-4">
        <input type="file" name="img" id="form2Example1" class="form-control" placeholder="img" />
    </div>


    <!-- Submit button -->
    <button type="submit" name="submit" class="btn btn-primary  mb-4 text-center">create</button>


</form>



<? require "includes/footer.php"; ?>