How can PHP be used to copy, delete, or move MPEG files based on a link stored in a database?

To copy, delete, or move MPEG files based on a link stored in a database, you can use PHP to retrieve the link from the database, then use file handling functions like copy(), unlink(), or rename() to perform the desired action on the file. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// Retrieve the link from the database
$sql = "SELECT file_link FROM files WHERE id = 1";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$file_link = $row['file_link'];

// Copy the file to a new location
$source = '/path/to/source/' . basename($file_link);
$destination = '/path/to/destination/' . basename($file_link);
copy($source, $destination);

// Delete the original file
unlink($source);

// Move the file to a different location
$source = '/path/to/source/' . basename($file_link);
$destination = '/path/to/new/destination/' . basename($file_link);
rename($source, $destination);

// Close the database connection
$conn->close();

Keywords

PHP file manipulation database link MPEG files copy/delete/move

Related Questions