How to insert an array into the database without inserting every loop in php

Question

I have this array from the checkbox

<?php
    $query = $handler->query("SELECT * FROM colors");
    while ($row = $query->fetch()) {?>
 <input type="checkbox" name="check_list[]" id="<?php echo $row['id']?>" value="<?php echo $row['hex'];?>">
<?php } ?>

PHP Query

<?php
    if(!empty($_POST['check_list'])) {
    foreach($_POST['check_list'] as $check) {
    $query = $handler->query("INSERT INTO images (color_tags) VALUES ('$check')");
        }
    }
        ?>

I want to insert the data's from the array without inserting it on every row I want it to be just separated in commas like data1,data2,data3 then insert it.

sorry i don't know about implode can you give me an example? — Otachan, Sep 02 '16 at 03:30
@Otachan I add answer, you can see my example of code and let me know if you have any further question — Nouman Arshad, Sep 02 '16 at 11:15

score 1 · Answer 1 · answered Sep 02 '16 at 03:27

1

Use implode() function. It join array elements with a string.

string implode ( string $glue , array $pieces )
string implode ( array $pieces )

and save the string in database.

answered Sep 02 '16 at 03:27

Mayank Pandeyz

25,704
4
40
59

do i put that inside loop? or after? – Otachan Sep 02 '16 at 03:31
If you are using implode than there is no need of looping, it convert your array to an string – Mayank Pandeyz Sep 02 '16 at 03:42
Take care with the glue char. That char should not be the part of array string – Ish Sep 02 '16 at 03:44

score 1 · Accepted Answer · answered Sep 02 '16 at 03:41

1

Store it in json.

json_encode($array)

<?php
if(!empty($_POST['check_list'])) {

$query = $handler->query("INSERT INTO images (color_tags) VALUES ( json_encode($_POST['check_list']))");

}
?>

answered Sep 02 '16 at 03:41

Ish

2,085
3
21
38

score 1 · Answer 3 · edited May 23 '17 at 10:29

See answer in this post on how to insert multiple rows with one query in MySQL. Insert multiple rows with one query MySQL

This code will create a single insert query for all the items in your checkbox array.

if(!empty($_POST['check_list'])) {
    $insert_sql = "('".join("'),('",  $_POST['check_list'])."')";
    $query = $handler->query("INSERT INTO images (color_tags) VALUES ". $insert_sql);
}

chetan.mohol · Answer 4 · 2016-09-02T07:53:35.553

1

check if count of posted array is greater than 0 or not, if it has then convert values into comma separated and insert it into table.Otherwise no need of conversion and not need to insert blank values into table

if(count($_POST['check_list']) > 0)
    $list = implode(",",$_POST['check_list']);
else
    $list = '';

$query = $handler->query("INSERT INTO images (color_tags) VALUES('$list')");

edited Sep 02 '16 at 07:53

answered Sep 02 '16 at 05:43

chetan.mohol

56
7

Nouman Arshad · Answer 5 · 2016-09-02T11:14:21.467

I did not read your last line of require to keep it like a separated list. So, modifying my example

<?php

    if(!empty($_POST['check_list']) && is_array($_POST['check_list'])) {

      // use pipe "|" to separate values 
      $color_list = implode('|', $_POST['check_list']);

      // $handler -> mysqli or mysql
      $color_list = $handler->real_escape_string($city);
      $query = $handler->query("INSERT INTO images (color_tags) VALUES ('$color_list')");

    }
?>

Later you can use explode function to make it array again.

Sudo Example:

$DB_STRING_VALUE = "Fetch color_tags value from image table"
$list_of_colors = $DB_STRING_VALUE;

if(!empty($DB_STRING_VALUE)
  $list_of_colors = explode('|', $DB_STRING_VALUE);

How to insert an array into the database without inserting every loop in php

5 Answers5