forked from yongri/heliosinformatika
-
Notifications
You must be signed in to change notification settings - Fork 0
/
media_coverage.php
128 lines (126 loc) · 3.88 KB
/
media_coverage.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
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
117
118
119
120
121
122
123
124
125
126
127
128
<?php
session_start();
include "connection.php";
include "cons.php";
include"header.php";
?>
<div class="container overviewnews">
<div class="container overviewmidle">
<div class="col-lg-12">
<div class="col-lg-8 pull-left">
<ol class="breadcrumb">
<li><a href="#" class="jejak">Home</a></li>
<li class="active">Media Coverage</li>
</ol>
</div>
<div class="col-lg-4">
<!-- Title Product --> <h3 class="coverage">Media Coverage</h3>
</div>
</div>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-4">
<div class="box leftmenu">
<div id='cssmenu'>
<ul>
<?php $sql1=("SELECT * FROM news WHERE Category_id='2' ORDER BY Created_at DESC LIMIT 4") or die (mysql_error());
$query1=mysql_query($sql1);
while($data1=mysql_fetch_array($query1))
{
$news_id =$data1['News_id'];
if($news_id > 0){
?>
<li class='active'><a href='http://<?php echo BASE_URL; ?>/coverage_detail.php?id=<?php echo $data1['News_id']; ?>'><span><?php echo $data1['News_name']; ?></span><br/><br/><span><em><?php echo date('d M Y',strtotime($data1['Created_at'])); ?></em></span></a></li>
<?php }
else{
echo "<span>>No News</span>";
}
} ?>
</ul>
</div>
</div>
<div class="row kosong"></div>
<div class="col-lg-12 leftbanner">
<div class="col-lg-4">
<div class="box">
<?php $sql="SELECT * FROM banner ORDER BY Banner_id DESC";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query))
{
?>
<div class="box-gray banner">
<img src="http://<?php echo BASE_URL; ?>/img/banner/<?php echo $row['Image']; ?>">
</div>
<div class="row kosong"></div>
<?php } ?>
</div>
</div>
</div>
</div>
<div class="col-lg-8">
<div class="box">
<div class="box-gray newscontent">
<?php
$batas=3;
if(isset($_GET['page']))
{
$page=$_GET['page'];
}
if(empty($page))
{
$posisi=0;
$page=1;
}
else
{
$posisi=($page-1)*$batas;
}
$sql="SELECT * FROM news WHERE Category_id='2' ORDER BY Created_at DESC LIMIT $posisi,$batas";
$query=mysql_query($sql);
while($data=mysql_fetch_array($query))
{
$desc = htmlentities(strip_tags($data['Description']));
$description = substr($desc,0,700); // ambil 220 karakter
$description = substr($desc,0,strrpos($description," ")); // break per spasi
$news=$data['News_name'];
$create=$data['Created_at'];
?>
<h4 class="location"><?php echo $news; ?></h4>
<img src="http://<?php echo BASE_URL; ?>/img/news/<?php echo $data['News_image']; ?>"><br/><br/>
<?php echo" {$description} .. <a href='{$data['Content']}' target='_blank'>Read More</a>"; ?><br/><br/>
<?php echo '<i>Posted On : '.date('d M Y',strtotime($create)).'</i>'; ?>
<div class="row">
<div class="col-lg-12 linenews">
<div class="solidline">
</div>
</div>
</div>
<?php } ?>
<div class="span6">
<div class="pagination pull-left">
<ul class="pagination">
<?php
$sql2="SELECT * FROM news WHERE Category_id='2' ORDER BY Created_at DESC ";
$query2=mysql_query($sql2);
$jmldata=mysql_num_rows($query2);
$jmlpage=ceil($jmldata/$batas);
for($i=1;$i<=$jmlpage;$i++)
if($i!=$page)
{
echo '<li><a href="media_coverage.php?page='.$i.'">'.$i.'</a></li>';
}
else
{
echo '<li class="active"><a href="#">'.$i.'</a></li>';
}
?>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include "footer.php"; ?>