Jump to content

samyathakur9@gmail.com

Members
  • Posts

    1
  • Joined

  • Last visited

samyathakur9@gmail.com's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. here is a script to upload multiple image on server folder and stor their path in database, however the path of the images are getting stored in one column only. For example: i upload 3 images, image1.jpg, image2.jpg, image3.jpg. These images are supposed to get stored in 3 column i.e offimage1, offimage2, offimage3. Now problem is that the path of all 3 images are getting stored under offimage1 only. the path that gets stored in offimage1 looks something like this, uploads/image1.jpg*uploads/image1.jpgimage2.jpg*uploads/image1.jpgimage2.jpgimage3.jpg i wish that images should get stored in this way: uploads/image1.jpg in colum offimage1 uploads/image1.jpgimage2.jpg in colum offimage2 uploads/image1.jpgimage2.jpgimage3.jpg in colum offimage3 html form <form enctype="multipart/form-data" action="insert_image.php?id=<?php echo $_GET['id']; ?>" method="post"> <div id="filediv"><input name="file[]" type="file" id="file"/></div><br/> <input type="button" id="add_more" class="upload" value="Add More Files"/> <input type="submit" value="Upload File" name="submit" id="upload" class="upload"/> </form> insert_image.php <?phpob_start();require 'connection.php';if (isset($_POST['submit'])) { $j = 0; //Variable for indexing uploaded image $target_path = "uploads/"; //Declaring Path for uploaded images for ($i = 0; $i < count($_FILES['file']['name']); $i++) {//loop to get individual element from the array $validextensions = array("jpeg", "jpg", "png"); //Extensions which are allowed $ext = explode('.', basename($_FILES['file']['name'][$i]));//explode file name from dot(.) $file_extension = end($ext); //store extensions in the variable $target_path = $target_path . md5(uniqid()) . "." . $ext[count($ext) - 1];//set the target path with a new name of image $j = $j + 1;//increment the number of uploaded images according to the files in array if (($_FILES["file"]["size"][$i] < 100000) //Approx. 100kb files can be uploaded. && in_array($file_extension, $validextensions)) { if (move_uploaded_file($_FILES['file']['tmp_name'][$i], $target_path)) {//if file moved to uploads folder //echo $j. ').<span id="noerror">Image uploaded successfully!.</span><br/><br/>'; $file_name_all.=$target_path."*"; $filepath = rtrim($file_name_all, '*'); //echo $filepath; $officeid = $_GET['id']; $sql = "UPDATE register_office SET offimage='$filepath' WHERE id='$officeid' "; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } } else {//if file was not moved. echo $j. ').<span id="error">please try again!.</span><br/><br/>'; } } else {//if file size and file type was incorrect. echo $j. ').<span id="error">***Invalid file Size or Type***</span><br/><br/>'; } } header("Location: co_request_sent.php ");}mysqli_close($con); ?> would appreciate if someone could help me..
×
×
  • Create New...