insert survey

hi guys,

need some urgent help with this one.

how can i use data assist to insert a survey?

at the moment my plan is to store the users basic details i.e. name, tel and address in one table.

have a table with categories which could be "search engines, shops etc"

the thing is they need to be allowed to insert google, yahoo etc in searhc engines which is fine.

however on my survey page how can i have it where it lists all the search engines as checboxes to be selected.

i know setting it in a repate region will display them however how should i store the selected results of the survey in the database?

should it be done in a seperate table called "surveyresults" and how can i have data assist insert the selected search engines? as looking at the multiple insert tutorial this shows how to insert name over and over again however this is checkboxes of different search engines. the thing is that is only part of the survey there are more questions which will have answers that need to be stored. how is it best i tackle this keeping in mind i will be using dataassist to do my insert?

many thanks

I wouldn't store the selected search engines in a separate table, I would store the as a comma separated list in a column of the main table.


to do this, name the checkboxes the same with a "[]} at the end to create an array of the selections, for example:

<label>
      <input type="checkbox" name="searchEngines[]" value="Google" id="searchEngines_0" />
      Google</label>
    <br />
    <label>
      <input type="checkbox" name="searchEngines[]" value="Bing" id="searchEngines_1" />
      Bing</label>
    <br />
    <label>
      <input type="checkbox" name="searchEngines[]" value="Yahoo" id="searchEngines_2" />
      Yahoo</label>
    <br />

in the insert record, when you bind the searchengine column to the search engine checkbox group, the code will look like this:

<?php echo((isset($_POST["searchEngines[]"]))?$_POST["searchEngines[]"]:"") ?>

you will need to remove the "[]" from the end of the name:

<?php echo((isset($_POST["searchEngines"]))?$_POST["searchEngines"]:"") ?>

the add this code to convert the array to a string at line :

<?php

if($_SERVER["REQUEST_METHOD"] == "POST")     {

    foreach($_POST as $key => $val) {

        if(is_array($_POST[$key])) $_POST[$key] = implode(", ", $_POST[$key]);

    }

}

?>