如何通過(guò) PHP 上傳視頻文件并通過(guò)數(shù)據(jù)庫(kù)條目將它們保存在適當(dāng)?shù)奈募A中

簡(jiǎn)介

為了有效管理網(wǎng)站上的視頻上傳，您需要實(shí)現(xiàn)一個(gè)系統(tǒng)，允許用戶上傳視頻，將它們存儲(chǔ)在有組織的文件夾中，并在數(shù)據(jù)庫(kù)中跟蹤其元數(shù)據(jù)。本指南將提供使用 PHP 和 MySQL 實(shí)現(xiàn)此目的的全面解決方案。

HTML 表單

創(chuàng)建一個(gè)允許用戶選擇和上傳視頻文件的 HTML 表單：

<code class="html"><form method="post" enctype="multipart/form-data">
  <div class="form-group">
    <label for="file">Select Video File:</label>
    <input type="file" name="file" id="file" accept="video/*" required>
  </div>
  <div class="form-group">
    <label for="course">Course:</label>
    <select name="course" required>
      <option value="select">Select Course</option>
      <option value="java">Java</option>
      <option value="python">Python</option>
      <option value="vb">Visual Basic</option>
      <option value="c">C/C++</option>
      <option value="ruby">Ruby</option>
    </select>
  </div>
  <input type="submit" name="submit" value="Upload">
</form></code>

PHP 處理程序

現(xiàn)在，讓我們編寫(xiě) PHP 腳本來(lái)處理文件上傳和數(shù)據(jù)庫(kù)輸入：

<code class="php"><?php

// Set destination folder and allowed file extensions
define('DESTINATION_FOLDER', 'videos/');
$allowedExtensions = ['mp4', 'webm', 'avi', 'mov'];

// Database settings
$host = 'localhost';
$database = 'video_database';
$username = 'user';
$password = 'password';

// Connect to database
$conn = new mysqli($host, $username, $password, $database);
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

// Process file upload
if (isset($_POST['submit'])) {

  // Get file details and validate extension
  $fileName = $_FILES['file']['name'];
  $fileSize = $_FILES['file']['size'];
  $fileExtension = pathinfo($fileName, PATHINFO_EXTENSION);
  if (!in_array($fileExtension, $allowedExtensions)) {
    echo "Invalid file format. Please upload a valid video file.";
    exit;
  }

  // Check if there are any upload errors
  if ($_FILES['file']['error'] > 0) {
    echo "Error uploading file.";
    exit;
  }

  // Move file to destination folder
  $fileDestination = DESTINATION_FOLDER . $fileName;
  if (move_uploaded_file($_FILES['file']['tmp_name'], $fileDestination)) {

    // Insert file details into database
    $course = $_POST['course'];
    $uploadDate = date("Y-m-d H:i:s");

    $sql = "INSERT INTO video_uploads (video_name, course, upload_date) VALUES ('$fileName', '$course', '$uploadDate')";

    if ($conn->query($sql)) {
      echo "File uploaded successfully. Database entry added.";
    } else {
      echo "Error adding database entry.";
    }
  } else {
    echo "Error moving file to destination.";
  }
}

$conn->close();</code>

此代碼將自動(dòng)根據(jù)所選課程將視頻文件組織到子文件夾中，并添加包含文件詳細(xì)信息的數(shù)據(jù)庫(kù)條目。

以上是如何在 PHP 和 MySQL 中使用文件夾組織和數(shù)據(jù)庫(kù)條目處理視頻上傳？的詳細(xì)內(nèi)容。更多信息請(qǐng)關(guān)注PHP中文網(wǎng)其他相關(guān)文章！