setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("Database connection failed: " . $e->getMessage());
}
// User authentication
function check_login($pdo) {
if (!isset($_SESSION['user_id'])) {
header("Location: login.php");
exit();
}
}
// Handling file uploads for media library
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['upload'])) {
$target_dir = "uploads/";
$target_file = $target_dir . basename($_FILES["file"]["name"]);
if (move_uploaded_file($_FILES["file"]["tmp_name"], $target_file)) {
$stmt = $pdo->prepare("INSERT INTO media_library (file_name, file_path) VALUES (?, ?)");
$stmt->execute([basename($_FILES["file"]["name"]), $target_file]);
echo "File uploaded successfully.";
} else {
echo "File upload failed.";
}
}
// Fetch media library
$media_stmt = $pdo->query("SELECT * FROM media_library");
$media_files = $media_stmt->fetchAll(PDO::FETCH_ASSOC);
?>
Radio Automation Software
Radio Automation System
Media Library
Schedule Broadcast
Hot Keys