Menu

checkbox feature does not store data in mysql

Help
Rob
2007-12-15
2013-06-03
  • Rob

    Rob - 2007-12-15

    I was having problems with the data selected on my check box questions being entered into the database.  The data stored is 'array' not the actual choices. However, the email generates fine and displays all the appropraite answers.

    All other fields (non check box type).  Text, Drop Down, Calendar, they all seem to enter the data into the database fine.  Only the questions chich have check boxes, in which the only thing that shows in the database under that field is 'array'

    any idea?

     
    • TNTEverett

      TNTEverett - 2007-12-17

      It is likely that if you extracted the "array" from the database that it could still be properly displayed as individual items.  I have never experimented with this but I could if you really feel it is important. 
      If you want me to look into it tell me wich version of the generator are you using, tell me if you are using file or mysql, and tell me how you are displaying the db data in which you see the "array" result. 

       
      • Rob

        Rob - 2007-12-17

        I have researched my other questions and with your help and what I have found I was able to make the necessary adjustments to get both the date, and the email subject line working the way I would like. Unfortunately the more important problem I am having is this array issue.

        In order for this form to benefit me, I need some way of tracking multiple selected items, such as the checkbox feature.  As I mentioned before, it displays the properly checked boxes when it sends me the email notice, but when I check the database, the field show 'array'

        If possible I would like some help on getting this portion to work.  Please give me some ideas as to what I can do? And please, bear with me, I'm not all that programmer savy. Especially when it comes to mysql.

        Thank you

         
        • TNTEverett

          TNTEverett - 2007-12-18

          Tell me what it is you are using to see the "array" result. 

          http://us2.php.net/manual/en/function.array.php
          http://us2.php.net/manual/en/function.print-r.php

          There are many ways to deal with arrays but it will depend on what you expect to do with the array.  The links above should get you started.  They provide some good technical background on array functions and printing as well as provide some good examples of their usage. 

           

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.