Forums

Posting Custom Date to Created Date MySQL Field

M
mchmaster posted Mar 15, 2009 at 06:40
Hi. I've looked around the forums for an answer to my problem but can't seem to find what I'm looking for, or maybe I just can't understand some of what's going on. Anyway, I'm using chronoforms 3.0 and I downloaded the submitcontent form, which is really helpful btw. It works great, but I want my users to be able to submit a date that is used instead of the created date. I'm using the calendar popup in my form and the onSubmit has this:

$_POST['created'] = date("Y-m-d H:i:s");

So my question is how do I get my date input (date_3) to be entered into the created date DB field instead of the current date. I've tried different things, but everything i've done has just given me a bunch of zeroes for dates. I appreciate any help. I know from looking at other postings that dealing with dates can get a little hairy.
Max_admin posted Mar 16, 2009 at 18:05
Hi mchmaster,

whats the format of the date created using the calendar plugin ? try this code in the onsubmit:

$_POST['created'] = date("Y-m-d H:i:s", strtotime($_POST['date_3']));

let me know!

Regards,
Max
Max
ChronoForms developer...
M
mchmaster posted Mar 18, 2009 at 20:58
Thank you so much! That was exactly what I needed!
Max_admin posted Mar 19, 2009 at 18:17
Great, please replace : $_POST['created'] by JRequest::getVar('created') and the same for the date field!

that's better for cleaning the posted data!

Cheers
Max
Max
ChronoForms developer...
L
lemur posted Apr 22, 2009 at 08:27
Great, please replace : $_POST['created'] by JRequest::getVar('created') and the same for the date field!
that's better for cleaning the posted data!
Cheers
Max

Hi, Max.

With $_POST it works.
But with JRequest::getVar('cb_myfield') I get:

Fatal error: Can't use function return value in write context in /var/www/vhosts/example.de/httpdocs/components/com_chronocontact/libraries/customcode.php(52) : eval()'d code on line 2

Is it really important to change to JRequest::getVar?

Thanks.

Leon
Max_admin posted Apr 22, 2009 at 17:08
Hi Leon,

my typo, here you need to use:

JRequest::setVar('created', date("Y-m-d H:i:s", strtotime(JRequest::getVar('date_3'))));

Cheers
Max
Max
ChronoForms developer...
L
lemur posted Apr 23, 2009 at 09:46
... you need to use:

JRequest::setVar('created', date("Y-m-d H:i:s", strtotime(JRequest::getVar('date_3'))));

Cheers
Max

Yes. it works.

Thanks!
This topic is locked and no more replies can be posted.

 2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for
goods and services provided by ChronoEngine.com