Currently, I am in the process of writing PHP code that will be used to both upload and display a Quicktime .mov file by interacting with MySQL. While I have had success with working on similar tasks involving image formats in the past, this particular circumstance is proving to be challenging. The file upload function seems to be functioning correctly as data is being inserted into the SQL table and the client is able to access the viewvideo.php script. However, there arises an issue when the client attempts to parse the received data as a Quicktime movie, suggesting a potential decoding error along the way. Here are key snippets from the two scripts:
The uploading portion:
$name = $_FILES["file"]["tmp_name"];
$contents = file_get_contents($name);
mysql_query("INSERT INTO videos(id,data,title,description) VALUES($n,'$contents','$title','$description')");
The displaying part:
$x = mysql_query("SELECT data FROM videos WHERE id=$id");
$results = mysql_fetch_array($x);
$data = $results[0];
header("Content-Type: video/quicktime");
echo $data;
exit;
My initial theory is that enclosing '$contents' in single quotes may be causing issues with encoding the string properly. Due to maintenance work on the SQL server currently underway, I am unable to immediately test this hypothesis. Any suggestions or assistance would be greatly appreciated.