drpfu51608120170
2012-04-03 15:40 阅读 33
已采纳

它只在数据库中正确显示选项

I have a php code where it uses a a switch statement to find any of the values from the textbox and output the correct 'optionId' which matches the $selected_option which matches the value from the textbox.

The problem I have though is that lets say there are 4 questions, 3 questions with different options and 1 which has the same optionId as another question. When I insert them in the database it is suppose to look like below:

   Question               OptionId

    What is my gender     O17   //case '19'
    What is my name        O3    //case '5'
    What is my address     O17   //case '19'
    What is my age         O7    //case '9'

But instead it is showing only the latest OptionId for both questions like below which is incorrect.

Question               OptionId

What is my gender      O7
What is my name        O7
What is my address     O7
What is my age         O7

So what I want to know is why is it displaying only the latest OptionId for all questions? Do I need to loop the switch statement or is there something wrong with the way I loop the $insertQuestion[] as that goes through each Question?

    $insertquestion = array();


        $options = $_POST['gridValues'];

        switch ($options){

            case "3": 
            $selected_option = "A-C";
            break;

            case "4": 
            $selected_option = "A-D";
            break;

            case "5": 
            $selected_option = "A-E";
            break;

            default:
            $selected_option = "";
            break;

        }      


  $optionquery = "SELECT OptionId FROM Option_Table WHERE (OptionType = '". mysql_real_escape_string($selected_option)."')";

$optionrs = mysql_query($optionquery);
    while($optionrecord = mysql_fetch_array($optionrs)){
        $optionid[] = $optionrecord['OptionId'];
    }



foreach($_POST['questionText'] as $question)
{
    $insertquestion[] = "'". mysql_real_escape_string( $_SESSION['id'] ) . ($_SESSION['initial_count'] > 1 ? $_SESSION['sessionCount'] : '') ."' ,'". mysql_real_escape_string( $_POST['num_questions'] ) ."','".  mysql_real_escape_string( $question ) ."','".  mysql_real_escape_string( $optionid[] ) ."'";
}

  $questionsql = "INSERT INTO Question (SessionId, QuestionId, QuestionContent, OptionId) 
  VALUES (" . implode('), (', $insertquestion) . ")";



echo($questionsql)

UPDATE:

Below is the form code. How it works is the user types in a question in the textarea ('name='questionText') and types in an option (name='gridValues') and then they append them two in a table row (table in the form which id='qandatbl'). This is the question 1. Then they do the same again for second question, then third and etc. Please look at this carefully, it is easy to follow :)

<script>

    function insertQuestion(form) {   

    var context = $('#optionAndAnswer');

    var $tbody = $('#qandatbl > tbody'); 
    var $tr = $("<tr class='optionAndAnswer' align='center'></tr>");
    var $question = $("<td class='question'></td>");
    var $options = $("<td class='option'></td>");
    var $questionType = '';

    $('#questionTextArea').each( function() {

    var $this = $(this);
    var $questionText = $("<textarea class='textAreaQuestion'></textarea>").attr('name',$this.attr('name')+"[]")
                   .attr('value',$this.val())

    $question.append($questionText);

    });

    $('.gridTxt', context).each( function() {

     var $this = $(this);
     var $optionsText = $("<input type='text' class='gridTxtRow maxRow' />").attr('name',$this.attr('name'))
                     .attr('value',$this.val())

    $options.append($optionsText);
    $questionType = $this.val();

    });

    $tr.append($question);
    $tr.append($options);    
    $tbody.append($tr); 

    }

</script>


<form id="QandA" action="insertQuestion.php" method="post" >

<table>
<tr>
    <td rowspan="3">Question:</td> 
    <td rowspan="3">
        <textarea id="questionTextArea" rows="5" cols="40" name="questionText"></textarea>
    </td>
</tr>
</table>

<table id="optionAndAnswer" class="optionAndAnswer">
<tr class="option">
<td>Option Type:</td>
<td>
<div>
    <input type="text" name="gridValues" class="gridTxt maxRow" readonly="readonly" />
</div>
</td>
</tr>
</table>

<table id="qandatbl" align="center">
<thead>
<tr>
    <th class="question">Question</th>
    <th class="option">Option Type</th>
</tr>
</thead>
<tbody>
</tbody>
</table>

</form>
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

3条回答 默认 最新

  • 已采纳
    douda5227 douda5227 2012-04-03 16:43

    as discussed - you have asked to show you how to apply loop:

    $optionquery = "SELECT OptionId FROM Option_Table WHERE (OptionType = '" 
             . mysql_real_escape_string($selected_option)."')";
    
        $optionrs = mysql_query($optionquery);
        while($optionrecord = mysql_fetch_array($optionrs)){
            $optionid[] = $optionrecord['OptionId'];
        }
    

    your $optionid is then becomes array of all matched elements.

    if you think i understood your problem correctly, then let me know so we can work on UPDATE query


    UPDATE

    $options[] = $_POST['gridValues'];
    $i=0;
    
    foreach($_POST['questionText'] as $question){
    
            switch ($options[$i]){
                case "3": 
                $selected_option = "A-C";
                break;
                case "4": 
                $selected_option = "A-D";
                break;
                case "5": 
                $selected_option = "A-E";
                break;
                default:
                $selected_option = "";
                break;
            }      
        $optionquery = "SELECT OptionId FROM Option_Table WHERE (OptionType = '". mysql_real_escape_string($selected_option)."')";
    
        $optionrs = mysql_query($optionquery);
        $optionrecord = mysql_fetch_array($optionrs);
        $optionid = $optionrecord['OptionId'];
    
        $insertquestion[] = "'". mysql_real_escape_string( $_SESSION['id'] ) . 
            ($_SESSION['initial_count'] > 1 ? $_SESSION['sessionCount'] : '') ."' ,'". 
            mysql_real_escape_string( $_POST['num_questions'] ) ."','".  
            mysql_real_escape_string( $question ) ."','". 
            mysql_real_escape_string( $optionid ) ."'";
    
        $i++;
    }
    
    $questionsql = "INSERT INTO Question (SessionId, QuestionId, QuestionContent, OptionId) 
        VALUES (" . implode('), (', $insertquestion) . ")";
    
        echo($questionsql);
    
    点赞 评论 复制链接分享
  • dongque5529 dongque5529 2012-04-03 15:46

    It looks as though it is inserting 07 each time as that is the last value in the array. You may need to loop through the $insertquestion array and run an insert each time.

    点赞 评论 复制链接分享
  • douhuanbai6729 douhuanbai6729 2012-04-03 15:57

    In your HTML, make sure you're using square brackets in your input names:

    <textarea name="questionText[]" class="first_textarea">
    <textarea name="questionText[]" class="second_textarea">
    <textarea name="questionText[]" class="third_textarea">
    
    点赞 评论 复制链接分享

相关推荐