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 is difference between rest api and restful api?
Is rent a variable cost?
How to create an array in php?
What is the purpose of the '.myd' file extension? What do thes file contain?
What is mysql_fetch_array?
Why do we use javascript in php?
What is the scope of a variable defined in a function?
What is difference between ksort() and usort() functions.
How to avoid the undefined index error?
What is string function sql?
Which function gives us the number of affected entries by a query?
How to find datatype of variable in php?
What does $_server means?
What is mysql_fetch_row?
Can I run php without xampp?