mysql handling Date of Births

ShoulderChip · 17-01-2009 06:55PM #1

Hello,
whats is the best way of entering a date of birth from a form into a mysql database

I would like to use three combo boxes as in day month and year,
but I do not know how to input the results of all three boxes into mysql and also how to validate this,

does anyone have any ideas,

or even just how to validate a text field in the dd-mm-yyyy format

cheers.

Jonathan · 17-01-2009 06:59PM

This for school/college?

ShoulderChip · 17-01-2009 07:01PM

its for a database website I am building for a friend, I am just realising I may not even need to do it this way I could just have the three combo boxes as I dont have a need for calculating age

my one question then would be how can I allow the year field to start on todays year and go back 100 hundred years?
that way it would be future proof.

Jonathan · 17-01-2009 07:36PM

Sounds to me like you are talking about php rather than sql.

Goodshape · 17-01-2009 08:13PM

Actually working on something similar this very minute.

Here's what works for me, maybe you can use it or adapt it.

[php]

$day = $_GET["day"];
$month = $_GET["month"];
$year = $_GET["year"];
$hour = $_GET["hour"];
$minute = $_GET["minute"];

$values = "$year-$month-$day $hour:$minute:00";
[/php]

That final $values is ready to be put into MySQL. That's the format used.

ShoulderChip · 17-01-2009 08:22PM

cheers thanks for that

I am having one other very short problem

I am displaying a table of records, yet i want the user to have the option to filter it

so i have set up a combo list to decide what they want to filter it on (job title etc)

I then have a submit button which submits the form
i then have a second submit button which links to the second page with the result of the combo box attached as an form parameter

My problem is it only works if i click submit 1 and then submit 2 i have tried everything to get a single submit button to post the form and then link to the page with the form parameter but with no link

Adam · 17-01-2009 08:30PM

for outputting the year selector:

[php]
<?

$current_year=date('Y');
$earliest_year=$current_year-101;

for($year=$current_year; $year>$earliest_year; $year--) {
$options.="<option value='$year'>$year</option>";
}

?>

<select>
<?= $options; ?>
</select>
[/php]

ShoulderChip · 17-01-2009 08:42PM

Edit I figured out the two submit buttons.
cheers.

mysql handling Date of Births

Comments