Trouble with Storing Time in Table DB & Retrieving Output

  • Profile Image
    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,



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

  • Profile Image
    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

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



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