Image Upload Into Mysql

[s_pam]

Hello !
How could i edit the code below to upload into a specified temp directory

eg: "/path/to/temp"

And not the servers "/tmp" directory ?

Any help would be greatly appreciated.

<------------------------>

if ($action == "upload")
{
if (isset($binFile) && $binFile != "none")
{
$data = addslashes(fread(fopen("$binFile", "r"), filesize($binFile)));
$strDescription = addslashes(nl2br($txtDescription));
$sql = "INSERT INTO tbl_Files ";
$sql .= "(description, bin_data, filename, filesize, filetype, owner, prop_num) ";
$sql .= "VALUES ('$strDescription', '$data', ";
$sql .= "'$binFile_name', '$binFile_size', '$binFile_type', '$current_user', '$propnum')";

				if (!mysql_query ($sql, $link) )
					{
					die (mysql_error());
					}

				echo "Your image has been added ($binFile_name).";

				}
			}

<------------------------>

[[deleted]]

Where PHP stores it's temp file is configured by the php.ini file, and has absolutely nothing to do with mysql at all.

http://www.php.net/manual/en/features.file-upload.php

[Anon]

Sorry, i should have said, my site is a virtual server and i cant edit the php.ini

When i try to upload a file at the moment the script tries to upload to the servers temp directory and i dont have permision to write there, php is in safemode too.

[[deleted]]

I suggest you talk to your host about that. Safe mode is controlled by them, you cannot override it (hence the name 'safe' mode)

[Anon]

i think youve missed the point. thanks anyway

[[deleted]]

Care to tell me just what the point is?

[sgbalsekar]

hi,

ideally php uploads the files into the /tmp area..but i presume all servers allow access to /tmp area..u cud either get it allowed ...or cud get the change in php.ini file where the area to which the image is to be uploaded is specified...

also instead of inserting the image in the database, you cud store it in an area with timestamp(YYYYMMDDHHMMSS.gif(which is available with date func)) as a filename (use copy fnc)....and store the name in the database...

u cud access the file using the name of the file....

hope this helps...

regs,
sachin balsekar.

[sgbalsekar]

if the temp dir /tmp is not available.

check using phpinfo() whats the upload_tmp_dir..if not specified / not accessible..

assign a value(path to a new area) to it and use it...

am sure this will work,

regs,
sachin balsekar

[[deleted]]

You may want to read the original post again.

When safe mode is in effect, you cannot change the php configuration. What would be the point of having safe mode if everyone can just overwrite it?

PS:
"also instead of inserting the image in the database, you cud store it in an area with timestamp(YYYYMMDDHHMMSS.gif)"

bad idea, not enough resolution. This will fail when to uploads happen within the same second. She's already using a database, so it is much better to use the a PK value generated by the database.