How to retrieve data from MySQL array and make checkbox checked in list

Question

I have a form in which I display numbers of company with checkbox. User checked these company and save this in a database table. Now I want to make an update form where I want that when data retrieve from database the checkbox is already checked in list which is checked by user while entering data.

Basically i want that when user fetches his stored results from database, he should be able to see which checkbox's he ticked earlier.

Screenshot of values which is saved by user

[![enter image description here][1]][1]

List of that values which is save in select_fi columns

[![enter image description here][2]][2]

Questions seeking debugging help ("**why isn't this code working?**") must include the desired behavior, a *specific problem or error* and *the shortest code necessary* to reproduce it **in the question itself**. Questions without **a clear problem statement** are not useful to other readers. See: [How to create a Minimal, Complete, and Verifiable example](http://stackoverflow.com/help/mcve). — Praveen Kumar Purushothaman, Jun 28 '16 at 07:37
@PraveenKumar I have no idea how i can do it i just want a way of how i can do it? — sunny, Jun 28 '16 at 07:38
At least you could show your database structure. What have you tried to approach the problem? — Praveen Kumar Purushothaman, Jun 28 '16 at 07:51
Mate, still no structure is there. You have shown the contents. — Praveen Kumar Purushothaman, Jun 28 '16 at 08:43
It would be better practice to create another table and store the list in this table than to store the selection as a comma-separated list. Please read [Is storing a delimited list in a database column really that bad?](http://stackoverflow.com/questions/3653462/is-storing-a-delimited-list-in-a-database-column-really-that-bad) for more information on how and why. — Matt Raines, Jun 28 '16 at 08:47

Fredster · Accepted Answer · 2016-06-28T08:04:50.857

1

When you fetch the current user's select_fi previously checked boxes (e.g. 1,2,3 ) you can convert it to PHP array with $current_user_checked_boxes_ids = explode(",",$string).

And then, inside the PHP loop you have to print the checkboxes in HTMLyou can write something like:

if (in_array(
$current_check_box_id, 
$current_user_checkboxes_ids))
echo '<input type="checkbox" checked="checked">';
else
echo '<input type="checkbox">';

edited Jun 28 '16 at 08:04

answered Jun 28 '16 at 07:42

Fredster

776
1
6
16

which part can't you do? – Fredster Jun 28 '16 at 07:42
As you tell in your answer i already do it but problem is that i want checked only that checkbox which is save in database and other checkbox will be unchecked – sunny Jun 28 '16 at 07:44
when your printing the HTML for the checkboxes do something like `if (in_array($current_check_box_name, $check_boxes_fetched_from_database)) echo "checked='checked'";` – Fredster Jun 28 '16 at 07:48
or just edit your question with the code you're trying... – Fredster Jun 28 '16 at 07:49
I've edited my answer.. – Fredster Jun 28 '16 at 08:10
have you tried this? did it work? – Fredster Jun 28 '16 at 08:52

score 0 · Answer 2 · answered Jun 28 '16 at 07:53

0

maybe like :

<?php
 $sql=select * from table;
 while($row=mysql_fetch_array($sql)){
 if($row['column1']!=''){
 ?>
  use the html code to mark the  checkbox
 <?php
}else{
 ?>
 use the html code to show checkbox without mark
<?php
}
?>

answered Jun 28 '16 at 07:53

J. Zend

88
7

How to retrieve data from MySQL array and make checkbox checked in list

2 Answers2