<?php
session_start();
ob_start(); // Start output buffering at the beginning
include("connection.php");
include("includes/header.php");
include("includes/sidebar.php");

$user_profile=$_SESSION['user_name'];
// if($user_profile==true){

// }else{
//     header('location:index.php');
// }
?>

<div class="app-main__outer">
                    <div class="app-main__inner">

                        <div class="app-page-title">
                            <div class="page-title-wrapper">
                                <div class="page-title-heading">
                                    <div class="page-title-icon">
                                    <i class="fas fa-tachometer-alt"></i>

                                    </div>
                                    <div>Admin Dashboard
                                        
                                    </div>
                                </div>
                                <div class="page-title-actions">
                                    <button type="button" data-toggle="tooltip" title="Example Tooltip" data-placement="bottom" class="btn-shadow mr-3 btn btn-dark">
                                        <i class="fa fa-star"></i>
                                    </button>
                                
                                </div>   
                             </div>
                         </div>

                         <div class="row"> 
    <div class="col-md-12">
        <div class="card mb-3">
            <div class="card-header">
                <strong>Add Category</strong>
            </div>
            <div class="card-body">
                <form action="" method="post" enctype="multipart/form-data">

                    <div class="form-group">
                        <label for="section_type">Category Type</label>
                        <select class="form-control" name="category" required>
                            <option value="">Select category Type</option>   
                            <option value="banner">Banner</option>
                            <option value="about">About</option>
                            <!-- <option value="product">Product</option> -->
                            <option value="why_choose1">Why_choose1</option>
                            <option value="why_choose2">Why_choose2</option>
                            <option value="testimonial">Testimonial</option>
                        </select>
                    </div>

                    <div class="form-group">
                        <label for="img">Image</label>
                        <input type="file" class="form-control" name="img">
                    </div>

                    <div class="form-group">
                        <label for="title"> Title</label>
                        <input type="text" class="form-control" name="title" placeholder="Enter Title">
                    </div>

                    <div class="form-group">
                        <label for="title"> Subtitle </label>
                        <input type="text" class="form-control" name="subtitle" placeholder="Enter Subtitle">
                    </div>

                    <div class="form-group">
                        <label for="description">Description</label>
                        <textarea class="form-control" name="description" rows="5" placeholder="Enter Description"></textarea>
                    </div>

                    <input type="submit" class="btn btn-primary" value="Submit" name="submit">
                </form>
            </div>
        </div>
    </div>
</div>

                    </div></div>

                    <?php
if (isset($_POST['submit'])) {
    // Sanitize input values
    $category = mysqli_real_escape_string($conn, $_POST['category']);
    $title = mysqli_real_escape_string($conn, $_POST['title']);
    $subtitle = mysqli_real_escape_string($conn, $_POST['subtitle']);
    $description = mysqli_real_escape_string($conn, $_POST['description']);
   
    // Initialize variables for image names
  
    $image_name = '';


    // Handle other image upload
    if (!empty($_FILES['img']['name'])) {
        $image_dir = "upload/"; // Directory for images
        $image_name = mysqli_real_escape_string($conn, $_FILES['img']['name']);
        $target_file = $image_dir . basename($image_name);

        // Move the uploaded file to the target directory
        if (!move_uploaded_file($_FILES['img']['tmp_name'], $target_file)) {
            echo "Error uploading image.";
            exit;
        }
    }

    // Prepare the SQL query to insert both images if they are uploaded
    $sql = "INSERT INTO homepage (category, title,subtitle, image, description) 
            VALUES ('$category', '$title', '$subtitle', '$image_name', '$description')";

    // Execute the SQL query
    $result = mysqli_query($conn, $sql);

    // Check if the query was successful
    if ($result) {
        // Redirect to the hostel view page on success
        header('location:view_homepage.php');
    } else {
        echo "Error adding About details: " . mysqli_error($conn);
    }
}

// Close the database connection
mysqli_close($conn);
?>

<?php
// Footer and output buffering
include("includes/footer.php");
ob_end_flush(); // Send the buffered output to the client
?>


