Uploading multiple images with a form to server and storing file name in MySQL

[natie769]

I have a form that allows the user to upload multiple images (5 max).  This code works for me for uploading one image, but it doesn't work now that I'm trying to upload multiple images. 

 

It uploads the file names to the MySQL table perfectly, but it doesn't upload the image to the server.  Can anyone tell me where I've gone wrong -- thanks!!!

I'm assuming its something small I'm missing since it work for uploading just one image. 

 

 

Here is my form:

 

<form action="nextpage.php" method="post" enctype="multipart/form-data">

<table>
<tr>
<td valign="top">Upload Image: </td>

<td>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000"><input name="photo" type="file" size="30"><br />
<input type="hidden" name="MAX_FILE_SIZE" value="2000000"><input name="photo2" type="file" size="30"><br />
<input type="hidden" name="MAX_FILE_SIZE" value="2000000"><input name="photo3" type="file" size="30"><br />
<input type="hidden" name="MAX_FILE_SIZE" value="2000000"><input name="photo4" type="file" size="30"><br />
<input type="hidden" name="MAX_FILE_SIZE" value="2000000"><input name="photo5" type="file" size="30"></td>
</tr>
</table>

 

Here is the nextpage.php code:

 

<?php
$photo=($_FILES['photo']['name']);
$photo2=($_FILES['photo2']['name']);
$photo3=($_FILES['photo3']['name']);
$photo4=($_FILES['photo4']['name']);
$photo5=($_FILES['photo5']['name']);

//This is the directory where images will be saved
$target = "images/uploaded/";
$target = $target . basename( $_FILES['photo']['name']['photo2']['name']['photo3']['name']['photo4']['name']['photo5']['name']);

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name']['photo2']['tmp_name']['photo3']['tmp_name']['photo4']['tmp_name']['photo5']['tmp_name'], $target))
{

//Tells you if its all ok
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory";
}
else {

//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}

$database info

mysql_connect("$hostname", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="INSERT INTO `Listings` (`photo`, `photo2`, `photo3`, `photo4`, `photo5`) VALUES('".$photo."', '".$photo2."', '".$photo3."', '".$photo4."', '".$photo5."')";
$result=mysql_query($sql);

[inebula88]

I am working on a very similar code.  Were you able to get this to work?  If so, would you share you solution?

[natie769]

Yes I did, I had gotten a solution from this forum:

 

http://codingforums.com/showthread.php?t=160693

[inebula88]

Thanks for the link.  I actually started there and you and that thread were a big help.

The problem I have now is when I use

$sql="INSERT INTO `Listings` (`photo`, `photo2`, `photo3`, `photo4`, `photo5`) VALUES('".$photo."', '".$photo2."', '".$photo3."', '".$photo4."', '".$photo5."')";
$result=mysql_query($sql);

In my database it is writing the temporary path/name instead of the actual path/name.

Any ideas?