Repository navigation
Expand file tree
/
Copy pathdisplayarticle.php
More file actions
116 lines (106 loc) · 4.14 KB
/
Copy pathdisplayarticle.php
File metadata and controls
116 lines (106 loc) · 4.14 KB
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
104
105
106
107
108
109
110
111
112
113
114
115
116
<?php
include("header.php");
$sqlarticle= "SELECT newscontent.*,newscategory.category FROM newscontent LEFT JOIN newscategory ON newscontent.newscategoryid=newscategory.newscategoryid WHERE newscontent.status='Active' ";
if($_GET['newstype'] != "")
{
$sqlarticle = $sqlarticle . " AND newscontent.newstype='$_GET[newstype]'";
}
if($_GET['newscategoryid'] != "")
{
$sqlarticle = $sqlarticle . " AND newscontent.newscategoryid='$_GET[newscategoryid]'";
}
$qsqlarticle = mysqli_query($con,$sqlarticle);
$rsarticle = mysqli_fetch_array($qsqlarticle);
?>
<!-- catg header banner section -->
<section id="aa-catg-head-banner">
<img src="img/fashion/fashion-header-bg-8.jpg" alt="fashion img">
<div class="aa-catg-head-banner-area">
<div class="container">
<div class="aa-catg-head-banner-content">
<h2><?php echo $_GET['newstype']; ?></h2>
<ol class="breadcrumb">
<li><a href="#"><?php echo $rsarticle['category']; ?></a></li>
</ol>
</div>
</div>
</div>
</section>
<!-- / catg header banner section -->
<!-- Blog Archive -->
<section id="aa-blog-archive">
<div class="container">
<div class="row">
<div class="col-md-12">
<div class="aa-blog-archive-area">
<div class="row">
<div class="col-md-9">
<div class="aa-blog-content">
<div class="row">
<?php
$sql= "SELECT newscontent.*,newscategory.category FROM newscontent LEFT JOIN newscategory ON newscontent.newscategoryid=newscategory.newscategoryid WHERE newscontent.status='Active' ";
if($_GET['newstype'] != "")
{
$sql = $sql . " AND newscontent.newstype='$_GET[newstype]'";
}
if($_GET['newscategoryid'] != "")
{
$sql = $sql . " AND newscontent.newscategoryid='$_GET[newscategoryid]'";
}
if($_GET['txtsearch'] != "")
{
$sql = $sql . " AND newscontent.title LIKE '%$_GET[txtsearch]%' OR newscontent.newsdescription LIKE '%$_GET[txtsearch]%'";
}
$sql = $sql . " ORDER BY newscontent.newsid DESC";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
if($rs['images'] != "")
{
if(file_exists("imgarticle/".$rs['images']))
{
$img = "imgarticle/".$rs['images'];
}
}
else
{
$img = "img/testimonial-bg-1.jpg";
}
?>
<div class="col-md-4 col-sm-4">
<article class="aa-blog-content-single">
<figure class="aa-blog-img">
<a href="newsdetailed.php?newsid=<?php echo $rs['newsid']; ?>&newstype=<?php echo $_GET['newstype']; ?>&newscategoryid=<?php echo $_GET['newscategoryid']; ?>"><img src="<?php echo $img; ?>" style="heighT: 200px;width: 100%;" ></a>
</figure>
<h4><a href="newsdetailed.php?newsid=<?php echo $rs['newsid']; ?>&newstype=<?php echo $_GET['newstype']; ?>&newscategoryid=<?php echo $_GET['newscategoryid']; ?>"><?php echo $rs['title']; ?></a></h4>
<p><?php echo substr($rs["newsdescription"], 0, 100); ?></p>
<div class="aa-article-bottom">
<div class="aa-post-author">
Category -<a href="#"><?php echo $rs['category']; ?></a>
</div>
<div class="aa-post-date">
<a href="newsdetailed.php?newsid=<?php echo $rs['newsid']; ?>&newstype=<?php echo $_GET['newstype']; ?>&newscategoryid=<?php echo $_GET['newscategoryid']; ?>">Read more>></a>
</div>
</div>
</article>
</div>
<?php
}
?>
</div>
</div>
<!-- Blog Pagination -->
</div>
<div class="col-md-3"><?php
include("sidebarads.php");
?></div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- / Blog Archive -->
<?php
include("footer.php");
?>