inserting multiple checkbox values into a single column - SQL database

Question

i want get all values from checkbox and insert it on one column like 1,2,3

that my code , i don't know what's wrong

<form method="post" style="display:inline">
<label><input type="checkbox" name="data[]" value="1">1</label>
<label><input type="checkbox" name="data[]" value="2">2</label>
<label><input type="checkbox" name="data[]" value="3">3</label>
</form>

        <?php
if ($_POST['do'] =="insertawards")
{
    $media_array = $_POST['data'];
    $values = array();
    foreach($media_array as $value)
    {
        $values[] = $value;
    }
    $values = implode(',', $values);
        $db->query_write("INSERT INTO " . TABLE_PREFIX . " awards (awards_forumid,awards_userid,awards_name,awards_link) 
        VALUES('".$values."','0','".$_POST['awards_name']."','".$_POST['awards_link']."') ");
}
        ?>

when i used implode , i get error and inserting 0 on datbase

$media_array = $_POST['data'];
foreach ($media_array as $one_media)
{
$source .= $one_media;
}
$source = implode(',', $source);

user1978142 · Accepted Answer · 2014-05-22 03:12:53Z

1

I think the submit button is missing, anyway, if you need to implode the values properly. Consider this example: (i assume 1, 2, 3 are inserted each not the whole string is inserted like 1,2,3)

<?php

define('TABLE_PREFIX', 'vb_');

if(isset($_POST['submit'])) {
    // quick and dirty, just roll up your sanitation
    $media_array = $_POST['data'];
    $awards_name = '"'.$_POST['awards_name'].'"';
    $awards_link = '"'.$_POST['awards_link'].'"';
    $checkbox_values = '"'.implode(',', $media_array).'"';
    $statement = "INSERT INTO ".TABLE_PREFIX."awards (awards_forumid,awards_userid,awards_name,awards_link) ".
        "VALUES ($checkbox_values, '0', $awards_name, $awards_link)";
    echo $statement;
    // INSERT INTO vb_awards (awards_forumid,awards_userid,awards_name,awards_link) VALUES ("1,2,3", '0', "best_website", "http://www.google.com/")
}

?>

<form method="post" style="display:inline">
    <input type="hidden" name="awards_name" value="best_website" />
    <input type="hidden" name="awards_link" value="http://www.google.com/" />
    <label><input type="checkbox" name="data[]" value="1">1</label>
    <label><input type="checkbox" name="data[]" value="2">2</label>
    <label><input type="checkbox" name="data[]" value="3">3</label>
    <input type="submit" name="submit" value="submit" />
</form>

edited May 22, 2014 at 3:12

answered May 22, 2014 at 2:06

user1978142

7,9683 gold badges19 silver badges20 bronze badges

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

15 Comments

o6 qr Over a year ago

kevinabelita,thnx brother , but it's not work with me , values on column = 0

user1978142 Over a year ago

@o6qr wow :) no error whatsoever? my tip is, try to build the query statement first (test the echoed query of $statement in phpmyadmin, so that you'll see errors

o6 qr Over a year ago

:) sorry , i try it agine , show me this error "Column count doesn't match value count at row 1"

user1978142 Over a year ago

@o6qr i updated the answer maybe you forgot $db->query_write($statement)

o6 qr Over a year ago

no i don't forget it , i used it already [$db->query_write("INSERT INTO ]

|

user1978142 · Accepted Answer · 2014-09-14 14:43:30Z

1

i found what's problem ,

the problem not in code , this will be adding values array on mysql like 1,2,3,4

$values = implode(',',$_POST['data'])."\n";

the real problem on Type of mysql field , i make it int(10) While must be mediumtext Even accept coma .

Excuse me and thank for your efforts @user1978142

edited Sep 14, 2014 at 14:43

user1978142

7,9683 gold badges19 silver badges20 bronze badges

answered May 22, 2014 at 19:48

o6 qr

952 silver badges7 bronze badges

Collectives™ on Stack Overflow

inserting multiple checkbox values into a single column - SQL database

2 Answers 2

15 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

15 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related