Birthdate Column

I have added a birth date column in the user table. I am unable to figure out how to get the database to include the birth date (the registrants actual date of birth) in the database after including it as a requirement in the registration form.

Does anyone know what the correct settings are in phpMyAdmin?

Thanks!!

johna1964

set the birth date column data type in the database to be date.

the data base will expect the format to be:
yyyy-dd-mm

In the insert record behavior, select the birthdate column, click the lightning bolt next to value and select your birthdate form element, this will add code similar to:
[php]<?php echo((isset($_POST["birthDate"]))?$_POST["birthDate"]:"") ?>

you can convert the entered date to the format the database is expecting by changing that to:

[php<?php echo((isset($_POST["birthDate"]))?date("Y-m-d", strtotime($_POST["birthDate"])):"") ?>

Jason,

Thank you for your reply...I'm still a little confused...

You say 'in the insert record behavior select the birthday column'

So this means in the Server Behaviors panel; double click insert record(users); the Web Assist: Insert Single Record dialog box opens; select binding tab; select UserBirthdate column;

<?php echo ((isset($_POST["Registration_group_Birthdate"]))?$_POST["Registration_group_Birthdate"]:""); ?>

is what is already in the value lightening bolt text box....

When I select the value lightening bolt and expand the Session there is no birthdate to select...

So, what to do?

In the code (lines 244-248):

<div class="lineGroup">
<label for="Registration_group_Birthdate" class="sublabel" > Birthdate:<span class="requiredIndicator">&nbsp;*</span></label>
<div class="errorGroup"> <span id="Registration_group_Birthdate_Spry">
<input id="Registration_group_Birthdate" name="Registration_group_Birthdate" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("registration","Registration_group_Birthdate"):"")); ?>" class="formTextfield_Medium" tabindex="3" onblur="WAValidateDT(document.getElementById('Registration_Basic_Default').Registration_group_Birthdate,'',true,/.*/,'mm/dd/yyyy','','',false,/.*/,'','','',document.getElementById('Registration_Basic_Default').Registration_group_Birthdate,0,true);hideServerError('Registration_group_Birthdate_ServerError')" />
<?php

I have the column in the datebase correct, I think...:)

Sincerely,

johna1964

  So this means in the Server Behaviors panel; double click insert record(users); the Web Assist: Insert Single Record dialog box opens; select binding tab; select UserBirthdate column;

<?php echo ((isset($_POST["Registration_group_Birthdate"]))?$_POST["Registration_group_Birthdate"]:""); ?>

is what is already in the value lightening bolt text box....  

so change that code to:

<?php echo((isset($_POST["Registration_group_Birthdate"]))?date("Y-m-d", strtotime($_POST["Registration_group_Birthdate"])):"") ?>

Jason,

Okay, I changed it to:

<?php echo((isset($_POST["Registration_group_Birthdate"]))?date("Y-m-d", strtotime($_POST["Registration_group_Birthdate"])):"") ?>

It's not passing validation...

Should the spry validation format box be set to a certain format?

And is the "Y-m-d" correct? I'm asking because it just looks like it should be something else...

Thanks!!

johna

the client validation on the birthdate element is conflicting.


change:

<input id="Registration_group_Birthdate" name="Registration_group_Birthdate" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("registration","Registration_group_Birthdate"):"")); ?>" class="formTextfield_Medium" tabindex="3" onblur="WAValidateDT(document.getElementById('Registration_Basic_Default').Registration_group_Birthdate,'',true,/.*/,'mm/dd/yyyy','','',false,/.*/,'','','',document.getElementById('Registration_Basic_Default').Registration_group_Birthdate,0,true);hideServerError('Registration_group_Birthdate_ServerError')" />

to:

<input id="Registration_group_Birthdate" name="Registration_group_Birthdate" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("registration","Registration_group_Birthdate"):"")); ?>" class="formTextfield_Medium" tabindex="3" onblur="hideServerError('Registration_group_Birthdate_ServerError')" />

yes, the format "Y-m-d" is correct, that is the php date() functions format string for yyyy-mm-dd which is the format the database will be expecting.

Jason,

It works perfectly!!

The spry validation does not need to match the db format for the birthdate - and still inserts the birthdate info with the db format...awesome!

Thanks for all your help!!

Johna

you're welcome.

See next reply

This works:
Click on Insert Record (users) in the Server Behaviors Panel
<?php echo((isset($_POST["Registration_group_Birthdate"]))?date("Y-m-d", strtotime($_POST["Registration_group_Birthdate"])):"") ?>

New:
<input id="Registration_group_Birthdate" name="Registration_group_Birthdate" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("registration","Registration_group_Birthdate"):"")); ?>" class="formTextfield_Medium" tabindex="3" onblur="hideServerError('Registration_group_Birthdate_ServerError')" />