How to make boolean field from checkbox type form

[Diego Baratta]

I think the title is pretty explicit. How can i do that? Because I did a form with checkboxes and the "store" function makes the table with varchar fields from it, writing "on" in case that it's checked and "NULL" otherwise.

PD: I'm extremely noob with redbean, this is my first use of it.

[gabor]

Hi there,

You'll have to convert the value to 'true' or 'false' before storing it in the database.
However, if you want your form to be stored in a 'one-run' you can also use radioboxes instead of checkboxes and
fill those radio values with 0 and 1. Personally I think radio buttons are more applicable for booleans than checkboxes, I prefer checkboxes for 'actions' to perform on a 'post', so
in my apps their values never end up in the database - just sharing personal approach here...

cheers,
Gabor

[sah]

I do it like this:

<input type="hidden" name="dialog[enabled]" value="0">

<input id="person-enabled" type="checkbox" name="dialog[enabled]" checked="checked" value="1">

and then use either R::graph() or R::dispense().

[ciobotel]

in google form where is :'input field -hidden' ?

[anton slesarev]

зачем тебе там создавать логическое поле? можно с помощью проверки на пустоту! вот например

<?php

 $data = $_POST['bool'];

if(empty($data['bool'])){$i = false} else {$i = true}

?>

//если выбрать флажок то i = правда иначе i = лож

 <input type="checkbox" name="bool" value="qwe">qwe<Br>