internship-project/faq.php at master · vikasdo/internship-project · GitHub

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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
<?php
$con=mysqli_connect('freedb.tech','freedbtech_Electronix','E@8jKnCmka8HekR','freedbtech_uploadf');

include 'header.php';
?>


<title>FAQ</title>
<body style="background-color:#f8f8f9">
	<div class="container-fluid faq_image">
		<h1 class="text-center text_faq"><strong>Learn from the community!</strong></h1>
		<br>
		<br>
		<form class="form-vertical col-lg-6" action="faq.php" method="get">
			<input type="text" class="form-control keyword col-lg-offset-6" name="keyword" style="height:50px; font-size:25px" autocomplete="off"placeholder="Search by keyword" required align="center">
		</form>
		<br>
		<br>
		<br>
		<br>
		<h4 style="color:#000000; opacity:0.8" class="text-center">You can also browse the topics below to find what you are looking for.</h4>
		<br>
		<br>
	</div>
	<br>
	<div class="container" style="background-color:white">
		<?php
		if(!isset($_GET['keyword']))
		{

			echo '<h2 style="font-family:Calibri Light; font-size:35px; opacity:0.7">Frequently Asked Questions</h2>';
		}
		else
		{
			$text=$_GET['keyword'];
			echo '<h2 style="font-family:Calibri Light; font-size:35px; opacity:0.7"><strong>'.'Showing Results For "'.$text.'"'.'</strong></h2>'.'<br>';
		}
		?>

		<?php
		if(!isset($_GET['keyword']))
		{
			$sql="SELECT distinct qcat FROM questions";
			$res=mysqli_query($con,$sql);
			$i=0;
			while($row=mysqli_fetch_array($res))
			{
				if($i%3==1)
				{
					echo '<div class="row container-fluid">';
				}
				?>
					<div class="col-lg-4">
						<ul class="list">
							<h3 class="faq"><?php echo $row['qcat'];?></h3>
								<?php
								$qcat=$row['qcat'];
								$data="SELECT * FROM questions WHERE qcat='$qcat' ORDER BY question LIMIT 3";
								$res1=mysqli_query($con,$data);
								while($rowq=mysqli_fetch_array($res1))
								{
									?>
									<li><a class="faq_list" style="text-decoration:none" href="db.php?question=<?php echo $rowq['qid'];?>"><?php echo $rowq['question'];
									?></a></li>
									<?php
								}
								?>
						</ul>
					</div>
				<?php
				$i++;
				if($i%3==0)
				{
					echo '</div>';
				}
			}
		}
		?>

		<?php
		if(isset($_GET['keyword']))
		{
			$text=$_GET['keyword'];
			$results="SELECT * FROM questions WHERE question LIKE '%$text%' ORDER BY question";
			$res=mysqli_query($con,$results);
			while($row=mysqli_fetch_array($res))
			{
				$qid=$row['qid'];
				echo '<ul class="list">';
				echo '<li><a class="results_list" style="text-decoration:none" href="db.php?question='.$qid.'">'.$row['question'].'</a>'.'</li>'.'</ul>';
			}
		}
		?>
	</div>
	<br><br><br>

<?php

include 'footer.php';

?>
</body>
</html>