0

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!

6
Contributors
6
Replies
14
Views
6 Years
Discussion Span
Last Post by divyakrishnan
0

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

Edited by almostbob: n/a

0

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')) ";

Edited by urtrivedi: n/a

0

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>

Edited by karthik_ppts: n/a

0

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
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.