Solved

checkbox problem.

Posted on 2009-07-01
10
295 Views
Last Modified: 2012-05-07
i am using checkbox in my form. what datatype i should take in mysql database. like i have a checkbox named sex having options male and female like below.

1) what data type i should take in mysql database
2) how can i retrieve the value using $_REQUEST.

<tr>
<td>Sex</td>
<td colspan="2"><input type="checkbox" name="sex" id="sex" value="male" /></td>
<td align="right">Female</td>
<td colspan="2"><input type="checkbox" name="sex" id="sex" value="female" /></td>
</tr>

please help me.
0
Comment
Question by:designersx
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 28

Accepted Solution

by:
gamebits earned 75 total points
ID: 24754139
Radio button would be more appropriate (you have to choose between the two), checkboxes allows multiple choice.

The data type I used in MySQL when there is a definite choice is ENUM in this example the choices would be

'male','female' anything else would not be inserted.

to retrieve using REQUEST it would be like this

$sex = $_REQUEST['sex'];

but with your script (2 checkboxes with same name) this will cause an issue.

0
 
LVL 8

Expert Comment

by:lharrispv
ID: 24754235
how about making the datatype in the DB a boolean.  Set the feild to female and if they answer male in the form set the boolean value in the DB to false?
0
 

Author Comment

by:designersx
ID: 24754373
gamebits: u r great thanks a lot
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 7

Assisted Solution

by:Vimal DM
Vimal DM earned 50 total points
ID: 24755272
Hi
For making gender details we must use only the option buttons,only then the multiple values won't be selected.
-------
Code
-------
<tr>
<td>Male</td>
<td colspan="2"><input name="rdgender" type="radio" value="1">
&nbsp;</td>
<td align="right">Female</td>
<td colspan="2"><input name="rdgender" type="radio" value="2">
&nbsp;</td>
</tr>

after setting of the option buttons like this

use the same method that others said
-----------------------------------------------
echo  $_REQUEST["rdgender"]
-----------------------------------------------
then see the final answer for this.
0
 

Author Closing Comment

by:designersx
ID: 31598869
vimalmaria: and gamebits both have given the good solution but gamebits got the higher marks because i saw his comment and my problem was solved at that time.
0
 
LVL 28

Expert Comment

by:gamebits
ID: 24756528
Than you should have accepted my solution vimalmaria was almost 2 hours late.
0
 
LVL 7

Expert Comment

by:Vimal DM
ID: 24764199
ya gamebits i accept this

i have given with some explanation that's all

good.
0
 
LVL 28

Expert Comment

by:gamebits
ID: 24764240
No offense vimalmaria I guess I just had a bad day, take care.
0
 
LVL 7

Expert Comment

by:Vimal DM
ID: 24769504
Hi,

Ok no issue on this,

sorry for the mistake.

See U

take care
0
 
LVL 7

Expert Comment

by:Vimal DM
ID: 24769512
Hi,

sorry once again
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to fix Datetime in MySQL? 4 51
Ahax pagination 9 33
PHP website on Linux - server DNS address could not be found. 18 50
php error 27 31
Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question