Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • update multiple values using php and mysql?

    @nasyia
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 2
    • 0
    • 0
    • 0
    • 599
    Answer it


    i need to update multiple choices for question but every time i run the query it's only update the last choice only also i need to update the value of the correct answer which is (0 or 1 ) which the best using input text or radio button

    1. <?php require ("scripts/connect_db.php");   ?>
    2. <?php session_start() ?>
    3. <?php
    4.  
    5.  
    6.  
    7.  
    8. if (isset($_POST['submit'])) {
    9.  
    10.     $question_id = mysqli_real_escape_string ($con,strip_tags($_POST['question_id']));
    11.  
    12.     $question = mysqli_real_escape_string ($con,strip_tags($_POST['desc']));
    13.  
    14.     $sql1 = mysqli_query($con,"UPDATE `questions` SET `question`='".$question."'
    15.             WHERE   questions.question_id = 1") or die(mysqli_error($con)); 
    16.  
    17.  
    18.  
    19.     $isCorrect  =  $_POST['iscorrect'];
    20.     $answers = mysqli_real_escape_string ($con,strip_tags(count($_POST['answers'])));
    21.     $answer_id =  mysqli_real_escape_string ($con,strip_tags($_POST['question_id']));
    22.  
    23.     for($i=0;$i<$answers;$i++) {
    24.     mysqli_query($con,"UPDATE answers set  answer='" . $_POST["answers"][$i] . "', correct='" . $_POST["iscorrect"][$i] . "' 
    25.     WHERE question_id = answers.question_id  AND  question_id = '".$question_id."'  ");
    26.     }
    27. echo "<pre>";
    28. print_r($_POST);
    29. echo "</pre>";  
    30. }else{
    31.  
    32.     $question_id = $_SESSION['question_id'];
    33.  
    34.      echo "   $question_id "; 
    35.  
    36.  
    37.  
    38.     $ques = mysqli_query ($con,"SELECT * FROM `questions` where questions.question_id= ".$question_id ." ") or die (mysqli_error($con));
    39.  
    40.     while ($row1 =  mysqli_fetch_assoc($ques)){
    41.         $question_id = $row1 ['question_id'];
    42.         $question = $row1 ['question'];
    43.  
    44.  
    45.  
    46.  
    47. }
    48.  
    49. ?>
    50. <!doctype html>
    51. <html lang="en">
    52. <head>
    53. <meta charset="utf-8">
    54. <title>  </title>
    55.  
    56. <style type="text/css">
    57.     body{
    58.         direction:RTL;
    59.     }
    60.     .content {
    61.  
    62.         margin-top: 50px;
    63.         margin-left: auto;
    64.         margin-right: auto;
    65.         width: 780px;
    66.         border: #333 1px solid;
    67.         border-radius: 12px;
    68.         -moz-border-radius: 12px;
    69.         padding: 12px;
    70.  
    71.     }
    72.     textarea{
    73.         width:400px;
    74.         height:95px;
    75.     }
    76. </style>
    77. </head>
    78.  
    79. <body>
    80.  
    81.  
    82.  <div class="content" id="mc">
    83.     <h3>  </h3>
    84.     <form action="#" name="addMcQuestion" method="post">
    85.       <strong>   </strong>
    86.         <br />
    87.         <textarea id="mcdesc" name="desc" ><?php echo $question;  ?></textarea>
    88.         <br />
    89.       <br />
    90.       <?php
    91.        $count = count(isset($_POST['answers']));
    92.         for($answers = 0 ; $answers<$count ; $answers++){
    93.                $query = mysqli_query($con,"SELECT * FROM answers WHERE answers.question_id = '".$question_id [$answers] ."' ") or die (mysqli_error($con));
    94.         while($rows[$answers] = mysqli_fetch_assoc($query)){
    95.       ?>
    96.       <p>
    97.     <strong> </strong>
    98.  
    99.         <input type="text"  name="answers[]" value="<?php echo $rows[$answers]['answer'];  ?>" />
    100.           <label>
    101.           <input type="text" name="iscorrect[]" value="<?php echo $rows[$answers]['correct'];  ?>" />  
    102.         </label>
    103.      </p>  
    104.  
    105.    <input type="hidden" name = "answer_id[]" value="<?php echo  $rows[$answers]['id'];  ?>" />
    106.  
    107.    <?php
    108.         }
    109.         ?>
    110.  
    111.  
    112.         <?php
    113.         } 
    114.         }
    115.  
    116.  
    117.    ?>
    118.     <input type="hidden" name = "question_id" value="<?php echo $question_id; ?>" />
    119.  
    120.  
    121.     <input type="submit" name="submit" value=" ">
    122.     </form>
    123.  </div>
    124. </body>
    125. </html>

    this my database structure

    1. CREATE TABLE `answers` (
    2.   `id` int(11) NOT NULL,
    3.   `question_id` int(11) NOT NULL,
    4.   `answer` varchar(255) NOT NULL,
    5.   `correct` enum('0','1') NOT NULL
    6. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    7.  
    8. --
    9. -- Dumping data for table `answers`
    10. --
    11.  
    12. INSERT INTO `answers` (`id`, `question_id`, `answer`, `correct`) VALUES
    13. (1, 1, 'java', '1'),
    14. (2, 1, 'C++', '1'),
    15. (3, 1, 'C#', '1'),
    16. (4, 1, 'php', '1');
    17.  
    18. -- --------------------------------------------------------
    19.  
    20. --
    21. -- Table structure for table `questions`
    22. --
    23.  
    24. CREATE TABLE `questions` (
    25.   `id` int(11) NOT NULL,
    26.   `question_id` int(11) NOT NULL,
    27.   `question` varchar(255) NOT NULL
    28. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    29.  
    30. --
    31. -- Dumping data for table `questions`
    32. --
    33.  
    34. INSERT INTO `questions` (`id`, `question_id`, `question`) VALUES
    35. (1, 1, 'programming languange ?');
    36.  
    37. --

     

    php mysqli
    Answer it

 2 Answer(s)

  • @yfastud
    Recommendations Offline Message

    about 8 years ago

    First, to get answer for multi-choice question, you need to have either check box, radio button, single select or multi select, but I didn't see you have any of these format in your codes.
    Second, no matter which format you would use, you need to code (a loop), either in your main or function, to get the value(s) associated with the answer(s) from user.
    Last but not least, recommend to use PDO instead mysqli.
    Will post example if request.
    Good luck ;)
     
  • @tonk379
    Recommendations Offline Message

    over 8 years ago

    I just go through your code and i can see a form for questions and answers. you are using for loop to display the answers but i am unable to understand the code flow. What is working of this line? $count = count($_POST['answer']);

    Whenever page load first time then there should not be a post request. If there is no post request then you can not display the answers. Kindly clear the code flow.

    Thank You

    Deepak Verma

    Sr. Software Engineer

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: