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.


  • Profile Image

    Trouble with Storing Time in Table DB & Retrieving Output

    Asked by ellie123 on July 04, 2014 at 06:53 PM

    Hello -

    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?

    Thank you,
    Ellie

    SCREENSHOT: http://siteformybiz.com/1.jpeg

    SCREENSHOT: http://siteformybiz.com/2.jpeg

    (Sorry to post links like that - but having trouble with posting/uploader).

    Screenshot
    table POST settings attributes
  • Profile Image
    JotForm Support

    Answered by jonathan on July 04, 2014 at 07:33 PM

    Hi Ellie,

    Can you try first knowing the actual variable names and PHP code in the POST submission of the form. Follow the guide here

    http://www.jotform.com/answers/answer_display.php?if_id=363070

    Check if the result for the Time Field if its "array"

    Thanks.

     

  • Profile Image

    Answered by ellie123 on July 05, 2014 at 08:58 AM

    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"

    thank you

  • Profile Image

    Answered by ellie123 on July 05, 2014 at 09:10 AM

    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'];

     .....STANDBY :)

  • Profile Image
    JotForm Support

    Answered by Welvin on July 05, 2014 at 02:21 PM

    Okay. Please update us here for the results. We'll make sure to help you accomplish that to your form.

    Thanks