file to mysql db

[BeBop]

How do i go about putting a file (from a submitted form, actually 2 files) into a database as a LONGBLOB... doesnt seem to be working for me the way im doing it so i have no clue... any help would be appreciated

[JonM]

lol how do u put a file period (from a submitted form) into a database, any one who answers this questions really wins i need to know!

[JonM]

answers bebobs first tho ... his thread sry m8 i realized after i had posted in your thread...

[BeBop]

lol thanks its ok tho... i think if no one answers me im gonna go picking through XMB's code to figure out how they did it lol... then *attempt* to do something similar

[Scott]

in your mysql query direct from $_POST use:,

mysql_query("INSERT INTO blah VALUES(NULL,LOAD_FILE('$_FILES['file']['tmp_name']'),'$value2')");

If you uploaded the file first, do a:

move_uploaded_file(soruce,destination.filename);

then

chmod(destination.filename,octdec("0777"));

then

mysql_query("INSERT INTO blah VALUES(NULL,LOAD_FILE('destination.filename'),'$value2')");

then

chmod(destination.filename,octdec("0644"));

To make it normal again.. As far as I know only 1 file per BLOB.

[BeBop]

ty panther i wuv u

yeah i know only one file per blob, i have 2 blobs... guess i worded that wrong

[BeBop]

blah... not workin

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/gamnet/www/scripts/mapdb.php on line 160

Query:
$sql = "INSERT INTO mapdb_maps VALUES ('$cid', 'null', '$name', '$author', '$description', LOAD_FILE('$_FILES['file']['tmp_name']'), LOAD_FILE('$_FILES['screen']['tmp_name']'), '$added', '0')";

[Scott]

Originally posted by BeBop
blah... not workin

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/gamnet/www/scripts/mapdb.php on line 160

Query:
$sql = "INSERT INTO mapdb_maps VALUES ('$cid', 'null', '$name', '$author', '$description', LOAD_FILE('$_FILES['file']['tmp_name']'), LOAD_FILE('$_FILES['screen']['tmp_name']'), '$added', '0')";

Sorry, rusty on php.

It's becase of the (' and then the 's in the $_FILES['. Type it like this:

$loadfile=$_FILES['file']['tmp_name'];
LOAD_FILE('$loadfile') or even LOAD_FILE('$_FILES["file"]["tmp_name"]')

[JonM]

one smart man panther lol ... time to make a file database! lol

[BeBop]

Couldnt add map to DBCan't get stat of '' (Errcode: 2)



this is the chunk of code

$added = date("Y-m-d");
$file = $_FILES['file']['tmp_name'];
$screen = $_FILES['screen']['tmp_name'];
$sql = "INSERT INTO mapdb_maps VALUES ('$cid', 'null', '$name', '$author', '$description',
LOAD_FILE('$file'), LOAD_FILE('$screen'), '$added', '0')";
mysql_query($sql) or die("Couldnt add map to DB".mysql_error());

[BOne]

panther seems on point...our humble leader lol

[Scott]

bebop, try moving the file to a specific location on the server using my example #2. And then remove the file after your done. Make sure you include the full path in there.

[BeBop]

will get on it and let you know, thanks for th econtoniued help

[zabb]

lol I thought i had a clue about MySql.
youre a bad mofo panther, and thanks for the scripts on your homesite. really makes hosting sigs very easy. and the shoutbox works great.