real_escape_string($_POST['title']); // New Field $category = $_POST['category']; $target_dir = "../assets/gallery/"; if (!file_exists($target_dir)) { mkdir($target_dir, 0777, true); } $file_name = time() . "_" . basename($_FILES["image"]["name"]); $target_file = $target_dir . $file_name; if (move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) { $db_path = "assets/gallery/" . $file_name; // Save Title to DB $conn->query("INSERT INTO gallery (image_path, category, title) VALUES ('$db_path', '$category', '$title')"); $msg = "Image Uploaded Successfully!"; } else { $msg = "Upload Failed."; } } // Handle Delete if (isset($_GET['delete'])) { $id = $_GET['delete']; $conn->query("DELETE FROM gallery WHERE id=$id"); header("Location: gallery.php"); } ?> Manage Gallery

Upload New Image

$msg

"; ?>
query("SELECT * FROM gallery ORDER BY id DESC"); while($row = $result->fetch_assoc()) { echo '
'; echo ''; echo '
'; echo '

'.$row['title'].'

'; echo '

'.$row['category'].'

'; echo '
'; echo 'X'; echo '
'; } ?>