Boolean insert

Wappler General How To
#1

Hi,
think I am being really thick this morning but cannot get a boolean to insert or update.

PHP/Mysql.

I have a field in the DB that is a boolean. I have a form with a tickbox, value 1 for ticked, 0 for unticked.

Field on DB is default 0.

I try to do an insert with the tickbox checked (so value set to 1). Yet it doesnt insert 1 into the DB.

Equally I have an update form (same form basically), sets to 1, but update does not set to 1.

I have tried to set value to number as I believe it comes in as a string from the form, but setting to number makes no difference.

what am I doing wrong?

thanks

#2

The checkbox only has one value, which you set in its value="" attribute. If the checkbox is not checked, then it does not send a value on form submit. It only sends this value when it is checked.

What’s your checkbox code on the page?

#3

@JamesJenkins,

Please take a look at that great “to the point” tutorial

#4

yeah, if checked it sends 1, if not checked nothing, on the DB field I have degault set to 0, so if not checked on the front end the DB will insert 0 and on front end if checkbox is ticked it sends 1.


and the dynamic attribute is set to Checked SC_ViewClientDetails.data.ViewClientDetails.Users_Data[0].OnWhatsapp

the checkbox works in terms of showing its checked on selecting from teh DB, but it does not do an update or insert, only if i go directly into the DB and set it to 1 it shows as ticked, if i then untick it, nothing changes on the db, equally if its unticked and i tick it nothing it sent to the server end

thanks

#5

Can you please post your checkbox code here?

#8
#10 
<input class="form-check-input" type="checkbox" id="OnWhatsapp" name="OnWhatsapp" dmx-bind:checked="SC_ViewClientDetails.data.ViewClientDetails.Users_Data[0].OnWhatsapp">
#11

Your checkbox has no value set. It needs a static value 1 added so that it can send this value when it’s checked.

#12

doh, thanks, that did it, thought with it getting dynamic value it didnt need the static.

thanks

#13

You don’t need a dynamic value there.