0

Hello,
I am trying to save the date field into mysql table.
The date field in my jsp form is in format MM/DD/YYY and in database as YYYY/MM/DD.
How can I retrieve the date from form and insert into the table with YYYY/MM/DD format ?

2
Contributors
1
Reply
22
Views
1 Year
Discussion Span
Last Post by Steven_10
0

There are several ways to get your date formated before database insertion. A newer way is to take advantage of HTML5's "date" type. The date type works in most newer versions of all the major browsers But keep in mind older browsers (I'm not exactly sure on which ones--google it) won't see the "date" type as anything other than a text field and will not format the date. Here is an example that just writes the formated date back to the screen:

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>HTML5 Date Input</title>
    <style>
        body {
            font-family: "Lucida Sans Unicode", "Lucida Grande", sans-serif;
            color: #1B1B1B;
            margin-left: 30px;
        }
    </style>
</head>

<body>
<h1>HTML5 Date Input</h1>
<form id="form1" name="form1" method="post">
  <p>
    <label for="date">Date:</label>
    <input type="date" name="date" id="date">
  </p>
  <p>
    <input type="submit" name="submit" id="submit" value="Submit">
  </p>
</form>
<?php
if (isset($_POST['submit'])) {
    echo '<p>The selected date is ' . $_POST['date'] . '.</p>';
}    
?>
</body>
</html>

And here is a working example: http://srisservice.com/phpDate/date_input.php

If you know you are going to have older browsers as part of your audience then you can use jQuery to handle it. Here is an example:

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>jQuery UI Datepicker</title>
<link rel="stylesheet" href="https://code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<style>
    body {
        font-family: "Lucida Sans Unicode", "Lucida Grande", sans-serif;
        color: #1B1B1B;
        margin-left: 30px;
    }
</style>
</head>

<body>
<h1>jQuery UI Datepicker</h1>
<form id="form1" name="form1" method="post">
  <p>
    <label for="date">Date:</label>
    <input type="text" name="date" id="date">
  </p>
  <p>
    <input type="submit" name="submit" id="submit" value="Submit">
  </p>
</form>
<?php
  if (isset($_POST['submit'])) {
      $parts = explode('/', $_POST['date']);
      $date = "$parts[2]-$parts[0]-$parts[1]";
      echo '<p>The selected date is ' . $date . '.</p>';
  }  
?>
<script src="https://code.jquery.com/jquery-1.12.3.min.js";></script>
<script src="https://code.jquery.com/ui/1.11.4/jquery-ui.min.js"></script>
<script>
    $(function() {
        $('#date').datepicker({
            //dateFormat: 'yy-mm-dd' // << formats it for database insertion with JavaScript << not good for users though
        });
    });
</script>
</body>
</html>

And here is a working example: http://srisservice.com/phpDate/datepickerTweaked.php
Hope this helps.

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.