wispas Posted January 4, 2010 Share Posted January 4, 2010 I want a calender script that will insert the selected calender date into MySQL. Is there a script someone has done or something i can use out there... Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/187105-php-calender-select-and-insert-into-mysql/ Share on other sites More sharing options...
kickstart Posted January 4, 2010 Share Posted January 4, 2010 Hi Think a bit more detail is required. Do you want just a single text field to enter the date manually? Do you want to try and recognise different date formats? Do you want a popup div for the user to select the date from? The actual MySQL bit is easy (just put it in the appropriate format in your INSERT / UPDATE statement). However the rest would probably be best aimed at a php or Javascript area of the forum. All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/187105-php-calender-select-and-insert-into-mysql/#findComment-988099 Share on other sites More sharing options...
wispas Posted January 4, 2010 Author Share Posted January 4, 2010 I have a Date field in my database and a text field that will insert the date in to the database. it will pick a date from a pop up window... and insert that selected date into the MySQL. just wondering if someone can guide me on achieving this... thanks! Quote Link to comment https://forums.phpfreaks.com/topic/187105-php-calender-select-and-insert-into-mysql/#findComment-988110 Share on other sites More sharing options...
kickstart Posted January 4, 2010 Share Posted January 4, 2010 Hi For a normal form then have your php script receive the values and do any validation (including of the date field). If you are happy with it then do the insert. Normal SQL insert would be something like:- INSERT INTO atable (somefield, anotherfield, datefield) VALUES ('somevalue','anothervalue','2010-01-02') The difficult bit for you is the popup and the Javascript. Probably best to post that in the Javascript forum. All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/187105-php-calender-select-and-insert-into-mysql/#findComment-988151 Share on other sites More sharing options...
jimcarry05 Posted January 5, 2010 Share Posted January 5, 2010 I am using jquery calendar. Here is a link. http://docs.jquery.com/UI/Datepicker EDIT: another link http://www.ataulkarim.com/?p=15 Quote Link to comment https://forums.phpfreaks.com/topic/187105-php-calender-select-and-insert-into-mysql/#findComment-988853 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.