date Format code help while posting info in to mysql

[nani_nisha06]

HI frnds,

can any one please help me to post dd-mm-yyyy date format to Mysql which is yyyy-mm-dd.


I am struggling lot to solve this but could not able to success it....

my php code is :

<?php
session_start();
$host="localhost"; // Host name 
$username="#############"; // Mysql username 
$password="##########"; // Mysql password 
$db_name="#########"; // Database name 
$tbl_name="#########"; // Table name 
$myusername = $_SESSION['myusername']; //user who updating
$con = mysql_connect("$host","$username","$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="INSERT INTO $tbl_name(`Creation_Date`, `Resolved_Date`, `Analyst`, `Email_Address`, `Status`, `Mail_Sent`, `Call_Made`, `Doc_verf`, `Change2analyst`, `Change3analyst`) 

VALUES 

('$_POST[requiredCD]','$_POST[requiredRD]','$myusername','$_POST[requiredEmail]','$_POST[Status]','$_POST[MailSent]','$_POST[Call]','$_POST[Docverf]','$_POST[Analyst2]','$_POST[Analyst3]')";

$result1=mysql_query($sql)or die(mysql_error());
{
header("location:new_user.php") or die("record not inserted");
}
mysql_close();
?>

Any help is most appreciated !!!!

Regards,
Nani

[Fou-Lu]

Well, since you don't mention which of these it is all I can give is an example. dd-mm-yyyy is valid in php for a date format: http://ca1.php.net/manual/en/datetime.formats.date.php so you can use it in strtotime or dateTime classes.

PHP Code:

$sDate = '02-02-2012';
$dt = new DateTime($sDate);
print $dt->format('Y-m-d'); // 2012-02-02 


You'll want to look into database security or prepared statements as well.

[nani_nisha06]

Originally Posted by Fou-Lu

Well, since you don't mention which of these it is all I can give is an example. dd-mm-yyyy is valid in php for a date format: http://ca1.php.net/manual/en/datetime.formats.date.php so you can use it in strtotime or dateTime classes.

PHP Code:

$sDate = '02-02-2012';
$dt = new DateTime($sDate);
print $dt->format('Y-m-d'); // 2012-02-02 


You'll want to look into database security or prepared statements as well.

Fou-Lu,


Dont mind can you be more specific with example code I have posted .......I am a beginner and trying to understand a lot but it became tuff for me .... so please help me.

In the above code I have created a frontend form for the Creation_Date & Resolved_Date which takes dd-mm-yyyy but when i am posting it should post to database as yyyy-mm-dd..

Regards,
Nani

[Redcoder]

Originally Posted by nani_nisha06

HI frnds,

can any one please help me to post dd-mm-yyyy date format to Mysql which is yyyy-mm-dd.


I am struggling lot to solve this but could not able to success it....

my php code is :

<?php
session_start();
$host="localhost"; // Host name 
$username="#############"; // Mysql username 
$password="##########"; // Mysql password 
$db_name="#########"; // Database name 
$tbl_name="#########"; // Table name 
$myusername = $_SESSION['myusername']; //user who updating
$con = mysql_connect("$host","$username","$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="INSERT INTO $tbl_name(`Creation_Date`, `Resolved_Date`, `Analyst`, `Email_Address`, `Status`, `Mail_Sent`, `Call_Made`, `Doc_verf`, `Change2analyst`, `Change3analyst`) 

VALUES 

('$_POST[requiredCD]','$_POST[requiredRD]','$myusername','$_POST[requiredEmail]','$_POST[Status]','$_POST[MailSent]','$_POST[Call]','$_POST[Docverf]','$_POST[Analyst2]','$_POST[Analyst3]')";

$result1=mysql_query($sql)or die(mysql_error());
{
header("location:new_user.php") or die("record not inserted");
}
mysql_close();
?>

Use strtotime which converts the time you give it to a unix timestamp which can then be easily coverted to any date format you want using the date() function.

Like this:

PHP Code:

<?php
//E.g
$date1 = '$_POST['requiredCD']'; //$Date variable now has date like 23-09-1994

$date_tstamp = strtotime($date1);

$date_converted = date('Y-m-d', $date_tstamp) //Now contains 1994-09-23

The above could have been done with the below one-line code:

PHP Code:

<?php

$date_converted = date('Y-m-d', strtotime($_POST['requiredCD']));  //$date_coverted contains 1994-09-23