NFOHump.com :: View topic - Best way for date/time range picker and database interaction

Page 1 of 1

Stige

Posts: 3544
Location: Finland

Posted: Wed, 15th Apr 2015 14:28 Post subject: Best way for date/time range picker and database interaction	Quick Quote Quote

Would like some input on how this would be best handled: I need to pick a date and a start time along with date and end time for a project and then write this to SQL in a format that works for both SQL/PHP/whatever is used to make this and so it is sortable in the database. I have read some jQuery stuff but I have never done jQuery before so looking for tips/tricks/ideas on how I should handle all the database interaction and possible jQuery stuff. Ideas are welcome.

Profile
PM

garus
VIP Member

Posts: 34200

Posted: Wed, 15th Apr 2015 14:43 Post subject:	Quick Quote Quote

snip Last edited by garus on Tue, 27th Aug 2024 21:40; edited 1 time in total

Profile
PM

dingo_d
VIP Member

Posts: 14555

Posted: Wed, 15th Apr 2015 14:55 Post subject:

+1 to that. You can easily store the picked date in your DOM and then pull it out in php and convert with strtotime and do with it what ever you like Smile

"Quantum mechanics is actually, contrary to it's reputation, unbeliveably simple, once you take the physics out."
Scott Aaronson

chiv wrote:

thats true you know. newton didnt discover gravity. the apple told him about it, and then he killed it. the core was never found.

Profile
PM

Stige

Posts: 3544
Location: Finland

Posted: Wed, 15th Apr 2015 15:41 Post subject:	Quick Quote Quote

Something like this? http://jquery.hohli.com/ Or better ways to handle it? This is some new stuff I have never even touched.

Profile
PM

dingo_d
VIP Member

Posts: 14555

Posted: Thu, 16th Apr 2015 06:31 Post subject:

You are using some kind of CMS for your site, or just a simple HTML/PHP one?

"Quantum mechanics is actually, contrary to it's reputation, unbeliveably simple, once you take the physics out."
Scott Aaronson

chiv wrote:

thats true you know. newton didnt discover gravity. the apple told him about it, and then he killed it. the core was never found.

Profile
PM

Stige

Posts: 3544
Location: Finland

Posted: Thu, 16th Apr 2015 08:39 Post subject:

dingo_d wrote:

You are using some kind of CMS for your site, or just a simple HTML/PHP one?

Just a simple HTML/PHP made by hand, so anything goes really.

I heard of this Bootstrap thingy only after the project was a long way underway already :l

Profile
PM

Stige

Posts: 3544
Location: Finland

Posted: Fri, 17th Apr 2015 13:53 Post subject:

garus wrote:

For example: http://amsul.ca/pickadate.js/date/

just include jQuery.js, pickadate.js and copy paste the example from the page above Smile

Thanks, this worked wonders after I took some time to look at the files included.

Profile
PM

Page 1 of 1

All times are GMT + 1 Hour