Jump to content

Multi Menu's for DOB question


Anxious

Recommended Posts

  <tr><td><p><br>
  Date of Birth:<br>
  </p>
  </td>
    <td><br>
      <select name="select1" id="select1">
  <option value="" selected></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="select1" id="select1">
<option value="" selected></option>
<option value="January">January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
<select name="select1" id="select1">
<option value="" selected></option>
<option value="2009">2009</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="etc">etc</option>
</select></td><td><br>
    <? echo $form->error("DOB"); ?></td>
  </tr>

 

"<? echo $form->error("DOB"); ?>" is the error field, I need a value field eg: <? echo $form->value("DOB"); ?> please somewhere, what my question is, how would I set it so that the three, values, would enter in the database under DOB in the format of,

"14/January/1993" etc. If you would like me to paste the code with all the other fields in (Username, password etc) let me know.

 

Thanks

Link to comment
https://forums.phpfreaks.com/topic/153200-multi-menus-for-dob-question/
Share on other sites

Yeah, I did that as I realised it was all included, and yeah, thats what I thought (I'd have to edit the names then, and put seperate values in) Just not sure, where i'd include it.

 

<?php    function addNewUser($username, $password, $email, $gender, $location){
      $time = date("F j, Y, g:i");
      /* If admin sign up, give admin user level */
      if(strcasecmp($username, ADMIN_NAME) == 0){
         $ulevel = ADMIN_LEVEL;
      }else{
         $ulevel = USER_LEVEL;
      }
      $q = "INSERT INTO ".TBL_USERS." ('username','password','ulevel','email','time','gender','location')VALUES ('$username', '$password', $ulevel, '$email', '$time',  '$gender', '$location')";
      return mysql_query($q, $this->connection);
   } ?> 

 

Thats putting the values in the database.

It has this;

$time = date("F j, Y, g:i");

 

For doing the DOB would it be something like, $dob = $_POST['day'] . "/" . $_POST[month'] . "/" . $_POST['year']; As you posted.

 

So it'd be

$time = date("F j, Y, g:i");

$dob = $_POST['day'] . "/" . $_POST[month'] . "/" . $_POST['year'];

 

Is that the idea you meant?

Ok thanks, so the whole database code would look like this?

 

<?php    function addNewUser($username, $password, $email, $day, $month, $year, $location, $gender){
      $time = date("F j, Y, g:i");
  $dob = $_POST['day'] . "/" . $_POST['month'] . "/" . $_POST['year'];
  
      /* If admin sign up, give admin user level */
      if(strcasecmp($username, ADMIN_NAME) == 0){
         $ulevel = ADMIN_LEVEL;
      }else{
         $ulevel = USER_LEVEL;
      }
      $q = "INSERT INTO ".TBL_USERS." ('username','password','ulevel','email','time','gender','location','dob')VALUES ('$username', '$password', $ulevel, '$email', '$time', '$gender', '$location', '$day', '$month', '$year')";
      return mysql_query($q, $this->connection);
   } ?> [code]

I'm guessing 'INSERT INTO etc etc, is wrong.
Thanks

grab the year,month,day from the string using substr then get the current year,month,day via date("",time()) and compare.

 

see now if your doing manipulation on the date i find it easier to store it as an int. then you can get any date info from it via the date function instead of having to parse a string.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.