How to Retrieve video files in php from database.....and how
to store video on database..
Answer Posted / rajasekhar
it is same like how to store file's into database
<?php
if($_POST['submit'] == 'submit')
{
$filename = $_FILES['video']['name'];
$tmpname = $_FILES['video']['tmp_name'];
$source = "upload/"; // this is a
folder in our server or system
$distination = "upload/".$filename; // we are
uploading file in to our created folder
if($_FILES['video']['error'] == false)
{
move_uploaded_file($tmpname,$distination);
}
// using sql we are upload file name into database,
$sql = mysql_query("insert into file set filename =
'".$filename."' ");
if($sql)
{
echo "file uploaded to database successfully";
}
else
{
echo "Unable to upload file to database. ".mysql_error();
}
// Retriveing file from that database
$sql = mysql_query("select * from file");
$res = mysql_fetch_array();
echo "upload/".$res['filename']; //when you like to play
the video, you has to use Embed tag
}
?>
<form name="frm" action="<?php $_SERVER['PHP_SELF']; ?>"
method="post" enctype="multipart/form-data">
<input type="file" name="video" /><input type="submit"
name="submit" value="submit" />
</form>
| Is This Answer Correct ? | 17 Yes | 22 No |
Post New Answer View All Answers
What are the differences between echo and print?
Explain how to execute a php script using command line.
What is the difference between php and javascript?
What is lazy loading in php?
Which function would you use to read a line of data from a file in php?
Explain me what is the w3c?
Explain PHP?
What is http php?
how to track user logged out or not? when a user is idle?
What is difference between strstr() and stristr()?
What is regular expression in javascript?
Explain NULL?
Define metaphone()?
Is a number php?
What is string function sql?