Upload Files!
in [Windows]
|
Prev: PHP and VB connectivity
Next: security for hersh site
From: Matthew Gonzales on 15 Apr 2008 09:50 Hello, I am wondering if anyone out might be able to point me in the right direction on uploading files from a website into MySQL Databses. I am trying to create a way for members to upload files and associate them with there user profile. What data type must I use. Thanks for your help in advance. Matt G -- Matthew Gonzales IT Professional Specialist Enterprise Information Technology Services University of Georgia Email: matt323(a)uga.edu <mailto:matt323(a)uga.edu> Phone: (706)542-9538
From: Jarrett Meyer on 15 Apr 2008 10:42 Files and all associated properties are saved in the $_FILES[] variable. From here, you can get the file name, file size, etc. I would recommend that you come up with your own name for the file. My code may not be right, but it will be close. $LocalFilePath = /path/to/local/files/ $LocalFileName = md5($_FILES[<formfield>]["name"]); // perform an action to save the file locally. Assuming that you have the user name from the session data, $Sql = "insert into UserFiles (User, Filename, Extension, Date) values ($_SESSION["user"] ,$LocalFileName ,$_FILE[<formfield>]["type"] ,time())"; Now you've got a database of all files saved by user. See http://us3.php.net/features.file-upload for more info about the $_FILES variable. Jarrett M Matthew Gonzales wrote: > Hello, > > I am wondering if anyone out might be able to point me in the right > direction on uploading files from a website into MySQL Databses. I am > trying to create a way for members to upload files and associate them > with there user profile. What data type must I use. Thanks for your help > in advance. > > Matt G > -- Jarrett M. T. Meyer, M.B.A. jmtmeyer(a)yahoo.com http://www.jarrettmeyer.com
From: "Jeremy O'Connor" on 18 Apr 2008 00:50 "Jarrett Meyer" <jmtmeyer(a)yahoo.com> wrote in message news:4804BEE3.9010105(a)yahoo.com... > Files and all associated properties are saved in the $_FILES[] variable. > From here, you can get the file name, file size, etc. > > I would recommend that you come up with your own name for the file. My > code may not be right, but it will be close. > > $LocalFilePath = /path/to/local/files/ > $LocalFileName = md5($_FILES[<formfield>]["name"]); > > // perform an action to save the file locally. > > Assuming that you have the user name from the session data, > > $Sql = "insert into UserFiles > (User, Filename, Extension, Date) > values > ($_SESSION["user"] > ,$LocalFileName > ,$_FILE[<formfield>]["type"] > ,time())"; > > Now you've got a database of all files saved by user. > > See http://us3.php.net/features.file-upload for more info about the > $_FILES variable. > > Jarrett M > > Matthew Gonzales wrote: >> Hello, >> >> I am wondering if anyone out might be able to point me in the right >> direction on uploading files from a website into MySQL Databses. I am >> trying to create a way for members to upload files and associate them >> with there user profile. What data type must I use. Thanks for your help >> in advance. Also the datatype can be BLOB, MEDIUMBLOB or LONGBLOB. Jeremy O'Connor --
From: "Michael Southworth" on 18 Apr 2008 05:21 At first blush, this article may be the best place to start. It has a complete example from start to finish. In addition to what has been stated here, you will need to properly SQL escape the data before inserting and un-escape it after fetching it from the database. http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html I'm no expert on SQL, but from what I have gathered from my experience, storing large binary files in a database has generally been a good way to slow down a database quickly, mostly because the entries become quite large, and causes the database size overall to get very large. Take a look at : http://aspnet.4guysfromrolla.com/articles/120606-1.aspx or http://www.onlamp.com/pub/a/onlamp/2002/07/11/MySQLtips.html #4 before you make any decisions on what path to go down. These were the first articles I could find on Google, there are probably better. HTH, -Mike On Thu, Apr 17, 2008 at 9:50 PM, Jeremy O'Connor <joconnor(a)netactive.co.za> wrote: > "Jarrett Meyer" <jmtmeyer(a)yahoo.com> wrote in message > news:4804BEE3.9010105(a)yahoo.com... > > Files and all associated properties are saved in the $_FILES[] variable. > > From here, you can get the file name, file size, etc. > > > > I would recommend that you come up with your own name for the file. My > > code may not be right, but it will be close. > > > > $LocalFilePath = /path/to/local/files/ > > $LocalFileName = md5($_FILES[<formfield>]["name"]); > > > > // perform an action to save the file locally. > > > > Assuming that you have the user name from the session data, > > > > $Sql = "insert into UserFiles > > (User, Filename, Extension, Date) > > values > > ($_SESSION["user"] > > ,$LocalFileName > > ,$_FILE[<formfield>]["type"] > > ,time())"; > > > > Now you've got a database of all files saved by user. > > > > See http://us3.php.net/features.file-upload for more info about the > > $_FILES variable. > > > > Jarrett M > > > > Matthew Gonzales wrote: > >> Hello, > >> > >> I am wondering if anyone out might be able to point me in the right > >> direction on uploading files from a website into MySQL Databses. I am > >> trying to create a way for members to upload files and associate them > >> with there user profile. What data type must I use. Thanks for your > help > >> in advance. > > Also the datatype can be BLOB, MEDIUMBLOB or LONGBLOB. > > Jeremy O'Connor > -- > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
|
Pages: 1 Prev: PHP and VB connectivity Next: security for hersh site |