How to retriew video files from database???

[sangeetha]

HI all,

 I have uploaded one video file and i stored its path name into the database. when i tried to retriew it from the database, it din't get played. So i just wanna to know whether its possible, if so how to do it? Please help me out...:)

[Weedpacket]

It's possible (though usually there's not much point in storing binary data in the database). What did you try to do with it after you retrieved it?

[sangeetha]

yes, i just passed the path name to the database and i have provided the code here so just see it and help me out.🙂
<?php
$conn=mysql_connect("localhost","root","");
mysql_select_db("sangi");
echo $SERVER['REQUEST_METHOD'];
$r=$GET['r'];
if($r==1)
{
$target="sangi/";
$target=$target.basename($FILES['upfile']['name']);
$filename=basename($FILES['upfile']['name']);
if(move_uploaded_file($_FILES['upfile']['tmp_name'],$target))
{
echo "file uploaded sucessfully";
mysql_query("INSERT INTO sangi.det (sno ,filename)VALUES ('', '$filename')");
$rst=mysql_query("select * from det");
while($qry=mysql_fetch_array($rst))
{
?>
<a href="sangi/<?php echo $qry['filename']; ?>" > download </a>
<?php
echo "<br>";
}
mysql_close($conn);
}
}
?>
<form action="upload.php?r=1" method="post" enctype="multipart/form-data">
<input name="upfile" type="file">
<input type="submit" name="Submit" value="Submit">
</form>