How to save jQuery date picker value to database and retrieve from database

Question

I'm using jQuery date picker. How do I save the selected date value to a SQL date field in the database. And how do I retrieve the date value from the database and have it select the date in the picker?

I find the documentation is scarce for this library.

Thanks in advance!

See if this answer helps. It looks like from the docs that a JavaScript Date() object is returned from the jQuery UI getDate() method. As such, you'll need to complete the conversions manually to SQL and back again... — War10ck
– War10ck, Commented Oct 14, 2019 at 20:37

user11897373 · Accepted Answer · 2019-10-14 20:56:51Z

1

If you use PHP between jquery and DB you can do manually conversion with:

//Create Date object from a specified format
$date = DateTime::createFromFormat('d/m/Y', $_REQUEST["dateFromPicker"]);

//From date Object to a specified format String
$str = $date->format('Y-m-d');

In JS/JQuery you can use the moment library to help:

//Create moment object from a specified format
var date = moment(dateVal, 'DD/MM/YYYY');

//From moment Object to a specified format String
var str = date.format('YYYY-MM-DD');

answered Oct 14, 2019 at 20:56

user11897373

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

Comments

Andrew Nic · Accepted Answer · 2019-10-14 20:42:43Z

0

you can't use jquery to save to the database directly unless you are using node.js

you have to send the date to php file and from the php to the database

answered Oct 14, 2019 at 20:42

Andrew Nic

1782 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to save jQuery date picker value to database and retrieve from database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related