Dynamically getting default values in "select" boxes?

amycrystal123

Hi,

Hope you can just throw some light into this problem as I have been breaking my head thinking of a solution.

I have stored the user's personal information in my MySql database, which includes, name and DOB and other information. The date of birth (DO😎, I had used 2 select boxes for Month and Day and one text box for year.

Now, I am making the user update his profile and when the page is invoked, I get the year value in text. But, how I can dynamically change the "select box" value as per the database value (for example, month: 05 and day: 21). I hope you get my question. When the user loads the "update" page, he gets all his information popped from the database on the page. Right now, I cannot make the default values for the "select" boxes point to the database values.

Awaiting your reply.

Thanks again.

Amy.

LordShryku

How are the values stored in the database? One field for each or did you combine them all into a date field?

amycrystal123

Hi,
This is Amy who posted the first message. The values in the database are stored in the "date" format (with month, days and year) combined.
But, when I input DOB from user or update that, the date of birth is in the form of 3 input fields (select boxes for month and day, text box for year).

This is the answer to your question. Hope I find a solution! Thanks!🙁

LordShryku

Ok, so you need to split them up to get the values. Here's a rough idea of how to do it. You explode the date in the database on the "-" character, then the ternary operator in the options will determine if it should be selected. Modify this to fit your situation.

<?php
$sql = "SELECT date_of_birth
        FROM   table
        WHERE  user = 'blah'";

$res   = mysql_query($sql);
$dob   = mysql_fetch_row($res);
$split = explode("-",$dob[0]);
$year  = $split[0];
$month = $split[1];
$day   = $split[2];
?>
<b>Month</b>: <select name="month">
<?php
for($i=1;$i<13;$i++) {
?>
  <option value="<?=$i?>"<?=($i==$month)?" selected":""?>><?=$i?></option>
<?php
}
?>
</select>
<br />
<b>Day</b>: <select name="day">
<?php
for($i=1;$i<31;$i++) {
?>
  <option value="<?=$i?>"<?=($i==$day)?" selected":""?>><?=$i?></option>
<?php
}
?>
</select>
<br />
<b>Year</b>: <select name="year">
<?php
for($i=1900;$i<=date("Y");$i++) {
?>
  <option value="<?=$i?>"<?=($i==$year)?" selected":""?>><?=$i?></option>
<?php
}
?>
</select>