PHP - Date Of Birth Drop Down Selection

I need to add date of birth field to registration form and then save it to databse. I cannot figure out what might be best way of storing the date in the table. I could convert it to unix epoch time, or I could do YYYYMMDD.   Thoughts? What would be the easiest method of saving the DOB? I am not asking on how to do it, just the format. Thanks

$username = $_POST['username'];
$password = $_POST['password'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];

$query = mysql_query("INSERT INTO users VALUES ('','$username','$password','$month','$day','$year')
mysql_query($query);


The code above is a sample of what I have but what I want is to store an entire birthdate in ONE SQL cell. More like this...


$username = $_POST['username'];
$password = $_POST['password'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];

$query = mysql_query("INSERT INTO users VALUES ('','$username','$password','$birthdate')
mysql_query($query);


How is this possible? Can I do this and actually use it efficiently in the future?

Can you please help how to validate the date of birth in code igniter including leap years 

Since I didn't want to type it out myself I wrote a small Date of Birth drop down menu generator.

Now I'm wondering how I can make the code copy-able in a text area?

The script should be inserting all the code ready and finished into a textarea so you can copy and go.

How is it done?


Here's the script:


<?php
echo "<center>";
?>
<form action='' method='POST'>
<input type='submit' name='submit' />
</form>
<?php
$submit = $_POST['submit'];


if ($submit) {

echo "<form action='' method='POST'>";
echo "<select name='month'>";

for ($m = 01; $m <= 12; $m++) {

echo " <option value='" . $m . "'>" . $m . "</option> ";

}

echo "</select>";
echo "<select name='day'>";

for ($d = 01; $d <= 31; $d++) {

echo " <option value='" . $d . "'>" . $d . "</option> ";

}

echo "</select>";
echo "<select name='year'>";

for ($y = 1900; $y <= 2010; $y++) {

echo " <option value='" . $y . "'>" . $y . "</option> ";

}

echo "</select>";
echo "</form>";
echo "</center>";
}

?>

Hi All,

I have 2 tables:

one
CarMake
- CarMakeID
- CarMakeDesc

two
CarModel
- CarModelID
- CarModelMake
- CarModelDesc

Depending on what the user selects in the first dropdown (carmake)
the possible selection in the second dropdown (model) needs to be limited to only the models from the selected carmake.
in the second table (Carmodel : the 'CarModelMake' = CarMakeID, to identify the make)

How do I limit the dropdown 'CarModel' based on the selected CarMake in the first dropdown.

link :    http://98.131.37.90/postCar.php


code :
-- -- --
Code: [Select]



<label>
            <select name="carmake" id="CarMake" class="validate[required]" style="width: 200px;">

          <option value="">Select CAR MAKE...</option>

            <?php while($obj_queryCarMake = mysql_fetch_object($result_queryCarMake)) { ?>
                <option value="<?php echo $obj_queryCarMake->CarMakeID;?>"
                <?php if($obj_queryCarMake->CarMakeID == $CarAdCarMake) { echo 'selected="selected"'; } ?> >
                <?php echo $obj_queryCarMake->CarMakeDesc;?></option>
            <?php } ?>

        </select>
</label>

        <label>
<select name="carmodel" id="CarModel" class="validate[required]" style="width: 200px;">

          <option value="">Select MODEL...</option>

            <?php while($obj_queryCarModel = mysql_fetch_object($result_queryCarModel)) { ?>
                <option value="<?php echo $obj_queryCarModel->CarModelID;?>"
                <?php if($obj_queryCarModel->CarmodelID == $CarAdCarModel) { echo 'selected="selected"'; } ?> >
                <?php echo $obj_queryCarModel->CarModelDesc;?></option>
            <?php } ?>

        </select>
</label>



I'm a novice.. and appreciates all the help !

I am creating a form that will allow the user to select the make of vehicle "FORD" for example. If that make of vehicle is selected among different makes of vehicles, then another box will appear, with all the models for that particular model "Fiesta" for example.

What type of code accomplishes this setup in my web page? I do not want to list 500 models in one drop down list, but just those for each make in the first drop down list.

Thanks much!

guys i have this  dropdown menu

echo "<form method=\"post\" action=\"\">";

echo "<center><select name=\"mydropdown\" size=\"0\" style=\"height:4em; width:15em;\">";

echo "<option value=\"Milk1\">{$_SESSION['tem1']}</option>";
echo "<option value=\"Milk2\">{$_SESSION['tem2']}</option>";
echo "<option value=\"Milk3\">{$_SESSION['tem3']}</option>";

echo "</select></center>";
echo "</form>";

and i wand to update a variable every time i select one of the contents...


how can i done this???

If I have a drop-down list...
Code: [Select]
<select name="attendees">
                        <option value="">--</option>
                        <option value="1">1</option>
                        <option value="2">2</option>
                        <option value="3">3</option>
                        <option value="4">4</option>
                    </select>


Where does the value that the user selects get stored?


Does it get stored in $_POST by default (if a Form is used)?

What variable would hold the selected value?



Debbie

I am trying to make a Web Form for people to fill out that has two drop down menus where i want the first drop down menu's selection changes the values of the selections in the second drop down. ((IE. If the first drop down value is "product 01" then the second drop down shows values "Red, Green, Blue" while if the first drop down value is "product 02" then the second drop down shows values "Yellow, Green"))
Anyone have any ideas? Thanks in Advance.

Hello,
i want to reproduce a content switcher based on drop-down menu (example: http://www.infocercetare.ro/index.php) anyone can help me with the logic of the function the rest i think i can handle.

best regards

Need some help to define the php logic to echo back a selection if/when chosen from the drop down menu.
Note: I'm using just a small subset of the USA states to show setup and what I'm trying to accomplish - it will be the same for all the other drop down menus as well....

Here's the example code:

Code: [Select]

<form name="form1" method="post" action="<?php $_SERVER[PHP_SELF]; ?>">
<select name="address_state" id="address_state" tabindex="25">
<option value="" selected> - Select State -</option>
<option value="AK">Alaska</option>
<option value="AL">Alabama</option>
<option value="AR">Arkansas</option>
<option value="AZ">Arizona</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DC">District of Columbia</option>
</select>

<input name="submit" type="submit" value="submit" tabindex="900" id="submit" />
</form>

Issue: I have validation (logic) define to check all the (other) text, radio, and check boxes of the form and that all works great! However, any time one of those particular fields fail validation, any selected "drop down" item is lost - it defaults back to no selection and the user has to make all drop down menu selections again.

Can someone provide method to echo back - in php being the page reloads to itself - the drop down selection as in the example above?
Thanks!

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=341998.0

My problem is when the entries in the form are validated and some fields with incorrect entries are found the fields filled out stay on the re-load of the form, all of them except the US States drop down menu which reverts back to Alabama every time.

I would like to see that the user selection stays in place even after a re-load of the form. and with my limited experience I am having an issue trying to figure this out for a school project.

Any help at all would be greatly appreciated, like what variables to create/call on and where exactly I insert this code.

Much appreciated.

here is the display code:
 

<?php
/* Program name: exercise_4_form.inc
* Description: Defines a form that collects a user's
* name and mailing address.
*/
$rows = array( "first_name" => "First Name (optional)",
"last_name" => "Last Name",
"phone" => "Phone Number",
"city" => "City",
"state" => "State",
"address" => "Address",
"zip_code" => "ZIP Code",
"e_mail" => "E-Mail");

$states_list = array('AL'=>"Alabama",'AK'=>"Alaska",'AZ'=>"Arizona",
'AR'=>"Arkansas",'CA'=>"California",'CO'=>"Colorado",'CT'=>"Connecticut",
'DE'=>"Delaware",'DC'=>"District Of Columbia",'FL'=>"Florida",'GA'=>"Georgia",
'HI'=>"Hawaii",'ID'=>"Idaho",'IL'=>"Illinois", 'IN'=>"Indiana", 'IA'=>"Iowa",
'KS'=>"Kansas",'KY'=>"Kentucky",'LA'=>"Louisiana",'ME'=>"Maine",
'MD'=>"Maryland", 'MA'=>"Massachusetts",'MI'=>"Michigan",'MN'=>"Minnesota",
'MS'=>"Mississippi",'MO'=>"Missouri",'MT'=>"Montana",'NE'=>"Nebraska",
'NV'=>"Nevada",'NH'=>"New Hampshire",'NJ'=>"New Jersey",'NM'=>"New Mexico",
'NY'=>"New York",'NC'=>"North Carolina",'ND'=>"North Dakota",'OH'=>"Ohio",
'OK'=>"Oklahoma", 'OR'=>"Oregon",'PA'=>"Pennsylvania",'RI'=>"Rhode Island",
'SC'=>"South Carolina",'SD'=>"South Dakota",'TN'=>"Tennessee",'TX'=>"Texas",
'UT'=>"Utah",'VT'=>"Vermont",'VA'=>"Virginia",'WA'=>"Washington",'WV'=>"West Virginia",
'WI'=>"Wisconsin",'WY'=>"Wyoming");


$submit = "Submit mailing information";
?>
<html>
<head>
<style type='text/css'>
<!--
body {
background: #42413C;
color: #000;
font-family: Tahoma, Geneva, sans-serif;
font-size: 90%;
}
form {
margin: 1em 2 2 2;
padding: 1;
width: 1100px;
margin-left: 35%;

}
.field {padding-bottom: 1em;

}
label {
font-weight: bold;
float: left;
width: 15%;
margin-right: 1em;
text-align: right;
background-color: #9F6;
padding-right: 5px;

}
select {margin-bottom: 1em;}

#submit {
margin-left: 15%;
}
h3 {
width: 500px;
margin-left: 35%;
}


-->
</style>
</head>
<body>
<h3>Please enter your mailing information below:</h3>
<?php
/* loop that displays the form */
echo "<form action='$_SERVER[PHP_SELF]' method='POST'>";
foreach($rows as $field => $label)

if($field == "state")
{
echo "<label for='$field'>$label</label>
<select id='$field' name='$field'>\n";

foreach ( $states_list as $abbr => $sname )
{
echo "<option value='$abbr'>$sname</option>\n";
}
echo "</select>\n";
}
else
{
echo "<div class='field'><label for='$field'>$label</label>
<input id='$field' name='$field' type='text' value='".@$$field."'
size='25%' maxlength='65' /></div>\n";
}

echo "<div id='submit'>
<input type='hidden' name='submitted' value='yes'>
<input type='submit' value='$submit'></div>";
?>

</form>
</body>
</html>

Here is the Logic on the combined php file that displays and has the statements on it for the form:
 

<?php
/* Program name: exercise_4_form_verifications.php
* Description: Program checks all the form fields for
* blank fields and verifies them
*/

if(isset($_POST['submitted']) and $_POST['submitted'] == "yes")
{
foreach($_POST as $field => $value)
{
if(empty($value))
{
if($field != "first_name")
{
$blank_array[] = $field;
}
}
else
{
$good_data[$field] = strip_tags(trim($value));
}
}



if(@sizeof($blank_array) > 0)
{
$message = "<p style='color: black; margin-bottom: 0;font-weight: bold; margin-left: 35%'>
You didn't fill in one or more required fields.
You must enter:
<ul style='color: yellow; margin-top: 0; margin-left: 35%;
list-style: none' >";

foreach($blank_array as $value)
{
$message .= "<li>$value</li>";
}
$message .= "</ul>";
echo $message;
extract($good_data);
include("exercise_4_form.inc");
exit();
}
foreach($_POST as $field => $value)
{
if(!empty($value))
{
$name_verify = "/^[A-Za-z' -]{1,50}$/";
$phone_verify = "/^[0-9)(xX -]{7,20}$/";
$city_verify = "/^[A-Za-z' -]{1,50}$/";
$address_verify = "/^[A-Za-z0-9 .,'-]{1,50}$/";
$zip_verify = "/^[0-9]{5}(\-[0-9]{4})?$/";
$e_mail_verify = "/^.+@.+\\..+$/";

if(preg_match("/last/i",$field))
{
if(!preg_match($name_verify,$value))
{
$error_array[] = "$value is not a valid last name";
}
}
if(preg_match("/phone/i",$field))
{
if(!preg_match($phone_verify,$value))
{
$error_array[] = "$value is not a valid phone number";
}
} // endif phone format check
if(preg_match("/city/i",$field))
{
if(!preg_match($city_verify,$value))
{
$error_array[] = "$value is not a valid city";
}

}
if(preg_match("/address/i",$field))
{
if(!preg_match($address_verify,$value))
{
$error_array[] = "$value is not a valid address";
}
}
if(preg_match("/zip/i",$field))
{
if(!preg_match($zip_verify,$value))
{
$error_array[] = "$value is not a valid ZIP code";
}
}
if(preg_match("/e_mail/i",$field))
{
if(!preg_match($e_mail_verify,$value))
{
$error_array[] = "$value is not a valid e-mail address";
}
}
}
$clean_data[$field] = strip_tags(trim($value));
}
if(@sizeof($error_array) > 0)
{

$message = "<ul style='color: yellow; margin-top: 0; margin-left: 35%;
list-style: none' >";
foreach($error_array as $value)
{
$message .= "<li>$value</li>";
}
$message .= "</ul>";


echo $message;
extract($clean_data);
include("exercise_4_form.inc");
exit();
}
else
{
echo "<ol>";
foreach($_POST as $field => $value)
{ echo "<h3><li> $field = $value</li></h3>";
}
echo "</ol>";
}
}
else
{
include("exercise_4_form.inc");
}
?>

Edited by mac_gyver, 15 November 2014 - 12:14 PM.
code tags around posted code please

hello there.. i have a problem with my php coding where i want to keep date choose by user in the database.


this is the drop down date
Code: [Select]
<select name="Date_Day">
<option> - Day - </option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="Date_Month">
<option> - Month - </option>
<option value="01">January</option>
<option value="02">Febuary</option>
<option value="03">March</option>
<option value="04">April</option>
<option value="05">May</option>
<option value="06">June</option>
<option value="07">July</option>
<option value="08">August</option>
<option value="09">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="Date_Year">
<option> - Year - </option>
    <option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
    <option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
    <option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>
</select>
     
the code to connect to the database
Code: [Select]
      $date_year= ($_POST['Date_Year']);
$date_month=($_POST['Date_Month']);
$date_day=($_POST['Date_Day']);
                $date=$date_year."-".$date_month."-".$date_day;

$query="INSERT INTO aduan (date)
VALUES ('date($date)')";
$result=mysql_query($query);
if($result){
echo 'Registration success.';
?><script>window.location ='thanks.php'</script>
<?php
}
else
echo 'Registration failed';}
when enter a value of date, the database will just show '0000-00-00'.. really hope for your help.. 

I am trying to insert a date into a mySQL table from html drop downs with php. Right now when I enter the date it goes into the database as 0000-00-00. Can anybody see why it might be doing this?

My html:
Code: [Select]
<label for='birthdate' >Birthdate (Optional):</label><br/>
    <select name='month' id='month' value='<?php echo $fgmembersite->SafeDisplay('month') ?>'>
<option value="01" selected="January">January</option>
<option value="02">February</option>
<option value="03">March</option>
        etc...
    </select>&nbsp;&nbsp;
    <select name='day' id='day' value='<?php echo $fgmembersite->SafeDisplay('day') ?>'>
<option value="01" selected="1">1</option>
<option value="02">2</option>
<option value="03">3</option>
etc...
    </select>&nbsp;&nbsp;
    <select name='year' id='year' value='<?php echo $fgmembersite->SafeDisplay('year') ?>'>
<option value="2010" selected="2010">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
etc...
    </select>

And my php to collect info:
Code: [Select]
$formvars['birthdate'] = $this->Sanitize($_POST['year'], $_POST['month'], $_POST['day']);
php where I make table:
Code: [Select]
"birthdate DATE NOT NULL ,".

php to insert into mysql:
Code: [Select]
$insert_query = 'insert into '.$this->tablename.'(
                name,
address,
birthdate,
sex,
program,
guide,
                email,
                username,
                password,
                confirmcode
                )
                values
                (
                "' . $this->SanitizeForSQL($formvars['name']) . '",
"' . $this->SanitizeForSQL($formvars['address']) . '",
"' . $this->SanitizeForSQL($formvars['birthdate']) . '",
"' . $this->SanitizeForSQL($formvars['sex']) . '",
"' . $this->SanitizeForSQL($formvars['program']) . '",
"' . $this->SanitizeForSQL($formvars['guide']) . '",
                "' . $this->SanitizeForSQL($formvars['email']) . '",
                "' . $this->SanitizeForSQL($formvars['username']) . '",
                "' . md5($formvars['password']) . '",
                "' . $confirmcode . '"
                )'; 

Thank you!