Handling checkboxes

chinni_77

i have problems handling with checkboxes when i try to insert a record.It returns no value.

For example, if the student is enrolled to a course, i check the box and i want to store the value 1 and if the student is'nt enrolled, i leave the box empty.
Well, i placed, if ($stdenrol=="") $stdenrol=0;
before my insert st.

So, I think if the checkbox is checked, it returns a value "1" to the table and if it is not checked, it returns a value "0".

If i check it and try to insert, it does'nt produce me any error.If i leave it empty, it produces me an error,"conversion error from string."

How can i fix this error.
Ps:This column can also accept null values.

Thanks in advance

Bunkermaster

you compare an int with a string hence "No Worky Boss" try to add quotes around your ==1 test

chinni_77

hmm...nope it does'nt work:-(

when i leave the checkbox empty and insert it, it gives me, error from string,huh!

Thanks any way

chinni_77

Any ideas regarding my post??

Bunkermaster

Originally posted by chinni_77
...
<INPUT type=checkbox name="std_enrol" value="1"<? if
.....

ermmm try to add a space after value="1" and tell us if it works better.

chinni_77

hello BM,

it does'nt work.
I left both the checkboxes empty and try to insert into the table.It has given me the error: conversion error from string ""
why is it so?

dannys

Shouldn't

<INPUT type=checkbox name="std_enrol" value="1"<? if ($stdenrol==1)echo "checked";?>>

<INPUT type=checkbox name="std_enrol" value="1" <? if ($std_enrol==1) echo "checked";?>>

Bunkermaster

my point exactly (damn my english sucks that bad today?)

did you try

<INPUT type=checkbox name="std_enrol" value="1" <? if ($std_enrol == "1") echo "checked";?>>

can't remember if you did... if you did concider me slapped

chinni_77

hmm....it is'nt solved!

<INPUT type=checkbox name="enrolment[<?$rbscount?>]" value="1" <? if ($enrolment == "1") echo "checked";?>>
<INPUT type=checkbox name="ciphering[<?$rbscount?>]" value="1" <? if ($ciphering == "1") echo "checked";?>>

and before my insert st,

i've this one too.

if ($enrolment==NULL) $enrolment=0;
if ($ciphering==NULL) $ciphering=0;

ps:forget about the rbscount, that is an array.

Hope somebody would help me now.

Thanks a lot

Bunkermaster

please try what I suggest in my latest post.

chinni_77

Not yet fixed.I edited my last post couple of times.I did exactly what you told me to do.I wonder why it does'nt work.

something really strange