multiple image upload using foreach loop and inserting to database

Question

I am having trouble getting the image files I wanted them to insert in my database I want the picture like the one I uploaded like this:

insert into('pic1.jpg');

insert into('pic2.jpg');

insert into('pic3.jpg');

not like this:

insert into(Array[0] => pic1.jpg, Array[1] => pic2.jpg, Array[2] => pic3.jpg);

so i can get their name only and insert in in my database im required to use foreach loop

  if(isset($_POST['upload'])){
      $upload[] = ($_FILES['images']['name']);
      print_r($upload);
   }


<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title></title>
    </head>
    <body>
        <form method="POST" enctype="multipart/form-data">        
        <input type="file" name="images[]" multiple="multiple">
        <input type="submit" name="upload" value="upload">
        </form>
    </body>
</html>

user3129207 · Accepted Answer · 2014-01-29 06:29:13Z

3

This is also one method:

foreach ($_FILES['images']['name'] as $f => $name) {
 $filename = $_FILES['images']['name'];
 $mysql_query1 = mysql_query("insert into table values('".$filename."')");
}

answered Jan 29, 2014 at 6:29

user3129207

613 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1844933 · Accepted Answer · 2014-01-29 06:13:36Z

2

Try this ...

   foreach ($_FILES['image']['tmp_name'] as $key => $val ) {

        $filename = $_FILES['image']['name'][$key];
        $filesize = $_FILES['image']['size'][$key];
        $filetempname = $_FILES['image']['tmp_name'][$key];

        $fileext = pathinfo($fileName, PATHINFO_EXTENSION);
        $fileext = strtolower($fileext);

        // here your insert query
    }

answered Jan 29, 2014 at 6:13

user1844933

3,4132 gold badges28 silver badges44 bronze badges

3 Comments

Alireza Fallah Over a year ago

so you mean for inserting 10 image, he have to make 10 query to database ??

user1844933 Over a year ago

@@Alireza Fallah... that is his requirement

Sheik Over a year ago

is it possible to upload images using multiple browse buttons?

Alireza Fallah · Accepted Answer · 2014-01-29 06:13:05Z

1

$images = $_FILES['images']['name'];
$sql = "insert into table (image_name) VALUES  ('".  implode("') ('", $a)."')";

Result is like :

insert into table (image_name) VALUES ('1.jpg') ('2.jpg') ('3.jpg') ('4.jpg')

answered Jan 29, 2014 at 6:13

Alireza Fallah

4,6074 gold badges34 silver badges58 bronze badges

Comments

Janak Prajapati · Accepted Answer · 2014-01-29 06:14:20Z

0

user foreach.

example code :

foreach ($image as $image_path)
{
    mysql_query("insert into `table` (column) values ('".$image_path."')");
}

answered Jan 29, 2014 at 6:14

Janak Prajapati

8761 gold badge10 silver badges39 bronze badges

4 Comments

Alireza Fallah Over a year ago

you mean for 10 image, he must make 10 queries instead of one??

Janak Prajapati Over a year ago

so u want to 10 images each in one row !! so there will be 10 queries for sure

Janak Prajapati Over a year ago

insert into('pic1.jpg'); insert into('pic2.jpg'); insert into('pic3.jpg'); he want like this i guess

Joshua Over a year ago

i wanted to loop until all the images are in my database so that will require a long code. so i ask how to use the foreach loop with array instead of for loop its much neater.

Mursalin Ahmed · Accepted Answer · 2018-01-06 17:20:27Z

0

Try this...

if(isset($_POST['upload'])){
 $total = count($_FILES['images']['name']);
 for($i=0; $i<$total; $i++){

  $tmpFilePath=$_FILES['images']['tmp_name'][$i];
  if($tmpFilePath != ""){


    $img_name = $_FILES['images']['name'][$i];

    mysqli_query($connection, "INSERT INTO table_name (column_name) value ('".$img_name."')");
    }    
  }  
}

answered Jan 6, 2018 at 17:20

Mursalin Ahmed

311 bronze badge

Collectives™ on Stack Overflow

multiple image upload using foreach loop and inserting to database

5 Answers 5

Comments

3 Comments

Comments

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

3 Comments

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related