Multiple images insert into database with one form

Josien

Title may be strange,

I was wondering if there is a way with PHP to make it so that multiple images links named test01.gif, test02.gif test03.gif etc, can be placed into the database without having to do them each seperately and without a loop.

dougal85

do you mean a user going to the form and uploading the images?

uploading multiple files is one of these things that becomes a bit of a pain in the ass when you don't know exactly how many there are and even when there are a large number it has the same problem.

Unfortunately the <input type="file"> HTML element can only do one file at a time. There are various ways around this including a usage of JavaScript or Flash

Josien

I'll try to explain more.

The images are in a folder already uploaded. each folder contains 10 or 20 images. In the database I post the widht and height and how many there are in that particular folder.
In the database there basically is posted a link to the images.

<?php if($_GET['do'] == add) {
$totalcards = $_GET['totalcards']; for($i=1;$i<=$totalcards;$i++) {$cardnum = sprintf("%02.0f", $i);
$deckname = addslashes($_POST[deckname]);
$descrip = addslashes($_POST[descrip]);
mysql_query("INSERT INTO $tablename2 (id, deckname, deckfilename, cardnum, category, descrip, totalcards, cardwidth, cardheight, cardvalue, masterable) VALUES ('','$_POST[deckname]','$_POST[deckfilename]','$_POST[cardnum]','$_POST[category]','$_POST[descrip]','$_POST[totalcards]','$_POST[cardwidth]','$_POST[cardheight]','$_POST[cardvalue]','$_POST[masterable]')");
}
echo "<p>Success! The new deck has been added into the database.</p>"; }

else { ?>
<p>Please fill out ALL of the information below to add a new card deck.</p>
<p><form method="post" action="adddeck.php?do=add">
Deck Name: <input type="text" name="deckname" size="30" /><br />
Deck File Name: <input type="text" name="deckfilename" size="30" /><br />
Deck Description: <input type="text" name="descrip" size="30" /><br />
Category: <input type="text" name="category" size="30" /><br />
Total Cards: <input type="text" name="totalcards" size="30" /><br />
Card Width: <input type="text" name="cardwidth" size="30" /><br />
Card Height: <input type="text" name="cardheight" size="30" /><br />
Card Value: <input type="text" name="cardvalue" size="30" /><br />
Masterable: <select name="masterable" size="1">
<option value="Yes">Yes</option>
<option value="No">No</option></select><br /><br />
<input type="submit" name="submit" value=" Add " /> <input type="reset" name="reset" value=" Clear " /></form></p>

My currount code, this one doens't posts anything at all in the database.