Jim I believe your correct.

Upload the file to temp
move the file to your dir on your server
and rename file
you can also set the permissions of the file while moving it.
put url to file (not temp file) in database (not the file contents)


On Jul 26, 2012, at 4:50 PM, Brad wrote:

I apologize, I may have been mistaken about the role of $_FILES but this -> http://dev.mysql.com/doc/refman/5.0/en/load-data.html confuses me. The use of $_FILES with LOAD DATA is littered over the internet and manuals as a 1
shot deal. No hand off to another directory for storage till the next
function gets to it.
Straight from remote drive to database in 1 single quick shot.

Yours may be a work around but I honestly want it to work correctly. I'll
delete the server prior to a left field hack to accommodate a failing
function.  :(

-----Original Message-----
From: Jim Giner [mailto:jim.gi...@albanyhandball.com]
Sent: Thursday, July 26, 2012 5:17 PM
To: Brad
Subject: Re: [PHP-DB] Re: No data?

you need to read up on how html uploads files and how php handles them.

You cannot just use the temp file (I may be wrong here, but in general one doesn't use it.). You need to use the $_FILES info in order to get the uploaded "temporary" file and save it permanently somewhere on your server. THEN you can use it and when through with it, you can choose to delete it. That's how it works. The code that I gave you days ago accomplishes exactly
that and it gets used regularly on my site, so I know that it works.

Please try it and then use an ftp client to connect to your server and see that the newly uploaded file is there. Then you can do what you wish with
On 7/26/2012 5:10 PM, Brad wrote:
I don't 'have' a file. It creates a temporary file and then deletes it
just as fast in /tmp/.
Plus, how would I $_GET it? $_FILES is supposed to handle 'ALL' of
this for me? If not, what the heck does it do?

Brad Sumrall
212 444-2996

-----Original Message-----
From: Jim Giner [mailto:jim.gi...@albanyhandball.com]
Sent: Thursday, July 26, 2012 5:02 PM
To: Brad
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Re: No data?

Not sure what you mean - "Program reads array". What program is doing is utilizing the FILES element to get the info about the uploaded file
and proceeds to finish the upload by moving it to a temporary folder
of your creation.  Once that is done you HAVE the file under whatever
name you want to call it in whatever folder you want it in.

Why don't you just do that part and then use some tool to look at your
server structure to verify that you have the file.

NOW you can proceed with the rest, if you must.  You're going to
create a table with a column/field name matching the filename and then you'll put the contents of that file into that single column in one record
of this table.
So now you have a one record table with one column holding the
contents of a file.  How is this different from just having the file?

1 User uploads file
2 program reads array
3 program creates a table called $memberID.$filename  if not exist
($filename is column)
4 program uploads data into table/column

I am messed up at #2 for some reason so #4 fails.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Karl DeSaulniers
Design Drumm

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to