How do I insert multiple images in rows from mysql database?

Question

I need the user to insert multiple images into database through a form. I succeded to make one image insert. Here is the code:

$insert_sql = "INSERT INTO my_tbl VALUES ('' , \"$image\", \"$title\")";

<form name = "my_form" form action=" " enctype="multipart/form-data" method="post">
<div> Title:  <input name="title" type="text" size="50"   /></div> 
<div"> Image:   <input name="classnotes" type="file"  value="" id="file"/></div>
<input name='submit' type='submit' id="submit-go" value='Upload'>
</form>

Now I need to insert several images so I tried to insert at least 3 images but didn't work out. Only last field's image inserts into the database. Anyhow I need to make it work. So, any help is appreciated.

<form name = "my_form" form action=" " enctype="multipart/form-data" method="post">
<div> Title:  <input name="title" type="text" size="50"   /></div> 
<div"> Image:   <input name="classnotes" type="file"  value="" id="file"/></div>

<div> Title:  <input name="title" type="text" size="50"   /></div> 
<div"> Image:   <input name="classnotes" type="file"  value="" id="file"/></div>

<div> Title:  <input name="title" type="text" size="50"   /></div> 
<div"> Image:   <input name="classnotes" type="file"  value="" id="file"/></div>
<input name='submit' type='submit' id="submit-go" value='Upload'>
</form>

Alessandro · Accepted Answer · 2016-03-18 10:54:58Z

3

The problem is that using many inputs with the same name will cause just the last one to be sent. You should name your inputs like arrays and then loop over the array in the PHP code.

HTML

<div> Title:  <input name="title[]" type="text" size="50"   /></div> 
<div> Image:   <input name="classnotes[]" type="file"  value="" id="file"/></div>

PHP

$titles = $_POST["title"];
$images = $_FILES["classnotes"]["tmp_name"];
foreach ($images as $index => $image) {
    $imageType = $_FILES["classnotes"]["type"][$index];

    // check the file type here!!

    $title = $titles[$index];
    $insert_sql = "INSERT INTO my_tbl VALUES ('' , \"$image\", \"$title\")";

    // execute the query here!!

    // move the uploaded file here!!
}

Edit

@Jklyn your script has a lot of problems. I edited the snippet above to give you a better idea of how to refactor your code to achieve what you want. Please mind that you have an array of images to handle, so every query or operation on each single file should happen inside the foreach loop.

Read how the upload of many files works in PHP: http://php.net/manual/en/features.file-upload.multiple.php

edited Mar 18, 2016 at 10:54

answered Mar 18, 2016 at 8:33

Alessandro

1,4539 silver badges19 bronze badges

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

1 Comment

Jklyn Over a year ago

Thank you for your effort. I'll certainly study the link. I would be more grateful if you would help me further to solve this issue. I badly need to solve it quickly for my website.

Collectives™ on Stack Overflow

How do I insert multiple images in rows from mysql database?

1 Answer 1

Edit

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Edit

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related