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
How we get ip address of client, previous reference page etc?
What is exception handling in php?
What are the string functions in php?
Which php framework is best for beginners?
How to block direct directory access in PHP?
What are the different errors in php?
What is difference between web service and api?
Suppose we receive a form submitted by a post to subscribe to a newsletter. This form has only one field, an input text field named email. How would we validate whether the field is empty? Print a message "the email cannot be empty" in this case?
What is the use of the function htmlentities?
What is the purpose of the php empty function?
How is php different from other languages?
Why namespace is used in php?
What is a variable cost example?
What is cookies? How to create cookies in php?
How can you execute php script from the command line?