Geek Answers Handbook

Its results are displayed incorrectly in php / html

I want to display all the questions from the dropdown menu when the user selects All from the question drop-down menu and displays it at the bottom. The problem is that it does not do this and makes it worse, it gives me undefined offset errors indicating:

 Notice: Undefined offset: ... in .... on line 605

Line 605:

 echo '<p><strong>Question:</strong> ' .htmlspecialchars($arrQuestionNo[$key]). ': ' .htmlspecialchars($arrQuestionContent[$key]). '</p>' . PHP_EOL;

My question is how to fix the error and display all the questions if the user selects the All option?

I have a demo that you can go through: DEMO

Follow these steps:

  • In the module pop-up menu, select System Stratergy and submit
  • When the Grade pop-up menu appears, select POKUB1 and submit
  • You will see a drop-down menu of students and questions. You can see that if you open the drop-down menus that have 3 students and 2 questions. Choose one student and All questions and ubmit. You will see errors here when I really want to display all the details of the question here.

CODE:

Question Drop-down menu:

 <select name="question" id="questionsDrop"> <option value="0">All</option> <option value=23">1</option> <option value=32">1</option> </select>

Below is the code that defines the display depending on which options are selected from the question drop-down menu.

  function StudentAnswers() { $selectedstudentanswerqry = " SELECT sa.StudentId, StudentAlias, StudentForename, StudentSurname, q.SessionId, QuestionNo, QuestionContent, o.OptionType, q.NoofAnswers, GROUP_CONCAT( DISTINCT Answer ORDER BY Answer SEPARATOR ',' ) AS Answer, r.ReplyType, QuestionMarks, GROUP_CONCAT(DISTINCT StudentAnswer ORDER BY StudentAnswer SEPARATOR ',') AS StudentAnswer, ResponseTime, MouseClick, StudentMark FROM Student st INNER JOIN Student_Answer sa ON (st.StudentId = sa.StudentId) INNER JOIN Student_Response sr ON (sa.StudentId = sr.StudentId) INNER JOIN Question q ON (sa.QuestionId = q.QuestionId) INNER JOIN Answer an ON q.QuestionId = an.QuestionId LEFT JOIN Reply r ON q.ReplyId = r.ReplyId LEFT JOIN Option_Table o ON q.OptionId = o.OptionId "; // Initially empty $where = array('q.SessionId = ?'); $parameters = array($_POST["session"]); $parameterTypes = 'i'; // Check whether a specific question was selected $p_question = empty($_POST["question"])?'':$_POST["question"]; switch($p_question){ case 0: //dont' add where filters break; default: $where[] = 'q.QuestionId = ?'; $parameters[] .= $_POST["question"]; $parameterTypes .= 'i'; } // If we added to $where in any of the conditionals, we need a WHERE clause in // our query if(!empty($where)) { $selectedstudentanswerqry .= ' WHERE ' . implode(' AND ', $where); global $mysqli; $selectedstudentanswerstmt=$mysqli->prepare($selectedstudentanswerqry); // You only need to call bind_param once if (count($where) == 1) { $selectedstudentanswerstmt->bind_param($parameterTypes, $parameters[0]); } else if (count($where) == 2) { $selectedstudentanswerstmt->bind_param($parameterTypes, $parameters[0], $parameters[1]); } } $selectedstudentanswerqry .= " GROUP BY sa.StudentId, q.QuestionId ORDER BY StudentAlias, q.SessionId, QuestionNo "; // get result and assign variables (prefix with db) $selectedstudentanswerstmt->execute(); $selectedstudentanswerstmt->bind_result($detailsStudentId,$detailsStudentAlias,$detailsStudentForename,$detailsStudentSurname,$detailsSessionId,$detailsQuestionNo, $detailsQuestionContent,$detailsOptionType,$detailsNoofAnswers,$detailsAnswer,$detailsReplyType,$detailsQuestionMarks,$detailsStudentAnswer,$detailsResponseTime, $detailsMouseClick,$detailsStudentMark); $selectedstudentanswerstmt->store_result(); $selectedstudentanswernum = $selectedstudentanswerstmt->num_rows(); $question = array(); while ($selectedstudentanswerstmt->fetch()) { $arrQuestionNo = array(); $arrQuestionContent = array(); $arrQuestionNo[ $detailsStudentId ] = $detailsQuestionNo; $arrQuestionContent[ $detailsStudentId ] = $detailsQuestionContent; $questions[] = $arrQuestionNo; $questions[] = $arrQuestionContent; } $selectedstudentanswerstmt->close(); ?> ........................................................................................... <h2>STUDENT ANSWERS</h2> <?php foreach ($questions as $key=>$question) { echo '<p><strong>Question:</strong> ' .htmlspecialchars($arrQuestionNo[$key]). ': ' .htmlspecialchars($arrQuestionContent[$key]). '</p>' . PHP_EOL; } } ?>

UPDATE:

Student table structure:

 CREATE TABLE `Student` ( `StudentId` int(10) NOT NULL AUTO_INCREMENT, `StudentForename` varchar(25) NOT NULL, `StudentSurname` varchar(25) NOT NULL, `StudentAlias` varchar(15) NOT NULL, `StudentEmail` varchar(50) NOT NULL, `StudentUsername` varchar(20) NOT NULL, `StudentPassword` varchar(50) NOT NULL, `StudentDOB` date NOT NULL, `Year` int(2) NOT NULL, `CourseId` int(6) NOT NULL, `Active` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`StudentId`), KEY `FK_Course` (`CourseId`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8

Question table structure:

 CREATE TABLE `Question` ( `QuestionId` int(10) NOT NULL AUTO_INCREMENT, `SessionId` int(10) NOT NULL, `QuestionNo` int(3) NOT NULL, `QuestionContent` varchar(5000) NOT NULL, `NoofAnswers` int(2) NOT NULL, `ReplyId` int(1) NOT NULL, `QuestionMarks` int(4) NOT NULL, `OptionId` int(2) NOT NULL, PRIMARY KEY (`QuestionId`) ) ENGINE=InnoDB AUTO_INCREMENT=357 DEFAULT CHARSET=utf8
+4
source share
2 answers

Try to try.

 $question = array(); while ($selectedstudentanswerstmt->fetch()) { // assuming you don't need the StudentId $questions[] = array('no' => $detailsQuestionNo, 'content' => $detailsQuestionContent); }

and

 foreach ($questions as $key => $question) { echo '<p><strong>Question:</strong> ' . htmlspecialchars($question['no']) . ': ' . htmlspecialchars($question['content']) . '</p>' . PHP_EOL; }

EDITED

Or you can try this if your grouping by question:

 $question = array(); while ($selectedstudentanswerstmt->fetch()) { if (true === isset($questions[$detailsQuestionId])) { $questions[$detailsQuestionId]['students'][] = $detailsStudentId; } else { $questions[$detailsQuestionId] = array(); $questions[$detailsQuestionId]['no'] = $arrQuestionNo; $questions[$detailsQuestionId]['content'] = $arrQuestionContent; $questions[$detailsQuestionId]['students'] = array(); $questions[$detailsQuestionId]['students'][] = $detailsStudentId; } } foreach ($questions as $questionId => $question) { // $question['no'] // $question['content'] foreach($question['students'] AS $key => $studentId) { // $studentId } }

Or if your grouping by user ID ...

 $students = array(); while ($selectedstudentanswerstmt->fetch()) { if (false === isset($students[$detailsStudentId])) { $students[$detailsStudentId] = array(); } $students[$detailsStudentId][$detailsQuestionId] = array('no' => $arrQuestionNo, 'content' => $arrQuestionContent; } foreach ($students AS $studentId => $questions) { // $studentId foreach ($questions AS $questionId => $question) { // $questionId // $question['no'] // $question['content'] } }
+2
source

Your foreach iterates over the questions array that has been populated:

  $questions[] = $arrQuestionNo; $questions[] = $arrQuestionContent;

This means that it is an indexed array, not an associative array; keys are 0 and 1.

But then you echo $arrQuestionNo[$key] and $arrQuestionContent[$key] . These are associative arrays whose keys are student IDs, not indexes starting at 0 (unless you have students with these ID numbers).

In addition, you initialize $arrQuestionNo and $arrQuestionContent an empty array each time through a fetch cycle. Therefore, when you echo the results at the end, they simply contain questions from the last line that was selected.

You should use a multidimensional array:

 while ($selectedstudentanswerstmt->fetch()) { $questions[$detailsStudentId][$detailsQuestionNo] = $arrQuestionContent; }

Then your print cycle should be:

 foreach ($questions as $studentId => $studentQuestions) { echo '<h2>Student '.htmlspecialchars($studentId).' Answers</h2>'. PHP_EOL; foreach ($studentQuestion as $questionNo => $content) { echo '<p><strong>Question:</strong> ' .htmlspecialchars($questionNo). ': ' .htmlspecialchars($content). '</p>' . PHP_EOL; } }
0
source

More articles:


All Articles