insert DOB using html form into database using php

hi
i want to insert employees DOB into database through html forms but my code is not working....only empty record is shown in the database in edob ..rest of the records are working properly........like ecode,ename etc....i am using date as a datatype in database and my format of date is yy-mm-dd
i m sending the html and php coding below.

Expand|Select|Wrap|Line Numbers

    <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>

Expand|Select|Wrap|Line Numbers

 
<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>

Feb 2 '10 #1

Subscribe Post Reply

20765

dgreenhouse

250

Expert 100+

The first thing I noticed is that you've given the year, month and day (date) select elements the same name (edob). That won't work...

Name them differently... Maybe edoby, edobm, and edobd respectively.

Or create and array by naming them: edob[].

Named separately:

Expand|Select|Wrap|Line Numbers

 
Array

(

    [edoby] => 1982

    [edobm] => apr

    [edobd] => 8

    [submit] => click

)

Named as an array:

Expand|Select|Wrap|Line Numbers

 
Array

(

    [edob] => Array

        (

            [0] => 1982

            [1] => apr

            [2] => 8

        )
 
    [submit] => click // note: although not mandatory, it's a good habit to name your submit button

)

Then construct your dob value for database insertion from there...

Feb 2 '10 #2

rishab

you could this array code i understand ..but i dont understand which one page i write or includes your code

please rply shortly

Jul 15 '16 #3

by: Venus | last post by:

Hi all, Newbie here!! I have 4 forms(A,B,C,D) and a thank you page for my questionnaire. People will be redirected to B or C depending on the last question's answer. B or C will redirect to D...

PHP

Insert into MySQL database using html form and php

by: aseaman | last post by:

I am a big novice with MySQL and PHP. I need a script that enters information from a html form into a MySQL database. Can anyone tell me where I can find one that I can just replace the table and...

PHP

Imports errror while attempting Insert

by: | last post by:

I'm picking up an 'IMPORTS' error for a simple database insert based on two input entry boxes in my form? It says an 'Imports' statement must preceede any declarations....... is this perahps the...

ASP.NET

Connect Form to Database Insert Code

by: | last post by:

I am having trouble figuring out to call a database INSERT procedure from a simple submit form. It appears I should use the onclick event to trigger the procedure called BUT when I do this I...

ASP.NET

ASP.NET Need Help With WEB MATRIX Insert

by: Polyhedron_12 | last post by:

I am having problems calling functions in general in VB. I keep getting alot of errors. Can anybody help me out with this? I put the error message on the same line that it says it is at. I believe...

Visual Basic .NET

Please help : System.Data.OleDb.OleDbException: Syntaxerror in INSERT INTO statement error

by: Joe | last post by:

Hello All, I am trying to insert a record in the MS Access DB and for some reason I cannot get rid of error message, System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. ...

Visual Basic .NET

Problem with handling table insert from ASP page

by: Jack | last post by:

Hi, I am gathering the input values to a form using Request.form method from the processing page. After all the data is captured, I am building sql statement out of it. Using a response.write...

ASP / Active Server Pages

PHP insert

by: Bonzol | last post by:

Hello, PHP n00b here. Using SQL just working off some examples, I have no problem selecting data, but I cant seem to be able to insert. If someone could see where im going wrong <!DOCTYPE...

PHP

Why does DetailsView become read-only after insert?

by: =?Utf-8?B?bXBhaW5l?= | last post by:

Hello, I am completely lost as to why I can't update a DropDownList inside a DetailsView after I perform an insert into an object datasource. I tried to simply it down to the core demostration:...

ASP.NET

insert html web page/form to sql database

by: studentofknowledge | last post by:

hi my knowledgeable comrads I have created a web form using html, css with the addition of some basic javascript validation. Although now im having trouble to insert this information to my local...

Microsoft SQL Server

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

insert DOB using html form into database using php

Similar topics