在MySQL - HTML表中新建录音时播放蜂鸣音

CREATE TABLE recordings (
  id INT AUTO_INCREMENT PRIMARY KEY,
  filename VARCHAR(255) NOT NULL,
  path VARCHAR(255) NOT NULL,
  duration INT NOT NULL
);

<form action="upload.php" method="post" enctype="multipart/form-data">
  <input type="file" name="recording" accept="audio/*" required>
  <input type="submit" value="上传录音">
</form>

<?php
$filename = $_FILES['recording']['name'];
$tmp_path = $_FILES['recording']['tmp_name'];
$duration = // 获取录音时长的方法，可以使用音频处理库或API进行处理

// 将录音文件移动到指定目录
$upload_path = '/path/to/recordings/' . $filename;
move_uploaded_file($tmp_path, $upload_path);

// 将录音信息插入MySQL表
$conn = new mysqli('localhost', 'username', 'password', 'database');
$stmt = $conn->prepare("INSERT INTO recordings (filename, path, duration) VALUES (?, ?, ?)");
$stmt->bind_param('ssi', $filename, $upload_path, $duration);
$stmt->execute();

echo '录音上传成功！';
?>

var audio = new Audio('beep.mp3');
audio.play();