Return a boolean value from MySQL for using it in function as parameter

Question

I'm building a simple user registration and information update forms which have a lot of checkboxes with CodeIgniter. I store the values of checkboxes as 1 (if checked) and 0 (if not checked) in MySQL database under the tinyint(1) fields. So in user update form, I have to set default values which are return from these MySQL fields. On the other hand, the data shouldn't lost if the form validation isn't passed. Because of that, I need to use set_checkbox function of CI with third parameter, like this:

<input type="checkbox" name="my_field" value="1" <?php echo set_checkbox('my_field', '1', $returned_boolean_value); ?> >

But it doesn't work, because my MySQL query doesn't return boolean value for variable $returned_boolean_value. It returns 0 or 1 as a string. So the PHP query becomes something like this:

set_checkbox('my_field', '1', '1');

but it must be something like this:

set_checkbox('my_field', '1', TRUE);

My question is how can I set this third boolean parameter of set_checkbox with the data which is return from database?

I also looked throw the relevant questions, but found nothing about it. Any help would be appreciated. Thanks in advance.

Mark Baker · Accepted Answer · 2012-03-19 21:17:21Z

3

Cast to boolean

<?php echo set_checkbox('my_field', '1', (boolean) $returned_boolean_value); ?>

answered Mar 19, 2012 at 21:17

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

Comments

nageeb · Accepted Answer · 2012-03-19 21:37:49Z

1

Another option using C++ style if/else

set_checkbox('my_field', '1', $returned_boolean_value ? TRUE : FALSE);

edited Mar 19, 2012 at 21:37

answered Mar 19, 2012 at 21:24

nageeb

2,0421 gold badge13 silver badges26 bronze badges

Comments

biziclop · Accepted Answer · 2012-03-19 21:16:59Z

0

You could use the good old double negation, or string comparison

http://codepad.org/Y7W0WWau

set_checkbox('my_field', '1', !! $string_0_or_1 );
set_checkbox('my_field', '1', $string_0_or_1 == '1' );

answered Mar 19, 2012 at 21:16

biziclop

14.6k3 gold badges52 silver badges66 bronze badges

2 Comments

Philip Over a year ago

like mark shows you typecast the result, or try set the db fieldtype to boolean

biziclop Over a year ago

Yes, that is the cleanest solution.

Onur Eren Elibol · Accepted Answer · 2012-03-19 21:27:37Z

0

<?php echo set_checkbox('my_field', '1', (int) $returned_boolean_value); ?> 
<?php echo set_checkbox('my_field', '1', intval($returned_boolean_value)); ?> 
<?php echo set_checkbox('my_field', '1', (bool)$returned_boolean_value); ?> 
<?php echo set_checkbox('my_field', '1', $returned_boolean_value=='1'?true:false); ?>

You can use one of the above...

answered Mar 19, 2012 at 21:27

Onur Eren Elibol

3411 gold badge2 silver badges13 bronze badges

Collectives™ on Stack Overflow

Return a boolean value from MySQL for using it in function as parameter

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related