connect_error) {
die("Database connection failed: " . $conn->connect_error);
}
// ===============================
// HANDLE FORM SUBMISSION
// ===============================
$message = "";
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$title = $_POST['title'] ?? '';
$content = $_POST['content'] ?? '';
$author_name = $_POST['author_name'] ?? '';
$author_bio = $_POST['author_bio'] ?? '';
$post_date = $_POST['post_date'] ?? '';
// Handle image upload
if (isset($_FILES['post_image']) && $_FILES['post_image']['error'] == 0) {
$upload_dir = 'uploads/';
if (!is_dir($upload_dir)) mkdir($upload_dir, 0777, true);
$image_name = time() . "_" . basename($_FILES['post_image']['name']);
$target_file = $upload_dir . $image_name;
if (move_uploaded_file($_FILES['post_image']['tmp_name'], $target_file)) {
$image_url = $target_file;
} else {
$message = "Failed to upload image.
";
}
} else {
$message = "Please upload an image.
";
}
// Insert into database
if (!empty($title) && !empty($content) && !empty($author_name) && !empty($author_bio) && !empty($post_date) && isset($image_url)) {
$stmt = $conn->prepare("INSERT INTO blog_posts (title, content, author_name, author_bio, post_date, image_url) VALUES (?, ?, ?, ?, ?, ?)");
$stmt->bind_param("ssssss", $title, $content, $author_name, $author_bio, $post_date, $image_url);
if ($stmt->execute()) {
$message = "News submitted successfully!
";
} else {
$message = "Error: " . $stmt->error . "
";
}
$stmt->close();
} else if (empty($message)) {
$message = "Please fill in all required fields.
";
}
}
?>
Submit News