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
– Otachan, Commented Sep 2, 2016 at 3:30
@Otachan I add answer, you can see my example of code and let me know if you have any further question — Nouman Arshad
– Nouman Arshad, Commented Sep 2, 2016 at 11:15

Ish · Accepted Answer · 2016-09-02 03:41:59Z

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 2, 2016 at 3:41

Ish

2,1013 gold badges23 silver badges40 bronze badges

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

Comments

Mayank Pandeyz · Accepted Answer · 2016-09-02 03:27:11Z

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 2, 2016 at 3:27

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

3 Comments

Otachan Over a year ago

do i put that inside loop? or after?

Mayank Pandeyz Over a year ago

If you are using implode than there is no need of looping, it convert your array to an string

Ish Over a year ago

Take care with the glue char. That char should not be the part of array string

Community · Accepted Answer · 2017-05-23 10:29:11Z

1

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);
}

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Sep 2, 2016 at 4:25

DragonSpirit

614 bronze badges

Comments

chetan.mohol · Accepted Answer · 2016-09-02 07:53:35Z

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 2, 2016 at 7:53

answered Sep 2, 2016 at 5:43

chetan.mohol

567 bronze badges

Comments

Nouman Arshad · Accepted Answer · 2016-09-02 11:14:21Z

1

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);

edited Sep 2, 2016 at 11:14

answered Sep 2, 2016 at 8:17

Nouman Arshad

5932 silver badges7 bronze badges

Collectives™ on Stack Overflow

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

5 Answers 5

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related