This repository has been archived by the owner on Oct 23, 2020. It is now read-only.
/
search.php
82 lines (67 loc) · 2.76 KB
/
search.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
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
<?php require("inc/settings.php"); $titlew="Vyhľadávanie"; require("inc/header.php");
if(isset($_POST["search"])){
redirect("?i=".htmlspecialchars(urlencode($_POST["search"])));
}
echo '
<div class="bigtitlecenter">
<div class="bigtitle">
<h5>Vyhľadávanie</h5>
Nevieš niečo nájsť? Tak neváhaj použiť naše vyhľadávanie, ktoré ti ušetrí čas.
<br><br>
<form action="" method="post">
<div class="input-group">
<input type="text" class="form-control" name="search" value="'.(isset($_GET["i"]) ? $_GET["i"]:"").'">
<span class="input-group-btn">
<button class="btn btn-success" type="submit">Vyhladať</button>
</span>
</div>
</form>
</div>
</div>
';
if(isset($_GET["i"]) && $_GET["i"] != ""){
$search = mysqli_real_escape_string($db_connect,htmlspecialchars($_GET["i"]));
if(strlen($search) >= 3){
$result333 = dbquery("SELECT * FROM bg_articles WHERE article_suggestion='0' AND (article_txt LIKE '%".$search."%' OR article_name LIKE '%".$search."%' OR article_target LIKE '%".$search."%')");
$rows2 = dbrows($result333);
if($rows2 >= "1"){
echo '<div class="list-group">
<a class="list-group-item active">Nájdené výsledky v článkoch</a>
';
while($data66 = dbarray($result333)){
echo '
<div class="list-group-item">
<span class="label label-warning">'.articlecat($data66["article_cat"]).'</span>
<a href="/clanok/'.$data66["article_id"].'/'.bezd($data66["article_name"]).'">'.$data66["article_name"].'</a>
<span class="badge">'.timeago($data66["article_date"]).'</span>
</div>
';
}
echo '</div>';
}else{
echo '<div class="alert alert-info">Žiadne výsledky v článkoch.</div>';
}
$result33 = dbquery("SELECT post_topicid,post_text,post_time FROM bg_forumtopicpost WHERE post_text LIKE '%".$search."%' GROUP BY post_topicid");
$rows2 = dbrows($result33);
if($rows2 >= "1"){
echo '<div class="list-group">
<a class="list-group-item active">Nájdené výsledky vo fóre</a>
';
while($data66 = dbarray($result33)){
echo '
<div class="list-group-item">
<span class="label label-warning">'.forumcat(forumcatid($data66["post_topicid"])).'</span>
<a href="/tema/'.$data66["post_topicid"].'/'.bezd(forumtopicname($data66["post_topicid"])).'">'.forumtopicname($data66["post_topicid"]).'</a>
<span class="badge">'.timeago($data66["post_time"]).'</span>
</div>
';
}
echo '</div>';
}else{
echo '<div class="alert alert-info">Žiadne výsledky v fóre.</div>';
}
}else{
echo '<div class="alert alert-info">Výsledok musí obsahovať viacej než 3 písmená</div>';
}
}
require("inc/footer.php"); ?>