-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathmodal_view.php
46 lines (44 loc) · 1.03 KB
/
modal_view.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php
include("db.php");
if (isset($_REQUEST['id']) ){
$id= $_REQUEST['id'];
?>
<?php
$sql = mysqli_query($con,"SELECT * FROM `survey_questionnaire` WHERE survey_ID = $id");
$sql1 = mysqli_query($con,"SELECT * FROM `survey` WHERE survey_ID = $id");
$i = 1;
$title = mysqli_fetch_array($sql1);
?>
<h1 class="text-center"><?php echo $title['survey_name']?></h1>
<form action="">
<?php
while ($data = mysqli_fetch_array($sql)){
$i;
$q_ID = $data[0];
$sql1 = mysqli_query($con,"SELECT GROUP_CONCAT(answer) AS `option`
FROM `survey_anweroptions` WHERE survey_qID = $q_ID");
$data1 = mysqli_fetch_array($sql1);
$question = $data['question'];
$option = $data1['option'];
$option = explode(",",$option);
?>
<div class="form-group">
<label for=""><?php echo $i.".) ".$question ?></label>
<select class="form-control">
<?php
foreach ($option as $key => $value) {
?>
<option><?php echo$value ?></option>
<?php
}
?>
</select>
</div>
<?php
$i++;
}
?>
</form>
<?php
}
?>