saving images to a MySQL database

[Brad]

Demuro, I dont have time to answer all your questions but ill get a few.

ok so this I take it stores the info in a directory...Right?

Yes

what is the directory name?

Its defined here:

PHP Code:

$newfile = "/home/pathto/public_html/yourfoldername/".$userfile_name; 


Just change yourfoldername in the code to whatever you want

and is it possible to name the file manually, say by adding more form fields

I would recomend naming them with a md5 hash, its just that much secure. Check out scott's attachments as files hack. Im sure you can get the needed code from it.

is there a way do view the directory say through the SmartFTP program I use and if so how do I do that

of course, its lives on your server just like your forum directory

do I just add a php/MySQL insert staement to insert the name into my database and then use it as a pointer?

Yep

[DeMuro1]

I swear you guys have got to be the smartest lot in the universe. I so from your info anime loo I know how to do everything else I want.

Thank you all so very much
I am extremely greatful

[Gavin B.]

Today at 09:48 AM DeMuro1 said this in Post #12
I swear you guys have got to be the smartest lot in the universe.

:banana: I try my best lol

[Lesane]

07-07-03 at 02:25 PM Mist said this in Post #4
I've always wondered how people upload the files directly into the database though. I mean the attachments in vb aren't stored in a temporary directory are they?

I can create the form with a pointer to the file easily enough but uploading directly to the database is out of my league at the moment. Any tutorials or anything?

- miSt

Mist, this tutorial will probably help you:
http://www.devarticles.com/art/1/68

[Dean C]

Excellent Lesane - thankyou !

- miSt

[Lesane]

You're welcome, once you readed that tutorial you probably think 'aah never thought it would be that easy'

[DeMuro1]

last question I hope

if I modify this line

PHP Code:

&& $userfile_type == "image/jpg" 


to read

PHP Code:

&& $userfile_type == "image/file type I want" 


can I upload any type of file?

and if I add succesive strings of this

PHP Code:

&& $userfile_type == "image/file type I want" 


Then I should be able to upload multiple types of file.

is that right or does this upload only work with jpg images? If it does how can I allow it to upload gif images?

Thanks

and again can I I list you on my site as having written this portion or would you rather remain annonymous?

[Gavin B.]

Yes, you can change that to be whatever you like. Just be careful you don't allow any sort of files which could possibly be dangerous.

.gif, .png and jpg are the common extensions I would check for.

[Gavin B.]

Today at 10:32 AM DeMuro1 said this in Post #17
and again can I I list you on my site as having written this portion or would you rather remain annonymous?

It's only a snippet, I'm sure there's a zillion variations of it floating around, so personally I don't want credit for it. Hope it helped out though.

[Dean C]

Wow that upload script was easy to use. Only problem was that when uploading images only part of the image was uploaded so there's a little bug there. But apart from that i understand the concept

- miSt