How to Insert curent date into mysql

[tutusaint]

I have a registration page which captures details including birth date and registration date.
The birth date and Date is not captured in mysql database.
Please help
Registration.php

<?php
 
if (isset($_POST['Submit'])) {
//$Bday  = date("dd-mm-yyyy");
include "dbCon.php";
 
$EmailAd = $_POST['EmailAd'];
$Password = $_POST['Password'];
$Name = $_POST['Name'];
$Age = $_POST['Age'];
$Gender = $_POST['Gender'];
$Bday = $_POST['Bday'];
$Phone = $_POST['Phone'];
$College = $_POST['College'];
$Course = $_POST['Course'];
$Yr = $_POST['Yr'];
$UserType= $_POST['UserType'];
$Address= $_POST['Address'];
$Interest = $_POST['Interest'];
$Affiliation = $_POST['Affiliation'];
$Schedule = $_POST['Schedule'];
$About = $_POST['About'];
$Who = $_POST['Who'];
 
$query = mysql_query("INSERT into user (EmailAd, Password, Name, Age, Gender, Bday, Phone, College, Course, Yr, UserType, Address, Interest, Affiliation, Schedule, About, Who)
                    VALUES('$EmailAd', '$Password', '$Name', '$Age', '$Gender', '$Bday', '$Phone', '$College', '$Course', '$Yr', '$UserType', '$Address', '$Interest', '$Affiliation', '$Schedule', '$About', '$Who')");
 
if ($query) {        
    session_start();
    $_SESSION['EmailAd'] = $_POST['EmailAd'];                                  
    header ('Location: registerSuccess.php');
    }
else {
    echo ('Failed to Input Data');
    }
}
?>
 

[Moe haroon]

Not sure about mysql, but in oracle I have to convert string to date format either at insert or prior
string mydate="01/01/2010";
insert into test values (to_date(mydate,'MM/DD/YYYY'));

[semanticnotion]

You should use this
for birth date i have three text boxes one for day 2nd for month and 3rd for year

$today_date = $_POST['year']."-".$_POST['month']."-".$_POST['day'];
 
$query="insert into table_name value('$today_date');
 

[nickweavers]

To put the current date into the table for the registration date, you can do this:

$query="
INSERT INTO table_name SET 
`registration_date` = CURRENT_DATE(),
`EmailAd` = '" . mysql_real_escape_string($EmailAd) . "',
`Name` = '" . mysql_real_escape_string($Name) . "',
`Bday` = STR_TO_DATE('".$Bday."','%d/%m/%Y')), " .
...
etc
...
"; 
 

Using mysql_real_escape_string() will help prevent SQL injection error attacks and will also prevent things like the name O'Reilly causing syntax errors in your query.

If you would rather allow people to enter their birthday in a more commonly recognised format, you can allow
mm/dd/yy on the form and use STR_TO_DATE() to convert it for you.

Nick.