"Notice: array to string conversion" when tried to send a result from list to personal mysql database

  • paulajve
    Asked on June 21, 2020 at 4:30 PM

    Dear,


    I was working in the following form:

    https://www.jotform.com/build/201713971311043

    I've put a selection list, but when I select "other" and fulfil this field with any text and then submit the form, I've received the message:  

    "Notice: array to string conversion"

    The problem is this row:

    ----------------------

    <input type="text" class="form-radio-other-input form-textbox" name="q9_dev_area[other]" data-otherhint="Otro" size="15" id="input_9" placeholder="Otro" />

    ------------------------

    where the q9_dev_area[other] var is defined. 


    How can I solve this problem in the php code? I've tried this line in my php without success:

    $stmt->bindParam(':q9_dev_area', ($_POST['q9_dev_area']));


    -------------------------

    Note

    I've tried to change this line to:

    $stmt->bindParam(':q9_dev_area', json_encode($_POST['q9_dev_area']));

    but I've received: <<Notice: Only variables should be passed by reference>>


    I'll appreciate a lot your help with this issue.


    Best regards,


    Paula.

  • Mike_G JotForm Support
    Replied on June 21, 2020 at 7:43 PM

    It seems to be working on my end when I tested a cloned version of your form redirecting to this page https://www.jotform.com/show-post-data/

    Test submission:

    1592782866zt200621 193935 Screenshot 10

    Result:

    1592782876zt200621 193905 Screenshot 21

    In your codes, please remove the q9_ from all q9_dev_area to solve the issue.

    Also, please make sure that the Send Post Data option of your form builder page is enabled.

    Reference Guide: How-to-Post-Submission-Data-to-Thank-You-Page