implode a data from database to echo checkbox as checked

Question

I have a data array which is separated by a comma in database.

now, what i want to do is implode the strings from the column purpose.

and make that checkbox lists in my form echo checked; if the list is in the database.

hope you guys can help me out. Thank You!

Please stop storing CSVs in columns. This is not how they are meant to be used. 1 value per column. — user3783243
– user3783243, Commented Jul 2, 2018 at 2:32
Please, show us, what have you tried to solve the problem. Otherwise we won't help. — user4035
– user4035, Commented Jul 2, 2018 at 2:35
Your database design is bad. You need to create a child table for storing purpose fields. — user4035
– user4035, Commented Jul 2, 2018 at 2:37
Possible duplicate of Is storing a delimited list in a database column really that bad? — user3783243
– user3783243, Commented Jul 2, 2018 at 2:37

Ashraf · Accepted Answer · 2018-07-02 04:02:34Z

1

Here's an example (Not the proper way to design your code though) .

$purposesFull=array('a','b','c','d','e');
$purposesFromDB='a,b,d';
$purposesFromDBArray=explode(',',$purposesFromDB);
foreach($purposesFull as $item){
    $checked = in_array($item,$purposesFromDBArray) ? ' checked' : '';
    echo '<input type="checkbox" name="purs[]"'.$checked.'>'.$item;
    echo '<br/>';
}

answered Jul 2, 2018 at 4:02

Ashraf

2,6091 gold badge23 silver badges38 bronze badges

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

2 Comments

curiosity Over a year ago

Your code has the correct output. i will try it first, based on my database.

curiosity Over a year ago

Thank you very much. you really got the correct answer. You picture out what the kind of output i want to display. without showing my code.

Erayd · Accepted Answer · 2018-07-02 03:51:57Z

1

If you must do this, then:

$checkedPurposes = preg_split('/\s*,\s*/', $purposeColumnFromDatabase);
// then for each checkbox
if (in_array($purposeName, $checkedPurposes)) {
    // echo checked
}

The regex ensures that typos regarding the number of spaces around the commas don't matter.

As other users have said in the comments though, this is bad database design. If you can change the schema to move the purposes into their own table, you probably should.

answered Jul 2, 2018 at 3:51

Erayd

1687 bronze badges

Collectives™ on Stack Overflow

implode a data from database to echo checkbox as checked

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related