| SitePoint Sponsor |
I working on site for my school and i need to know a few things about checkboxes. I want each checkboxes to insert a true or false data into the feild of the sql database (or a 0/1 or anything else with 2 values). First, i need to know what type of feild i should make those sql feilds (text, int etc). and how i would get those values into the databases. i know how to get text in a textbox submitted, but how would it be different for checkboxes. Thanx!
Checkboxes are either checked or not submitted. When you check to see what value was submitted, you need to check only if it is set, i.e. isset().
As to the database, the best would be an enum field, since it will either be on or off. You can set it to be true/false, t/f, 1/0, etc.
thanx, that was really helpful. but one more thing, what would the html code look like? name="true"? and what is the () all about? i just started php about a month ago, so im not really that knowledgable about it.
isset() is the function. You can go to php.net and click documentation to learn more about that.
The name of the checkbox is the array key it will come through as ($_POST['name']). If it is checked, it will have the value given in the value="true" of the html code. If not checked, nothing of the checkbox goes through.
so it would like like <html name=info() value=true>? i know about the post['info'] thing, the thing im a little confused about is the html form code.. but thanx.
Not quite:
<input type="checkbox" name="mybox" value="true">
If it is checked, then $_POST['mybox'] would be set, with a value of "true". If not checked, then $_POST['mybox'] would not exist.
So you would check like this:
And you are ready to store the value in the database.PHP Code:if ( isset( $_POST['mybox'] ) ) {
$variable = "true";
}
else {
$variable = "false";
}
Or however you want to do it.
Thanx, that was really helpful, i got it working.now all i gotta do is get that info to come up on a dropdown menu, ut thats for a nother topic. Thanx again!
Posting Permissions
Bookmarks