Trouble with Storing Time in Table DB & Retrieving Output

  • Profile Image
    ellie123
    Asked 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).

  • Profile Image
    jonathan
    Answered 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
    ellie123
    Answered 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
    ellie123
    Answered 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
    Welvin
    Answered 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