uploading an image and inserting into mysql

toddmarx

I am really at a standstill. I cannot for the love of me figure this out...... I NEED HELP!

I need to be able to upload images to a website and have some info inserted into a mysql db (4 fields). I have tried several times and can almost get it to work but when uploading it puts into the server's temp dir, and then errors out when it goes to move it from the tmp dir to the website dir. I now that this is not an easy task and I would not expect someone to hammer out all the code (if you do I would be forever greatful), but a good steer in the right direction would be a really big help also! 😃

Thanks,
Todd

TheDefender

Two things...

1) Make sure your path is correct
2) Make sure you have write permissions to that folder you are trying to move the file into.

toddmarx

Yes, I have write permission (chmod is 777). Is there a way to upload it DIRECTLY into the directory without using my hosting company's tmp directory first. I have tried just about everything that I can think of......

TheDefender

Not really sure... I have only ever written an upload script once, and it worked fine... (actually, wrote it from a tutorial that used that method.)

Can you create a blank file in said directory using this method?
fopen ("/path/to/file.txt", "w+");

Hard code the path into the fopen function when you test this...

toddmarx

HA! Why did'nt I think of that!!

I'll give that a shot. It should work. I have the dir path hard coded into the script already, but whenever I try to upload it will not put it into my directory without putting it into the hosting company's temp dir first. This is what I am trying to avoid. I have contacted my hosting company about it and they said that for security reasons, they cannot allow me to move stuff from a temp directory to one of my dir. They told me to find a "workaround" for this and for a "nominal fee" they would be more than happy to assist me on this.....

Thanks again,
Todd

cnperry

I've created several upload scripts before and they all use the /tmp directory. From what I learned, that is just the way things work.

Try writing a simple script that uses the phpinfo(); function when $_POST[submit] has been set.

What you are looking for is the $_FILES array:

//'userfile' is the variable name from the form
$tmploc=$_FILES['userfile']['tmp_name']; //temporary name of the file when it is in the /tmp directory
$fname=$_FILES['userfile']['name']; //the actual name of the file on the client
$fsize=$_FILES['userfile']['size']; //file size $ftype=$_FILES['userfile']['type']; //file type
$ferror=$_FILES['userfile']['error'] //reports errors
$fpath="/some/path/to/the/final/destination/".$fname; //the location where your uploaded file will go (including file name). you can designate another $fname if you want to

//add some code to make sure the path exists or not, or that you won't be over-writing a file that you don't want to

if(copy($tmploc,$fpath)) echo "Good job";
else echo "Error... blah blah blah";
//$fpath is the location of the file on the server, which is going to be different than the actual url path

I hope this helps.

dnast

ini_set("upload_tmp_dir","/mypath/uploads/");

Could work, but I don't know. If not, let's see your code.