For my new code that I'm developing, I have a text box where a user will type in a date as follows:

MM/DD/YYYY (e.g. 05/19/2011)

This date then needs to be converted and inserted into a date/time field on a mySQL database. I've been trying to play around with this a bit though and have been having trouble getting it to register on the database. Any idea on how best to format this field and insert it into the DB?

Also, one option I had thought about is maybe using a javascript dropdown calendar or something, any good recommendations?

Thanks!

datetime.createfromformat
should cover the neccesary formatting, produces a datetime that you can dump straight into the db

<?php // part of the php script sanitizing the data for input to db where the form date field is inputdate
$DBdate = date_create_from_format('n/d/Y|', $inputdate); // trailing | sets time to 0 
?>

the sql to update the database is pretty ordinary, ignore inputdate and Insert into table $name $details $DBdate etc

one option is to use jquery-ui datepicker. google for jquery-ui,

IF you want to insert in any other format in mysql then, write your insert query as follows. You may use str_to_date format

$query="insert into tablename value(col1,datecol) 
values ('{$_POST['col1']}',str_to_date('{$_POST['datecol']}','%m/%d/%Y')) ";

Better use the calendar script. I have attached the calendar files here and the code here. its very simple and easy to use. No need of any conversion

<head>
    <script type="text/javascript" src="DatePicker/calendar.js"></script>
    <script type="text/javascript" src="DatePicker/calendar-setup.js"></script>
    <script type="text/javascript" src="DatePicker/calendar-en.js"></script>
    <link rel="stylesheet" href="DatePicker/calendar-win2k-2.css" />
</head>

<body>
   <input name="fromdate" type="text" class="text_box" id="fromdate" value="<?php echo date('Y-m-d');?>" size="18" readonly="readonly" />
   <img src="images/calendar.png" border="0"  id="date_picker_from" title="Date selector" style="cursor:pointer;" >
                                        <script type="text/javascript">
                                            Calendar.setup({
                                                inputField     :    "fromdate",     // id of the input field
                                                ifFormat       :    "%Y-%m-%d",      // format of the input field
                                                button         :    "date_picker_from",  // trigger for the calendar (button ID)
                                                align          :    "Tl",           // alignment (defaults to "Bl")
                                                singleClick    :    true
                                            });
                                        </script> 
</body>

datetime.createfromformat
should cover the neccesary formatting, produces a datetime that you can dump straight into the db

<?php // part of the php script sanitizing the data for input to db where the form date field is inputdate
$DBdate = date_create_from_format('n/d/Y|', $inputdate); // trailing | sets time to 0 
?>

the sql to update the database is pretty ordinary, ignore inputdate and Insert into table $name $details $DBdate etc

Thank you all for your suggestions. Bob, I'm trying to use this function and I keep getting the following error --

Fatal error: Call to undefined function date_create_from_format() in xxxxxx on line 13
Member Avatar for diafol

re: date_create_from_format

You need at least php 5.3. Check your version.

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.