<?php
include 'db.php'; // Ensure this file sets up $conn correctly

// Define target directory
$imageDir = "assets/images/blog/";

// Get file path
$imageFile = $imageDir . basename($_FILES["image"]["name"]);

// Move uploaded image file
if (move_uploaded_file($_FILES["image"]["tmp_name"], $imageFile)) {
    // Escape file path for SQL
    $imagePath = $conn->real_escape_string($imageFile);

    // Insert into database
    $sql = "INSERT INTO print_media (image_name) VALUES ('$imagePath')";
    if ($conn->query($sql) === TRUE) {
        echo "Image uploaded and saved successfully!";
        header("Location:add_news.php");
        exit(); // Important to stop further execution after redirect
    } else {
        echo "Database error: " . $conn->error;
    }
} else {
    echo "File upload failed.";
}

$conn->close();
?>