CheckBox question with php

[houssam_ballout]

Hello all,I am building an application (web),and I am designing a form,using HTML, I'd checkboxes , I am using isset to enter the data into the database, how can I know if the user has checked or not the checkbox (using checked property), how would I enter that into database?>I am using the type of that field as binary?is that correctThanks in advance

[justsomeguy]

If the field can either be a 1 or 0, binary would probably work, I typically use tinyint.

if (isset($_POST['checkbox_name']))  $checkbox_value = 1;else  $checkbox_value = 0;//or$checkbox_value = (isset($_POST['checkbox_name']) ? 1 : 0);

[houssam_ballout]

USing Mysql, Wat type of that entry should be in the database?Thanks

[justsomeguy]

If the field can either be a 1 or 0, binary would probably work, I typically use tinyint.

[houssam_ballout]

Well, I used the binary, but when I look at the results of the inserting, I see something like \A..Did the tinyint worked well with u ?Also, in the html how could I enter that fact into the database?thanks in advace

[justsomeguy]

I always use tinyint, it works fine. You can also reduce the field size from the default 4 down to 1 to conserve a little space.

Also, in the html how could I enter that fact into the database?

I don't know what you mean by that.

[houssam_ballout]

Should I use isset, to see if the checkbox is checked or not?

[justsomeguy]

Either use isset, or give the checkbox a value and check for the value.<input type="checkbox" name="box1" value="1" />if ($_POST['box1'] == "1")

[houssam_ballout]

Ok thanks alot One more question: I'd a form with many check boxes and submit button, I use isset($_POST['submit']))how could I insert all the checkboxes in that statment?

[justsomeguy]

You need to check for each box and build a SQL statement to include those boxes.