Upload file and insert location into database.

daveyc

Hi Guys,

I'm looking at making a simple news script to allow me specify the following..

News title, subtitle, news text, and an image.

Now, making the form and the database isn't a problem, as bringing the data back out with a php script isn't either.

My problem lies in the upload form, at the moment i'm using the one page with an "INSERT INTO" command to enter the news data and that is working fine, but what code would i need to use to deal with the image upload, and to enter the location of the file into the database also?

The database table is called "news" and the columns are:

headline, subline, text, imageurl and ID also.

Any ideas?

Thanks so much 🙂

Dave

bradgrafelman

Have you already tried searching the boards? Seems like this question is asked a lot.

Either way, all you'd do is establish an organization method - e.g. inserting the news data, gravving the ID generated, naming the file (IDNumber)_(OriginalFilename).(extension) or a random name or... whatever. Then, just use [man]move_uploaded_file/man to move it to the proper place with the proper name. Then you can run an UPDATE query and set the imageurl to the new path/filename.

daveyc

Hi bradgrafelman,

I did do a search, however i was a bit confused with certian things.

At the moment, my form (index.php) sends data to (addnews.php) using "application/x-www-form-urlencoded". From there addnews php uses the $_GET['whatever'] function to populate the INSERT INTO variables.

What i was worried about was problems cropping up because i'm submitting text in that way and then having it upload an image at the same time.

It's really confusing me.

Thanks,

Dave

bradgrafelman

daveyc wrote:
What i was worried about was problems cropping up because i'm submitting text in that way and then having it upload an image at the same time.

Doesn't matter what else you're uploading - the $_FILES array is separate than everything else.

Sounds like you should take a gander at the [man]features.file-upload[/man] manual page to sort out the basic mechanism of uploading a file.