Multi Photo Upload

[Anon]

Hello all-

Have the following code, and I want to take the array of names more likely 1-10 photo's I am uploading and want them to be saved as a formname.formname_1 -10.jpg etc. How would I convert the array to rename these photo's appropriately and ten save into the photo1 through 10 position in my sql insert call? Any help is greatly appreciated.

I'm thinking $photo1=photo_1.jpg etc.. just not sure what functions to use? ereg_replace or?

<-Form.html->
<form method="post" action="upload.php" enctype="multipart/form-data">
<input name="userfile[]" type="file">
<input name="userfile[]" type="file">
<input name="userfile[]" type="file">
<input name="userfile[]" type="file">
<input name="userfile[]" type="file">
<input name="userfile[]" type="file">
<input type="submit" value="Upload!!!" >
</form>

<-Upload.php->
<?
for($i=0;$i<sizeof($userfile);$i++)
{
if(!$userfile_size[$i])
continue;

$UPLOAD = fopen( $userfile[$i], "r" );
$contents = fread( $UPLOAD,$userfile_size[$i]);
fclose( $UPLOAD );
$SAVEFILE = fopen( "upload//".$userfile_name[$i], "wb" );
fwrite( $SAVEFILE, $contents,$userfile_size[$i] );
fclose( $SAVEFILE );
}
@ $db = mysql_pconnect("localhost", "root", "");

if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}

mysql_select_db("waterfront");
$query = "insert into waterfront values ('".$agent_id."', '".$layout."', '".$page."', '".$position."', '".$text."', '".$address."', '".$city."', '".$state."', '".$zip."', '".$bedrooms."', '".$bathrooms."', '".$price."', '".$mls."', '".$instructions."', '".$userfile_name."', '".$photo2."', '".$photo3."', '".$photo4."', '".$photo5."', '".$photo6."', '".$photo7."', '".$photo8."', '".$photo9."', '".$photo10."')";
$result = mysql_query($query);
if ($result)
echo "Server HaD Receive the Upload Files!";
?>

[Anon]

// i did'nt test, but it's the main idea that counts //

<-Form.html->
<form method="post" action="upload.php" enctype="multipart/form-data">
<?
$upload_files="6";
while($x<=$upload_files)
{
<input name="userfile_$x" type="file">
$x++;
}
$x=0;
?>
<input type="submit" value="Upload!!!" >
</form>

<-Upload.php->
<?
if($submit)
{
while($x<=$upload_files)
{
$file_name=stripslashes(${"user".$x."file_name"});
$file_name=ereg_replace(" ","",$file_name);
if($file_name!="none")
{
$file=escapeshellcmd(stripslashes(${"user".$x."file"}));
if(copy($file,$file_name))
{
unlink($file);
$file_db[$x]=$file_name;
}
}
}

}
$host ="host";
$user ="user";
$pass ="pass";
$db ="db";
$conn =mysql_connect($host, $user, $pass)or die("Invalid server or user");

mysql_select_db($db);

#$query = "insert into waterfront values ('".$agent_id."', '".$layout."', '".$page."', '".$position."', '".$text."', '".$address."', '".$city."', '".$state."', '".$zip."', '".$bedrooms."', '".$bathrooms."', '".$price."', '".$mls."', '".$instructions."', '".$userfile_name."', '".$photo2."', '".$photo3."', '".$photo4."', '".$photo5."', '".$photo6."', '".$photo7."', '".$photo8."', '".$photo9."', '".$photo10."')";
$query="insert into waterfront values('$agent_id','$layout','$page','$position','$text.','$address','$city','','$file_db[1]' ";

$result = mysql_query($query);
#if ($result)
$id=mysql_insert_id();
if($id)
{
echo "Server HaD Receive the Upload Files!";
}
?>

[Anon]

Thanks Mike, I appreciate the help. I changed a few things but it works great. I wasn't sure about the ereg replace command so this helped a lot.

Thanks again!
James F.