How to add checkbox value in database?

Question

<?php 
 if(isset($_REQUEST['submit']))
 {
        $category = mysql_real_escape_string(implode(',', $_POST['category']));

 }

$ins=mysql_query("insert into fruits (`category`) values ('$category') " ) ;

?>

<form name="form1" method="post" action="">
<input type="checkbox"    name="category[]" value="apple" >Apple
<input type="checkbox"    name="category[]" value="orange" >Orange
<input type="checkbox"    name="category[]" value="mango" >Mango
<input type="submit" name="submit" value="submit"  />
</form>

I need to save checkbox value like [apple][orange][mango] but now it save like apple,orange,mango

can anyone help me ?

Why are you saving a (whatever delimited) list in an SQL database? Set up a many-to-many relationship with a bridge table, then you'll be able to query the values properly. — Quentin
– Quentin, Commented Jul 29, 2011 at 9:48

Nick Pavluk · Accepted Answer · 2011-07-29 09:53:42Z

2

Use cycle to create string you need

$category = '';

foreach ( $_POST['category'] as $cat )
{
    $category .= '[' . $cat . ']';
}

$ins=mysql_query("insert into fruits (`category`) values ('$category') " ) ;

answered Jul 29, 2011 at 9:53

Nick Pavluk

3792 silver badges7 bronze badges

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

1 Comment

Nick Pavluk Over a year ago

@Quentin, yeah it's fun. But it just was a string from author code.

totallyNotLizards · Accepted Answer · 2011-07-29 10:00:36Z

2

I agree with Quentin's comment on your question - many to many with bridge table is the best way to go for this, I've had to do something very similar recently and that was the best solution.

If you are intent on doing this anyway, you'd need to just loop through the category[] array and build a string with your square brackets, something like this:

$str='';
foreach ($_POST['category'] as $val)
{
    $str.='['.$val.']';
}

Unless I've misunderstood the significance of the brackets that is :)

EDIT: Just read http://bobby-tables.com/, (courtesy of quentin) lmao. you should consider the possible security implications before going ahead with this.

edited Jul 29, 2011 at 10:00

answered Jul 29, 2011 at 9:55

totallyNotLizards

8,5899 gold badges54 silver badges86 bronze badges

Comments

Ruslan Polutsygan · Accepted Answer · 2011-07-29 09:56:04Z

0

Not sure I've understood you right, but try this

$category = mysql_real_escape_string(implode('][', $_POST['category']));
if($category)
   $category='['.$category.']';

I hope it will be helpfull.

answered Jul 29, 2011 at 9:56

Ruslan Polutsygan

4,4612 gold badges28 silver badges38 bronze badges

Collectives™ on Stack Overflow

How to add checkbox value in database?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related