[Resolved] Storeing A video file in mysql

abman

hi, i'm trying to upload a video file into mysql,

basically i kno in php you use this code to read an image file before storeing it into mysql...

$data = addslashes(fread(fopen($image, "r"), filesize($image)));

butttttt when i try that line to read a video file, it doesnt work.... does anybody have a solution to how i can read a video file before storeing it into mysql? thanks!

Moonglobe

are you storing it as BLOB?

abman

yep i'm storeing it in a MEDIUMBLOB

maybl8r03

have you tried binary safe read?

$fileHandle = fopen($imagefile, "rb");

abman

yep, tried it, still dont work.... i think where the problem lies is... that i experimented a bit by outputting the data from a picture, then a video i.e.

$data = addslashes(fread(fopen($video, "r"), filesize($video)));
$data2 = addslashes(fread(fopen($image, "r"), filesize($image)));

print "video content = $data";
print "Picture content = $data2";

now when both get outputted the picture gets outputted fine.... and so does the video file as well... which means it does read the file.... but i've discovered a problem... when outputted, halfway through the video data, the font changed to bold and italic, so i'm thinking there must be a leak in the slashes bit... am i correct? or have i gone wrong elsewhere?

see what i've done is after reading the files i store them in my database using code:

$sql = "INSERT INTO videos (video, picture) VALUES ('$data','$data2')";

$result = mysql_query($sql,$db); etc etc and so forth.... but the problem is it doesnt execute that line....so i'm thinking there must be a leak in the slashing bit 😕

maybl8r03

The reason why it turns bold, italics halfway is not related to slashes - addslashes only escapes special characters but when you output it to HTML, the browser does not respond to the escapes - to trully see the giberish on the browser, you will have to see it translated using htmlentities(); For best effect add in a pair of "<pre></pre>" tags.

Back to the main question - on the read back of the blob from the db, I'm assuming you do a stripslashes to counter your initial addslashes?

Norman_Graham

I'm sure you know what you're doing, Abman, but is it entirely necessary to store the vid file in the DB? Wouldn't your life be a lot easier if you stored all the vid files in a folder and stored the paths to the individual files in the DB?

Just trying to save you stress

Norm