Multiple Uploads and inserts into db, where to start?

[danielhalawi]

Hi,

I'm running a website on data in my mysql db.
I want to know where to start for making an user friendly upload page for my site.

The main aim of the upload will be the following.

1. Uploading Images & Videos via FTP

2. Passing the information about uploaded files to the next part of the upload script

3. Inserting the person/checking to see if that person exists on db & Adding the information about uploaded files to the persons record

4. Inserting information related to the user in a different table
   [/list=1]

   I am gratefull for any help.

   Cheers Dan

[BuzFortuna]

$dir = 'c:/apache/htdocs/uploads/';
		$file = $dir . basename($_FILES['FILENAME']['name']);
		if (move_uploaded_file($_FILES['FILENAME']['tmp_name'], $file)) {
		}

To upload start by using that. Change $dir to the EXACT path (not relative) to your upload folder, and change FILENAME to whatever the browse input field was on your form (it's name). This will upload the file. If you want to use more then one file on one form, just copy that again and change the variable names to like $dir2 and $file2 or something different.

Use if statements to check for the user (I assume you know how... if not post.. I have to be breif because school almost over and I have to catch the bus.

Then to insert the filename they just uploaded, use $FILES['FILENAME']['name'] for it's name. You can call it later by something like <img src="<?php echo "uploads/$FILES['FILENAME']['name']"; ?>

Sorry, bell rang, gotta go, ask any more questions and I'll help you out.

[danielhalawi]

Thanx for that I got it working perfectly, minor adjustment needed though.

Right basically I have I created a form page that details how I want the page to work. The image upload doesn't work at the moment for security purposes.

My Submittion Page

Its very self explainitory, I just need some advice on where to start, basically, I want the user to be able to insert onto two different tables.

There is two potential paths the user can go.

1. Insert New Artist & Video

2. Insert just a video for an artist already on the table
   [/list=1]

   Insert New Artist & Video
   The following will be the procedure for this action

   1. Selecting Images from computer to be uploaded

   2. Inserting names of images into the associated fields in artist information

   3. Inserting Information about the artist into the rest of the form

   4. Giving the artist an ID on the table

   5. Inserting artist 'id' into the video part of the form

   6. inserting information about the video into the form
      [/list=1]

      Insert just a video for an artist already on the table
      The following will be the procedure for this action

      1. Selecting artist from the drop down box

      2. Artist Information Displayed into Fields of the ArtistInformation Feild, uneditable

      3. Inserting Artist 'id' into Artistname area on video submittion

      4. Inserting information about video into feild

      5. Submitting to tables
         [/list=1]

[BuzFortuna]

Looks fine to me! What exactly do you need help with?

[travelbuff]

First, I would never, ever allow an upload without validating the file type AND renaming the file.

Ok, on to your question. I would do the form in multiple parts. First have the user select an existing artist or "new" from a dropdown box, then reload the form and handle the data accordingly.

You could do it all in one step using javascript but since that is client side I wouldn't rely on it.

[danielhalawi]

Ok I've actually, worked on it for a bit longer, and have now been able to create the insertion for an existing user and new video.
However just got a problem when I click on submit I get the following errors:

Warning: mysql_connect(): Access denied for user: 'root@localhost' (Using password: NO) in /home/.sites/107/site221/web/test-****.php on line 18

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/.sites/107/site221/web/test-****.php on line 19

However all the information goes onto the table?
Whats this about?

ACTUALLY FIGURED IT OUT, I HAD COPY AND PASTED A CODE, FORGETTING THAT MY PAGE WAS ALREADY CONNECTING, AND IN THE CODE IT WAS TRYIN TO CONNECT AGAIN! DUH!