PHP网站音乐播放器完整实现

PHP网站音乐播放器完整实现

下面是一个完整的PHP网站音乐播放器实现方案，包含前端界面和后端PHP处理逻辑。

1. 数据库设计 (MySQL示例)

sql

CREATE TABLE `songs` ( `id` int() NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `artist` varchar(255) NOT NULL, `album` varchar(255) DEFAULT NULL, `file_path` varchar(512) NOT NULL, `duration` time DEFAULT NULL, `cover_image` varchar(512) DEFAULT NULL, `play_count` int(11) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

2. PHP后端代码 (player.php)

php

// 数据库连接$db = new PDO('mysql:host=localhost;dbname=music_db', 'username', 'password');// 获取所有歌曲function getAllSongs($db) { $stmt = $db->query("SELECT * FROM songs ORDER BY title"); return $stmt->fetchAll(PDO::FETCH_ASSOC);}// 获取单曲信息function getSongById($db, $id) { $stmt = $db->prepare("SELECT * FROM songs WHERE id = ?"); $stmt->execute([$id]); return $stmt->fetch(PDO::FETCH_ASSOC);}// 更新播放次数function updatePlayCount($db, $id) { $stmt = $db->prepare("UPDATE songs SET play_count = play_count + 1 WHERE id = ?"); $stmt->execute([$id]);}// 处理AJAX请求if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) { header('Content-Type: application/json'); switch ($_POST['action']) { case 'get_song': $song = getSongById($db, $_POST['id']); echo json_encode($song); exit; case 'update_play_count': updatePlayCount($db, $_POST['id']); echo json_encode(['success' => true]); exit; }}$songs = getAllSongs($db);?>DOCTYPE html> PHP音乐播放器title>