uploading multiple pix with a form

[Panta]

hello friends and my masters am still new with php , i was designing a site when i came across this problem. i want to upload 3 images to a file in my local server and i also want therir location to be in my table in the database.but the script i have is just for one file.please am just asking for help her my code<?phpfunction insertstock($name, $info, $sn, $categorie,$package, $cost,$whouse ,$filepath) { $query = "INSERT INTO stock (name,info,sn,categorie,package,cost,whouse , pix) VALUES ('$name', '$info ', '$sn', '$categorie','$package', '$cost','$whouse' ,'$filepath')"; $connection = mysql_connect(DBHOST, DBUSER, DBPASS) or die("Could not connect to database: " . mysql_error()); $SelectedDB = mysql_select_db(DBNAME); $result = mysql_query($query)or die(mysql_error()); } // end fonction?><form id="form1" name="form1" class="wufoo " enctype="multipart/form-data" autocomplete="on"method="POST" "><?php if (isset($_POST['_submit_check'])){ $name = $_POST["name"]; $info = $_POST["info"]; $sn = $_POST["sn"]; $categorie = $_POST["categorie"]; $whouse =$_POST["whouse"]; $package = $_POST["packid"]; $cost = $_POST["cost"]; $filepath=$_POST['fileName']; $auth->connect(); if($sn == 0){ ?> <div align="center" style="border:2px solid red"> <b>enter serial number</b> </div><?php } else { $result = $auth->displaystock($sn,'sn'); $row = mysql_num_rows($result); if($row > 0){?> <div align="center" style="border:2px solid red"> <b>Item already defined</b> </div> <?php } else{ $auth->insertstock($name, $info, $sn, $categorie,$package, $cost,$whouse ,$filepath);?> <div align="center" style="border:2px solid red"> <b>item inserted</b> </div> <?php print " \n\n\n"; } } }?> <div class="info"> <h4><a href="reportstock.php">Go To Report</a></h4> </div> <ul> <li><?phpecho ' <input type="file" name="file" size="30" style="cursor:hand;"/> <br /> ';echo '<input type="submit" name="action" value="Upload" />'; if(isset($_POST['action'])) { $uploaddir = "../my/images/stockpix/"; $filename = $_FILES['file']['name']; $filetmp = $_FILES['file']['tmp_name']; $filesize = $_FILES['file']['size']; $filetype = $_FILES['file']['type']; $ext = substr(strrchr($filename, "."),1); $conf = $uploaddir . $filename; $filepath = $uploaddir . $filename; if ($filename != "") { if (!file_exists($filepath)) { if ($ext == "jpg" || $ext == "gif" || $ext == "tiff" || $ext == "png" || $ext == "bmp") { if($filesize < "500000") { $upload = move_uploaded_file($filetmp, $filepath); echo '<font color=blue>'. $filename . ' <i>was successfully uploaded...</font><br />'; } else { echo '<font color=red>'.$filename . ' <i>greater than the maximum file size allowed...</font><br />'; } } else { echo '<font color=red>'. $filename . ' <i>is invalid file type...</font><br />'; } } else { echo $filename . ' <i>already exists...</i><br />'; } } ?> <input type="hidden" name="fileName" value="<?php echo $filepath; ?>"/> <img src = "<?php echo $filepath;?>" width="200" height="300"><?php } else { $filepath="none"; ?> <input type="hidden" name="fileName" value="<?php echo $filepath; ?>"/><?php }?> </li> <li id="foli1" > <label class="desc" > Item </label> <div> <input name="name" type="text" class="field text medium" maxlength="255" tabindex="1"/> </div> </li> <li id="foli1" > <label class="desc"> SN </label> <div> <input name="sn" type="text" class="field text medium" value="" maxlength="255" tabindex="2" /> </div> </li> <li id="foli3" > <label class="desc" > Description </label> <div> <textarea name="info" class="field textarea small" rows="10" cols="50" tabindex="3"></textarea> </div> </li> <li id="foli0" > <label class="desc"> Appraised Value </label> <span class="symbol">$</span> <span> <input name="cost" type="text" class="field text currency" size="10" tabindex="4" /> <label for="Field0">Dollars</label> </span> </li> <li id="foli6" > <label class="desc" for="Field6"> ware house </label> <div> <input name="whouse" type="text" class="field text medium" maxlength="255" tabindex="5" /> </div> </li> <li id="foli7" > <label class="desc"> Categorie </label> <div> <select name="categorie" class="field select medium" tabindex="6" > <option value="1" > Mercedes </option> <option value="2" > Mazda </option> <option value="3" > Toyota </option> <option value="4" > Camry </option> <option value="5" > Nissian </option> <option value="6" > Others </option> </select> </div> </li> <li id="foli9"> <label class="desc" > package? </label> <div class="col"> <input name="packid" type="hidden" value="" /> <input name="packid" type="radio" class="field radio" value="1" tabindex="7" /> <label class="choice" for="Field9_0" > unit </label> <input name="packid" type="radio" class="field radio" value="2" tabindex="8" /> <label class="choice" for="Field9_1" > box </label> <input name="packid" type="radio" class="field radio" value="3" tabindex="9" /> <label class="choice" for="Field9_1" > Kg </label> </div> </li> <li class="buttons"> <input id="saveForm" class="btTxt submit" type="submit" name="add" value="Submit" tabindex="10" /> <input type="hidden" name="_submit_check" value="1"/> </li> <li style="display:none"> <label for="comment">Do Not Fill This Out</label> <textarea name="comment" id="comment" rows="1" cols="1"></textarea> </li> </ul> </form> </div><!--container--><?php require('siteadmin.footer.php');?>

[astralaaron]

I would make a separate table for photos and in that table have a user_id field which will link the photos to the user_id in the user table. that way you can hold as many pictures as you need for that user

[thescientist]

you can add multiple file input elements to the form and give the name an array syntax, like so

<input name="filePath[]" type="file"/>

then on the server side you access the GET or POST member as array itself, and then you just need to loop through that and do what you need with it.

[Panta]

thank you all for yoyr efforts ,thescientist i used it as u advised and it worked am much much greatful