What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Trouble with Storing Time in Table DB & Retrieving OutputAsked by ellie123 on July 04, 2014 at 06:53 PM
So, my form is storing my results o my db table. But, when trying to output I am getting "ARRAY" in the field for the the Time.
How do I set this column up in my table so I can work with the output?
I know I don't have my structure setup properly but I'm not sure what to put for the settings (i.e. type, Collation, Attributes, etc.)
I really liked the TimePicker Widget, but again...not sure how to set that up.
Can you give me any help?
(Sorry to post links like that - but having trouble with posting/uploader).
table POST settings attributes
Can you try first knowing the actual variable names and PHP code in the POST submission of the form. Follow the guide here
Check if the result for the Time Field if its "array"
Yes, I'm sorry. I thought I made that clear - the field is the one with the red box around it in my screenshot above.
the field value is showing as "ARRAY" in my table. I am guessing its a few reasons why, one of them being I don't have the structure setup correctly. As you can see I have it as a varchar field. Shouldn't this be something else?
and since it's value in my table is showing as ARRAY Do I need add'l columns or anything?
The name of the field is "plsenter23"
I think this is what I'm looking for:
$datetime = $_POST['DateTime']['2'] ."-". $_POST['DateTime']['0'] ."-". $_POST['DateTime']['1'] ." ". $_POST['DateTime']['3'] .":". $_POST['DateTime']['4'];
Okay. Please update us here for the results. We'll make sure to help you accomplish that to your form.