insert DOB through html form into database using php

Question

preetg 0 Junior Poster in Training

14 Years Ago

hello...........
i m facing problem regarding storing DOB of employee into database using html form
m using date as a datatype and in database format for date is yy-mm-dd....
all other fields are properly working and storing into database but dob filed shown empty....

<html>
    <head><title> Employee Data</title></head>
  <body bgcolor="pink">
  <form method="POST" action="empprins.php">
   <h3> <p align="center"> Employee Personal Detail </h3>   </p>
      <table <p align="center">
   <tr> <th>Employee Code :</th><td> <input type="text" name="ecode" size="20"/></td></tr>
  <tr><th>Employee Name: </th><td><input type="text" name="ename" size="20"/>       </td></tr>
 <tr><th> Employee Education:</th><td> <input type="text"  name="eedu" size="20">   </td></tr>
 <tr><th> Gender:</th><td> Male<input type="radio" name="egender" value="Male"></td>
 <td> Female<input type="radio" name="egender" value="female"></td></tr>
  <tr> <th>DOB <td>
  <select size="1" name="edob" value="Year">
   <option>Year</option>
   <option>1980</option>
   <option>1981</option>
   <option>1982</option>
   <option>1982</option>
   <option>1983</option>
   <option>1984</option>
   <option>1985</option>
   <option>1986</option>
   <option>1987</option>
   <option>1988</option>
   <option>1989</option>
   <option>1990</option>
   <option>1991</option>
   <option>1992</option>
   <option>1993</option>
   <option>1994</option>
   <option>1995</option>
   <option>1996</option>
   <option>1997</option>
   <option>1998</option>
   <option>1999</option>
   <option>2000</option>
   <option>2001</option>
   <option>2002</option>
   <option>2003</option>
   <option>2004</option>
   <option>2005</option>
   <option>2006</option>
   <option>2007</option>
   <option>2008</option>
   <option>2009</option>
   <option>2010</option>
</select>
  <select size="1" name="edob" value="month">  </th>
  <option>month</option>
   <option>jan</option>
   <option>feb</option>
   <option>mar</option>
   <option>apr</option>
   <option>may</option>
   <option>june</option>
   <option>july</option>
   <option>Aug</option>
   <option>Sep</option>
   <option>Oct</option>
   <option>Nov</option>
   <option>Dec</option>
</select>
<select size="1" name="edob" value="date">
   <option>date</option>
   <option>1</option>
   <option>2</option>
   <option>3</option>
   <option>4</option>
   <option>5</option>
   <option>6</option>
   <option>7</option>
   <option>8</option>
   <option>9</option>
   <option>10</option>
   <option>11</option>
   <option>12</option>
   <option>13</option>
   <option>14</option>
   <option>15</option>
   <option>16</option>
   <option>17</option>
   <option>18</option>
   <option>19</option>
   <option>20</option>
   <option>21</option>
   <option>22</option>
   <option>23</option>
   <option>24</option>
   <option>25</option>
   <option>26</option>
   <option>27</option>
   <option>28</option>
   <option>29</option>
   <option>30</option>
   <option>31</option>
</select> </td></tr>
<tr><th>Father/Husband Name:</th><td><input type="text" name="ef_hname" size="20"></td></tr>
<tr><th>Father/Husband Occu:</th><td><input type="text"  name="ef_hoccu" size="20"></td></tr>
<tr><th> Address1:</th><td><textarea rows="2" cols="20" name="eadd1"> </textarea></td></tr>
<tr><th> Adreess2:</th><td><textarea rows="2"  cols="20" name="eadd2" ></textarea></td></tr>
<tr><th> City </th><td><select size="1" name="ecity" value=""> <BR>
   <option>none</option>
   <option>Ludhiana</option>
   <option>Chandigarh</option>
   <option>Jalandhar</option>
   <option>Mohali</option>
   <option>Moga</option>
   <option>Ferozpur</option>
   <option>Faridkot</option>
   <option>Samrala</option>
   <option>Ambala</option>
</select></td></tr>
<tr><th> State:</th><td><select size="1" name="esta" value="">
   <option>none</option>
   <option>Punjab</option>
</select></td></tr> <BR>
<tr><th>Pin No:</th> <td> <input type="text" name="epin" size="20">   </td></tr>
<tr><th>Contact No:</th> <td> <input type="text"  name="etel" size="20">   </td></tr>
 </p> </table>
  <input type="submit" value="SAVE">
 </form>
 </body>


 </html>

<HTML>
<HEAD>
 <TITLE>New Document</TITLE>
</HEAD>
<BODY>
<?
 $ecode = $_POST["ecode"];
 $ename = $_POST["ename"];
$edob =$_POST["edob"];
$egender=$_POST["egender"];
$eedu =$_POST["eedu"];
$ef_hname=$_POST["ef_hname"];
$ef_hoccu=$_POST["ef_hoccu"];
$eadd1=$_POST["eadd1"];
$eadd2=$_POST["eadd2"];
$ecity=$_POST["ecity"];
$esta=$_POST["esta"];
$etel=$_POST["etel"];
$epin=$_POST["epin"];

$con = mysql_connect("localhost","root","root");
 if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  mysql_select_db("master", $con);

 $query="INSERT INTO emp_personal  VALUES  ('$ecode','$ename','$edob','$egender','$eedu','$ef_hname', '$ef_hoccu','$eadd1','$eadd2','$ecity','$esta', '$etel','$epin')";
   if (mysql_query($query, $con))
   {
echo "record added!";

}
else
{
echo "something went wrong";
}
mysql_close($con)
?>
</BODY>
</HTML>

php

2 Contributors
1 Reply
7K Views
7 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by tomatocms

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

tomatocms 0 Newbie Poster · Answer 1 · 2010-02-02T19:13:48+00:00

Try this:

1) Make a HTML more clear by using three separated fields for DOB filed:

<select name="yearOfBirth">
  <option value="">---Select year---</option>
  <?php for ($i = 1980; $i < date('Y'); $i++) : ?>
  <option value="<?php echo $i; ?>"><?php echo $i; ?></option>
  <?php endfor; ?>
</select>

<select name="monthOfBirth">
  <option value="">---Select month---</option>
  <?php for ($i = 1; $i <= 12; $i++) : ?>
  <option value="<?php echo ($i < 10) ? '0'.$i : $i; ?>"><?php echo $i; ?></option>
  <?php endfor; ?>
</select>

<select name="dateOfBirth">
  <option value="">---Select date---</option>
  <?php for ($i = 1; $i <= 31; $i++) : ?>
  <option value="<?php echo ($i < 10) ? '0'.$i : $i; ?>"><?php echo $i; ?></option>
  <?php endfor; ?>
</select>

2) Get the posted data:

$yearOfBirth = $_POST['yearOfBirth'];
$monthOfBirth = $_POST['monthOfBirth'];
$dateOfBirth = $_POST['dateOfBirth'];

// Validate
if ($yearOfBirth != '' && $monthOfBirth != '' && $dateOfBirth != '') {
  // Generate date of birth in format of YYYY-mm-dd
  $date = $yearOfBirth.'-'.$monthOfBirth.'-'.$dateOfBirth;
  
  // Then insert to database as normal
  ...
}