Picture Datatype

loureiro

Hi,

I am creating a database and i was just wondering if anyone could tell me which datatype i should use with MySQL to be able to upload pictures into my database. thanks

stolzyboy

have you gotten this working already, or are you just coming up with ideas to do it

the reason i ask is that it is not advisable to store the actual images in the database, simply store the path to the image in the db, then store the file in the filesystem

if you already have something going (codewise) you need to use the BLOB field type

loureiro

oh ok. how would i go about doing that?

loureiro

i havent done anything with the picture yet which is why im asking. i didnt want to go ahead and throw the picture in the wrong datatype.

stolzyboy

doing what, creating a file uploader, not many peeps here will
have the time to do the whole thing for you, but if you search the
forum for something like this, it has been done before

if you are asking about using a BLOB type, it is the same as if you
wanted a varchar type

loureiro

i understand how to upload it to a server. what i dont understand is how at the same time i would insert the location to the database

stolzyboy

oh, i see, check out the copy() function at php.net

these are ways to get information about the file to upload

and in the copy function you set the path name

then grab the path name and filename together and insert that

into the database

$name = $filetoupload_name; //name and path of file
$size = $filetoupload_size; //size of file
$type = $filetoupload_type; // type of file