[RESOLVED] Date Input From User

[durahman]

I had been searching in this forum for a similar problem but seem I cannot find one, I guess I'll have to write in.

How to do the following:

I want my user to input a date in a form using 'date picker' and then save this in MySql.

code example:

<input name="date_receive" type="text"> ... date picker script .....

the format is dd-mm-YYYY

Now how do I convert this to MySql format - YYYY-MM-DD before I can insert the data "date_receive" into my table's "date_receive" column.

Thanks

[msk_1980]

using the date function and mktime you should be able to do something like:

<?php

$time = '14-01-2006';
$date_elem = explode('-',$time);
$dt = date('Y-m-d', mktime( 0,0,0,$date_elem[1],$date_elem[0],$date_elem[2]) );

echo $dt;
?>

[bpat1434]

Or... [man]strtotime/man

$date = '14-01-2006';
$fomatted = date('Y-m-d', strtotime($date));

Or even just modify it in the query:

INSERT INTO `table` (date)
VALUES (DATE_FORMAT($date, '%Y-%m-%d'))

Either will work...

~Brett

[jeepin81]

Yeah try Bpat's - he know's his stuff!!

[durahman]

Thanks

[GlauSP]

Greetings from Rio de Janeiro, Brazil!

I cannot understand this:

$date = '14-01-2006';
$fomatted = date('Y-m-d', strtotime($date));

How do I put input from the form (field names: day, month, year)
in $date, that is, the variables $year, $month and $day?

Regarding the second option:
Where do I put (date) precisely?
I cannot also understand this:
VALUES (DATE_FORMAT($date, '%Y-%m-%d'))
Where do I put it?

Thanks for your help.

[jmrouleau]

GlauSP wrote:

Greetings from Rio de Janeiro, Brazil!

I cannot understand this:

$date = '14-01-2006';
$fomatted = date('Y-m-d', strtotime($date));

How do I put input from the form (field names: day, month, year)
in $date, that is, the variables $year, $month and $day?

Regarding the second option:
Where do I put (date) precisely?
I cannot also understand this:
VALUES (DATE_FORMAT($date, '%Y-%m-%d'))
Where do I put it?

Thanks for your help.

Ok...first of all the original form was only one text field as I understand it. Besides that, the form either uses POST or GET depending on which you choose. For example if you use POST you get the variables by $variable = $_POST['field name']

The VALUES(DATE_FORMAT.... is run on a MySQL database that is set up to store these values. You have to set up a connection to this database and execute the query.

[GlauSP]

I am using three drop down menus for year, month and day.
I only need to know how to write correctly 'year', 'month' and 'day',
the names of the form fields, in $date_input.

$date_input = 'year-month-day';
$due_date = date('Y-m-d',strtotime($date_input));

Is it?

[GlauSP]

$date_input = 'year-month-day';

Is it?

[jmrouleau]

Ok...do this

if(isset($_POST['submit'])){
$date = $_POST['day'].'-'.$_POST['month'].'-'.$_POST['year']; 
$fomatted = date('Y-m-d', strtotime($date));
}
 

Inside If statement run query to your database using $formatted

Your form tag should look like....

<form name="name" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

//FORM CONTENTS

<submit name="submit" value="Submit">
</form>

[GlauSP]

The result is always 31.12.1969.
But in the flat database I see 2026-07-30.

[jmrouleau]

Attach your script

[GlauSP]

From www.php.net/date:

"The valid range of a timestamp is typically from Fri, 13 Dec 1901 20:45:54 GMT to Tue, 19 Jan 2038 03:14:07 GMT. (These are the dates that correspond to the minimum and maximum values for a 32-bit signed integer). However, before PHP 5.1 this range was limited from 01-01-1970 to 19-01-2038 on some systems (e.g. Windows)."

Does this apply to my problem?

[bpat1434]

Simply put: No. That deals with Timestamps, not date-stamps. The difference is if you create a timestamp, you can use that with the [man]date/man function to put that timestamp into any format (date and time) from an integer.

For your purposes, that really doesn't apply to you.

If you've got 3 drop-downs (Month, Day, Year) and you want to format a string like YYYY-Month-Day, honestly it's as easy as:

<?php
$date = $_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date; // Just to show the formatted date

There is no need to use the [man]date/man function to insert it into a mySQL database. You can just use the properly formatted string (see 4 lines up). It's actually a lot easier than we've been telling you, and I just now realized it. Sorry.

[GlauSP]

I have put it so:

$date_input = $POST['day'].'-'.$POST['month'].'-'.$_POST['year'];
$formatted_date = strftime($message_settings['time_format'], $date_input);

But it does not work.
I always get 31.12.1969.

I'm using a flat database.

[GlauSP]

Thank you very much for your patience.
I have fixed the problem following your precise guidance.

How can I test php scripts on my computer itself, that is, without uploading them to a server and doing it online?

[bpat1434]

Install Apache (or IIS if you're using windows) and PHP. Then just go!!

There are plenty of tutorials for doing this online....