How to Retrieve video files in php from database.....and how
to store video on database..
Answer Posted / dinesh
<?php
$dbhost = 'hostname';
$dbuser = 'database username';
$dbpass = ' database password';
$dbname = 'database name';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
mysql_select_db($dbname);
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
/*
echo "<br/>".$fileName;
echo "<br/>".$fileSize;
echo "<br/>".$fileType;
//echo "<br/>".$content;
*/
$query = "INSERT INTO table_name (name, size, type, content ) VALUES ('$fileName', '$fileSize', '$fileType', '$content')";
mysql_query($query) or die('Error, query failed');
mysql_close($conn);
echo "File $fileName uploaded";
}
?>
<form method="post" enctype="multipart/form-data">
<fieldset>
<legend> Upload Video/image</legend>
<table width="350" border="0" cellpadding="1" cellspacing="1" class="box">
<tr>
<td width="246">
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile" type="file" id="userfile">
</td>
<td width="80"><input name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
</tr>
</table>
</fieldset>
</form>
| Is This Answer Correct ? | 17 Yes | 8 No |
Post New Answer View All Answers
What is magic quotes?
How variables are passed through arguments?
Do csrf tokens expire?
What is the use of header in php?
How we can get the number of elements in an array?
What are the rules in creating php variable?
Which is the correct way to check if a session has already been started ?
What are different types of errors available in Php?
Explain me what is the goto statement useful for?
Tell me what is the main difference between require() and require_once()?
How to retrieve the original query string?
armstrong number by using php while number is given by the keyboard.?
What are new features in php 7?
Tell me what type of operation is needed when passing values through a form or an url?
Why do we show php code in browser?