Menu

Data of checkboxes missing, exporting to db

Help
Jens-Erik
2009-03-19
2013-06-03
  • Jens-Erik

    Jens-Erik - 2009-03-19

    Hello,

    when I choose to process the data to a data base, the data are not processed completely:

    I have 3 fields in a test form (formid=88643) with 2 checkboxes as field 3. Instead of getting the information which check boxes have been clicked, I only get "Array", not the contents. Here's the MySQL table exported to CSV:

    "id","field_1","field_2","field_3"
    "1","Jens-Erik","blabla@gmail.com","Array"

    Besides the names field_2 and field_3 of form.html are swapped in processor.php

    When I change

      "…
      $query = "INSERT into `".$db_table."` (field_1,field_2,field_3) VALUES ('" . $_POST['field_1'] . "','" . $_POST['field_2'] . "','" . $_POST['field_3'] . "')";
       …
      mail("blabla@gmail.com","phpFormGenerator - Form submission","Form data:

      Name: " . $_POST['field_1'] . "
    I am going to participate in: $field_2_opts
    E-mail: " . $_POST['field_3'] . "
      …
      ");
      …"

    to

      "…
      $query = "INSERT into `".$db_table."` (field_1,field_2,field_3) VALUES ('" . $_POST['field_1'] . "','" . $_POST['field_2'] . "','" . $field_3_opts  . "')";
      …
      mail("blabla@gmail.com","phpFormGenerator - Form submission","Form data:

      Name: " . $_POST['field_1'] . "
      I am going to participate in: $field_3_opts
      E-mail: " . $_POST['field_2'] . "
      …
      ");
    …"

    it works (mail address changed).

     
    • Musawir Ali

      Musawir Ali - 2009-03-19

      hmm looks like a bug in order tracking. Also, there seems to be inconsistency in what goes into the db vs what is emailed.

      File a bug report, this should be fixed.

       

Log in to post a comment.