How to correctly insert datetime into MYSQL database using HTML form?

Question

I have what seems to be a relatively simple issue that has caused more problems than I thought it would. As you probably know, HTML5 no longer supports the "datetime" input for a form field, and only supports "datetime-local". When I try to insert "datetime-local" into my database through a form on my website, I obviously get an error because of the extra character included in "datetime-local". What I am trying to do, and why I need a datetime field as opposed to just a date and/or time in their own respective fields is because I want to use Carbon to display my datetime in different formats. How can I insert datetime through HTML form into mysql table without manually inserting the value into my database?

EDIT: Here is all of the relevant code that I am trying to achieve this with. I am using Laravel to build this application

game/create form:

<select name="season_id">

        @foreach ($seasons as $season)

        <option name="season_id" value="{{ $season->id }}">{{ $season->season }} {{ $season->year }}</option>

        @endforeach

</select>

<label for="inputDateTime" class="sr-only">DateTime</label>
    <input type="datetime-local" name="gdatetime" id="inputDateTime" class="form-control" placeholder="DateTime" required autofocus>

<label for="inputOpponent" class="sr-only">Opponent</label>
    <input type="text" name="opponent" id="inputOpponent" class="form-control" placeholder="Opponent" required autofocus>

<label for="inputLocation" class="sr-only">Location</label>
    <input type="text" name="location" id="inputLocation" class="form-control" placeholder="Location" required autofocus>

<label for="inputField" class="sr-only">Field</label>
    <input type="text" name="field" id="inputField" class="form-control" placeholder="Field" required autofocus>

game controller:

$game = Game::create(request(['gdatetime', 'opponent', 'location', 'field', 'season_id']));

Also, in my Game model, I have defined this:

protected $dates = ['gdatetime'];

Is this a user input time/date or is it for record keeping?

GrumpyCrouton
– GrumpyCrouton

2017-05-22 18:05:17 +00:00
Commented May 22, 2017 at 18:05 — GrumpyCrouton
– GrumpyCrouton, Commented May 22, 2017 at 18:05
It's a user input datetime @GrumpyCrouton

develpr
– develpr

2017-05-23 00:52:52 +00:00
Commented May 23, 2017 at 0:52 — develpr
– develpr, Commented May 23, 2017 at 0:52

Sandeesh · Accepted Answer · 2017-05-23 18:16:46Z

1

You can always parse your datetime inputs to carbon instance and store them in the database. Parsing will take care of the headache that comes with formatting the input before storing. You can then display them in any format whenever needed.

$date = \Carbon\Carbon::parse($request->input('datetime'));

Edit : Based on your comments and update, do this.

$data = request(['opponent', 'location', 'field', 'season_id']);

$data['gdatetime'] = \Carbon\Carbon::parse(request('gdatetime'));

$game = Game::create($data);

edited May 23, 2017 at 18:16

answered May 22, 2017 at 18:28

Sandeesh

12k3 gold badges35 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

develpr Over a year ago

I get an error for an undefined variable 'request' when I try this

Sandeesh Over a year ago

@hoolakoola that was an example on how to use form input. You can replace $request->input('datetime') with a datetime value or how you fetch your form input.

develpr Over a year ago

Okay when I change it to $date = \Carbon\Carbon::parse('gdatetime'); I get another error,

DateTime::__construct(): Failed to parse time string (gdatetime) at position 0 (g): The timezone could not be found in the database

Sandeesh Over a year ago

@hoolakoola please understand that you need to pass the datetime value. So if you have $gdatetime with some value then pass it like $date = \Carbon\Carbon::parse($gdatetime); You need to pass the input which holds the value. Why don't you add your current code to your question? You clearly lack some basic knowledge.

develpr Over a year ago

Okay I have updated the question with all the relevant code.

|

Goose · Accepted Answer · 2017-05-22 18:07:50Z

1

Use PHP to convert it.

date('date format here', strtotime($user_input);

date()

strtotime()

And always be sure to validate user input server side, otherwise strtotime() may return false causing date() to return 1969.

answered May 22, 2017 at 18:07

Goose

4,8335 gold badges52 silver badges90 bronze badges

Comments

ambrooo · Accepted Answer · 2017-05-22 18:43:52Z

0

Or you can define this on your model file:

protected $dates = ['your_date_field];

and when you get it from database it will be a Carbon instance.

edited May 22, 2017 at 18:43

answered May 22, 2017 at 18:36

ambrooo

1445 bronze badges

Collectives™ on Stack Overflow

How to correctly insert datetime into MYSQL database using HTML form?

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related