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
Explain what is the difference between $var and $$var?
Which MySQL function would you use to select a database?
What is regex in html?
Which function is used in php to delete a file?
Are objects passed by value or by reference?
Is nan in php?
Is session a cookie?
What is get and post method in php?
What is magic function in php?
What is php data type?
Is laravel better than codeigniter?
How To Get the Uploaded File Information in the Receiving Script?
How to send email using php script?
What is php7?
What is php simple definition?