Populate checkbox form from database in codeigniter

Question

I`m using codeigniter to build small website. I am curious how to populate checkbox from database ?

Let`s say I have the following query;

$this->db->select('status');
$this->db->where('id', 3');
$this->db->get('table);

How to make checkbox to be checked if the result of the query above is 1 ?

try <input type='checkbox' checked='checked' /> i think you are asking how to make the checkbox checked based on the db value. — Khurram Ijaz
– Khurram Ijaz, Commented May 3, 2011 at 16:34

Trevor Arjeski · Accepted Answer · 2011-05-03 16:35:52Z

4

You can do something like this. It's just an idea since I can't really see EXACTLY what you're returning. $entry['status'] is the result from your query.

if($entry['status'] == 1){
                echo '<input type="checkbox" checked="checked" disabled="disabled"/>';
                    }
else {
                echo '<input type="checkbox" unchecked="unchecked" disabled="disabled"/>';
            }

answered May 3, 2011 at 16:35

Trevor Arjeski

2,1881 gold badge27 silver badges42 bronze badges

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

Comments

Matt · Accepted Answer · 2011-05-03 19:17:11Z

1

Take a look at the form_checkbox() section of the codeigniter form helper documentation

answered May 3, 2011 at 19:17

Matt

9,51112 gold badges70 silver badges87 bronze badges

Comments

mhiggins · Accepted Answer · 2011-05-03 19:14:03Z

0

If you want to have the select box checked if the status value is greater than 1 you could do something like this.

$result = $this->db->select('status')->get_where('table', array('id'=> 3))->row();
if($result->status > 1)
{
print '<input type="checkbox" name="checkbox" checked="checked" value="'.$result->status.'" />';
}else{
print '<input type="checkbox" name="checkbox" value="'.$result->status.'" />';
}

You'll want to check that the row actually returns values or you'll get a var on a non object error. This is just an example.

answered May 3, 2011 at 19:14

mhiggins

563 bronze badges

6 Comments

Trevor Arjeski Over a year ago

Why would it ever even need to be greater than 1?

mhiggins Over a year ago

His question was - "How to make checkbox to be checked if the result of the query above is 1?"

Trevor Arjeski Over a year ago

@mhiggins Well I couldnt see why you would have it greater than 1 since they are either 1 or 0 (on or off). no?

mhiggins Over a year ago

No. Checkboxes can be any value... it's true they have an off and on state but at the on state you could assign anything to its value. Additionally, he wants to read the value of "status" out of the database. That could hold anything as well so we're assuming it's numeric and has values greater than 1.

Trevor Arjeski Over a year ago

@mhiggins Yeah any value, but you would store their value in a column in a database table. The actual cell value, what you're returning is a boolean value.

|

vizyourdata · Accepted Answer · 2012-11-28 00:25:00Z

0

This works for me and is simple:

    <?php foreach($tb as $table_row){ ?>
    <input type="checkbox" <?php if ($table_row['reconciled'] == "1" {echo "checked = checked";} ?>

answered Nov 28, 2012 at 0:25

vizyourdata

1,4441 gold badge19 silver badges46 bronze badges

Collectives™ on Stack Overflow

Populate checkbox form from database in codeigniter

4 Answers 4

Comments

Comments

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related