Doing stuff multiple times (upload, post to db) problem

[Adastra]

Hi guys,

I'm trying to write a small gallery script which gives the possibility to upload a number of 1-10 files at once - first thing the user does is pick the number of files to upload, then he is directed to the upload form(s).

Now my problem is that I don't know how to process the multiple files at once - there are 4 fields for each photo, the file itself, a title, a description and the gallery id. All of that is inserted into a DB after the images have been resized and uploaded - how do I do both of those things for multiple files at once? It must be something with for or foreach, but I have no idea how to use it with multiple files AND multiple fields to be post at once. The affected part is the add action. Any help would be very appreciated :)

This is my file:
[code=php:0]
if ($_POST['action'] == "add") {

foreach () {
//__ photos in dir ablegen _______________________________________
$ul_photo = $_FILES['photo']['tmp_name'];
$src = imagecreatefromjpeg($ul_photo);
list($width,$height) = getimagesize($ul_photo);
$newwidth = 550;
$newheight = ($height/$width)*$newwidth;
$tmp = imagecreatetruecolor($newwidth,$newheight);
imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);
$filename = $dirpath.$gal_id."/". $_FILES['photo']['name'];
imagejpeg($tmp,$filename,100);

#__ thumb _________________________________________________________
$ul_thumb = $_FILES['photo']['tmp_name'];
$srcthumb = imagecreatefromjpeg($ul_thumb);
list($widththumb,$heightthumb) = getimagesize($ul_thumb);
$newwidththumb = 100;
$newheightthumb = ($heightthumb/$widththumb)*$newwidththumb;

$src_top = ($src_height / 2) - ($dst_height / 2);
$src_left = ($src_width / 2) - ($dst_width / 2);

$tmpthumb = imagecreatetruecolor($newwidththumb,$newheightthumb);
imagecopyresampled($tmpthumb,$srcthumb,0,0,$src_top,$src_left,$newwidththumb,$newheightthumb,$widththumb,$heightthumb);
$thumbname = $dirpath.$gal_id."/zth_".$titlesuf . $_FILES['photo']['name'];
imagejpeg($tmpthumb,$thumbname,100);
#___________________________________________________________________

imagedestroy($src);
imagedestroy($tmp);
imagedestroy($srcthumb);
imagedestroy($tmpthumb);


$gal = addslashes($_POST['gal_id']);
$photo = $_FILES['photo']['name'];
$title = addslashes($_POST['title']);
$description = addslashes($_POST['description']);

$sql = "INSERT INTO $gal_photos (gal,photo,title,description) VALUES ('$gal','$photo','$title','$description')";
$query = mysql_query($sql) or die("MySQL Error: <br /> {$sql} <br />". mysql_error());
$num = mysql_affected_rows();

if($num > 0) {
echo "<span class='result'>New Photo successfully added!</span>";
echo "<br /><img src='../galleries/".$gal."/zth_".$photo."' />";
} else {
echo "Error: ".mysql_error();
}
} #foreach



} elseif ($_GET['action'] == "listforms") {
?>
<strong>Post New Photos</strong>
<br />
<br />
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="649760" />

<?
for ($x=0;$x<$_GET['num'];$x++) {
?>
<div class='uploadbox'>
Associated Gallery <?=$x + 1?>:
<br />
<?
$selgal_sql = "SELECT * FROM $gal_galleries ORDER BY id DESC";
$selgal_result = mysql_query($selgal_sql) or print ("Unable to select data.<br />".$selgal_sql."<br />".mysql_error());
$selgal_num = mysql_num_rows($selgal_result);
if ($selgal_num > 0) {
echo "<select name='gal_id[]'>";
while ($selgal_row = mysql_fetch_array($selgal_result)) {
$selgal_id = $selgal_row["id"];
$selgal_title = $selgal_row["title"];
echo "<option value='".$selgal_id."'>".$selgal_id.": ".$selgal_title."</option>";
}
echo "</select>";
} else {
echo "<a href='gal_galleries.php'>Please create a new gallery to post photos!</a>";
}
?>
<br />
<br />

Photo File <?=$x + 1?>:
<br />
<input type='file' name='photo[]' size='50' />
<input type="hidden" name="thumb[]" value="<? ($_POST['photo']) ?>" />
<br />
<br />

Photo Title <?=$x + 1?>:
<br />
<input type='text' name='title[]' size='50' />
<br />
<br />

Photo Description <?=$x + 1?>:
<br />
<textarea cols='45' rows='5' name='description[]'></textarea>
</div>
<br />
<?php
} ?>
<br />
<br />
<input type="submit" name="action" value="add" />
</form>


<?
} else {
?>
<strong>Post New Photos</strong>
<br />
<br />
<form action="<?=$_SERVER['PHP_SELF']?>" method="get">
<input type="hidden" name="action" value="listforms" />
<label for="num">Select number of photos to post</label>:
<select id="num" name="num">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
<input type="submit" value="Proceed" />
</form>
<?
}
[/code]