Отображение данных из базы данных не работает должным образом в PHP / javascript

У меня есть форма опроса, отображающая вопросы, ответы и количество вариантов из моей таблицы вопросов. Вот мой код.

<?php session_start(); ob_start(); $con = mysqli_connect("localhost","root","","imetrics"); $id = $_REQUEST['survey_id']; $query = "SELECT SF.survey_id, SF.surveytitle, SF.survey_description, SF.surveycategory, C.categoryname AS pcatname, SF.surveysubcategory, SC.categoryname AS scatname, SF.gender, SF.age_start, SF.age_end, SF.occupation, SF.date_created, O.name, SF.location, SF.occupation_status, SF.status, SFQ.question_id, Q.questiontitle,L.location_name FROM surveyform AS SF LEFT JOIN location AS L ON SF.location = L.location_id LEFT JOIN category AS C ON SF.surveycategory = C.category_id LEFT JOIN category AS SC ON SF.surveysubcategory = SC.category_id INNER JOIN occupation AS O ON SF.occupation = O.occupation_id INNER JOIN surveyform_questions AS SFQ ON SF.survey_id = SFQ.survey_id INNER JOIN question AS Q ON SFQ.question_id = Q.question_id WHERE SFQ.survey_id = $id"; $result = mysqli_query($con,$query); if($result){ while($row = mysqli_fetch_array($result)){ $surveyid = $row['survey_id']; $title = $row['surveytitle'] ; $category = $row['pcatname'] ; $subcategory = $row['scatname'] ; $gender = $row['gender']; $agestart = $row['age_start']; $ageend = $row['age_end']; $occupation = $row['name']; $location = $row['location_name']; $occupationstatus = $row['occupation_status']; $datecreated = $row['date_created']; $description = $row['survey_description']; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags --> <title>Preview Survey</title> <!-- Bootstrap --> <link href="css/bootstrap.min.css" rel="stylesheet"> <link href=" //maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> <link href="https://cdn.datatables.net/1.10.13/css/dataTables.bootstrap.min.css" rel="stylesheet"> <style> h2.space {padding: 0%} h4.space {padding: 0%} </style> <?php error_reporting(0); ?> </head> <body style="background-color:#f0f0f0;"> <br> <div class="container"> <div class="panel panel-default"> <div class="panel-body"> <div class=col-md-6> <a href="previewsurveys.php"><button class="btn btn-default"><span class="glyphicon glyphicon-arrow-left"></span></button></a> <a href="AdminDashboard.php"><button class="btn btn-default"><span class="glyphicon glyphicon-home"></span></button></a></div> <div style="float:right;"><h4><font color="grey"> Survey Code: <?php echo $surveyid ?></font></h4></div> <br> <hr/> <div class="col-md-6"> <h2 class="space"><?php echo $title ?></h2><br> <h4>Description: <?php echo $description ?></h4> <font color="grey"> Created: <?php echo $datecreated ?></font> </div> <div style="float:right;"> <div class="col-md-10"> <table> <tr> <td>Gender: </td> <td><input type=text class=form-control value=" <?php echo $gender ?>" disabled><td> </tr> <tr> <td>Age Range: </td> <td><input type=text class=form-control value=" <?php echo $agestart . " to " . $ageend . " y/o"; ?>" disabled></td> </tr> <tr> <td>Occupation: </td> <td><input type=text class=form-control value=" <?php echo $occupation ?>" disabled></td> </tr> <tr> <td>Location: </td> <td><input type=text class=form-control value=" <?php echo $location ?>" disabled></td> </tr> </table> </div> </div> </div> <hr> <div style="padding: 40px;"> <form name="Answers" method="POST"> <?php $con = mysqli_connect("localhost","root","","imetrics"); $id = $_REQUEST['survey_id']; $count=1; $answer=0; $query = "SELECT SF.survey_id, SF.surveytitle, SF.surveycategory, C.categoryname, Q.answer_type, Q.Option_1, Q.Option_2, Q.Option_3, Q.Option_4, Q.Option_5, Q.Option_6, Q.Option_7, Q.Option_8, Q.Option_9, Q.Option_10 AS pcatname, SF.surveysubcategory, SC.categoryname AS scatname, SF.gender, SF.age_start, SF.age_end, SF.location, SF.occupation, O.name, SF.occupation_status, SF.status, SFQ.question_id, Q.questiontitle FROM surveyform AS SF LEFT JOIN location AS L ON SF.location = L.location_id LEFT JOIN category AS C ON SF.surveycategory = C.category_id LEFT JOIN category AS SC ON SF.surveysubcategory = SC.category_id INNER JOIN occupation AS O ON SF.occupation = O.occupation_id INNER JOIN surveyform_questions AS SFQ ON SF.survey_id = SFQ.survey_id INNER JOIN question AS Q ON SFQ.question_id = Q.question_id WHERE SFQ.survey_id = $id"; $result = mysqli_query($con,$query); if($result){ while($row = mysqli_fetch_array($result)){ $questions = $row['questiontitle']; $qid = $row['question_id']; $anstype = $row['answer_type']; echo "<b>Question ". $count.".)</b> ". $questions. "</br>"; $count++; $answer++; ?> <?php $option1 = $row['Option_1']; $option2 = $row['Option_2']; $option3 = $row['Option_3']; $option4 = $row['Option_4']; $option5 = $row['Option_5']; $option6 = $row['Option_6']; $option7 = $row['Option_7']; $option8 = $row['Option_8']; $option9 = $row['Option_9']; $option10 = $row['Option_10']; ?> <input type="text" class="form-control" value="<?php echo $qid ?>" name="question_<?php echo $answer; ?>"> <?php if(!is_null($option1)){ ?> <div id="option1" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option1;?>" id="<?php echo $option1 ?>"><?php echo $option1; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option1;?>" id="<?php echo $option1 ?>"><?php echo $option1; } ?> </div> <br /> <?php } ?> <?php if(!is_null($option2)){ ?> <div id="option2" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option2;?>" id="<?php echo $option2 ?>"><?php echo $option2; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option2;?>" id="<?php echo $option2 ?>"><?php echo $option2; } ?> </div> <br /> <?php } ?> <?php if(!is_null($option3)){ ?> <div id="option3" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option3;?>" id="<?php echo $option3 ?>"><?php echo $option3; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option3;?>" id="<?php echo $option3 ?>"><?php echo $option3; } ?> </div> <br /> <?php } ?> <?php if(!is_null($option4)){ ?> <div id="option4" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option4;?>" id="<?php echo $option4 ?>"><?php echo $option4; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option4;?>" id="<?php echo $option4 ?>"><?php echo $option4; } ?> </div> <br /> <?php } ?> <?php if(!is_null($option5)){ ?> <div id="option5" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option5;?>" id="<?php echo $option5 ?>"><?php echo $option1; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option5;?>" id="<?php echo $option5 ?>"><?php echo $option5; } ?> </div> <br /> <?php } ?> <?php if(!is_null($option6)){ ?> <div id="option6" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option6;?>" id="<?php echo $option6 ?>"><?php echo $option6; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option6;?>" id="<?php echo $option6 ?>"><?php echo $option6; } ?> </div> <br /> <?php } ?> <?php if(!is_null($option7)){ ?> <div id="option7" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option7;?>" id="<?php echo $option7 ?>"><?php echo $option7; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option7;?>" id="<?php echo $option7 ?>"><?php echo $option7; } ?> </div> <br /> <?php } ?> <?php if(!is_null($option8)){ ?> <div id="option8" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option8;?>" id="<?php echo $option8 ?>"><?php echo $option8; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option8;?>" id="<?php echo $option8 ?>"><?php echo $option8; } ?> </div> <br /> <?php } ?> <?php if(!is_null($option9)){ ?> <div id="option9" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option9;?>" id="<?php echo $option9 ?>"><?php echo $option9; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option9;?>" id="<?php echo $option9 ?>"><?php echo $option9; } ?> </div> <br /> <?php } ?> <?php if(!is_null($option10)){ ?> <div id="option10" style="display:none;"> <?php if ($anstype == 'radiobutton'){ ?> <input type="radio" name="answer_<?php echo $answer ?>" value="<?php echo $option10;?>" id="<?php echo $option10 ?>"><?php echo $option10; } ?> <?php if ($anstype == 'checkbox'){ ?> <input type="checkbox" name="answer_<?php echo $answer ?>" value="<?php echo $option10;?>" id="<?php echo $option10 ?>"><?php echo $option10; } ?> </div> </div> <br /> <?php } }?> <hr> <input type="submit" name="submitsurvey" value="Submit" class="btn btn-default"> <INPUT TYPE = "hidden" Name = "id" VALUE = <?PHP echo $id; ?>> </form> </div> </div> </body> </html> <?php if (isset($_POST['submitsurvey'])) { for($i=1; $i<=$count; $i++){ $selected_radio = $_POST["answer_".$i]; $idNumber = $_POST['id']; $questionid = $_POST["question_".$i]; $username = $_SESSION['username']; $database = "imetrics"; $con = new mysqli("localhost","root","", $database ); if($questionid <> "") { $qq = "INSERT INTO surveyperusername VALUES ('".$username."','".$idNumber."','".$questionid."','".$selected_radio."')"; $rr = mysqli_query($con,$qq); } if ($con) { if($selected_radio == $option1) { $query = "UPDATE results SET Answer_1 = Answer_1 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else if($selected_radio == $option2){ $query = "UPDATE results SET Answer_2 = Answer_2 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else if($selected_radio == $option3){ $query = "UPDATE results SET Answer_3 = Answer_3 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else if($selected_radio == $option4){ $query = "UPDATE results SET Answer_4 = Answer_4 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else if($selected_radio == $option5){ $query = "UPDATE results SET Answer_5 = Answer_5 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else if($selected_radio == $option6){ $query = "UPDATE results SET Answer_6 = Answer_6 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else if($selected_radio == $option7){ $query = "UPDATE results SET Answer_7 = Answer_7 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else if($selected_radio == $option8){ $query = "UPDATE results SET Answer_8 = Answer_8 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else if($selected_radio == $option9){ $query = "UPDATE results SET Answer_9 = Answer_9 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else if($selected_radio == $option10){ $query = "UPDATE results SET Answer_10 = Answer_10 + 1 WHERE survey_id = $idNumber AND question_id = $questionid"; $result = mysqli_query($con,$query); } else { echo '<script language="javascript">'; echo 'alert("Survey Submitted!")'; echo '</script>'; } } } } } ?>

Это таблица, в которой я получаю данные для отображения

введите описание изображения здесь

На этом снимке отображается только 3 варианта для каждого вопроса, хотя некоторые вопросы имеют более 3 вариантов. Как я могу отобразить все параметры, которые имеют значение в зависимости от каждого вопроса, а не только 3? Как и в некоторых вопросах, у вас есть более 3 вариантов, которые имеют ценность, но они отображают только 3 введите описание изображения здесь

введите описание изображения здесь

Когда я удаляю style = "display: none" введите описание изображения здесь

когда я удаляю код jquery введите описание изображения здесь

как выглядит верх моей страницы введите описание изображения здесь

Отображение данных из базы данных не работает должным образом в PHP / javascript

Solutions Collecting From Web of "Отображение данных из базы данных не работает должным образом в PHP / javascript"