-
Notifications
You must be signed in to change notification settings - Fork 0
/
news2.php
152 lines (114 loc) · 4.81 KB
/
news2.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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<?php
include_once 'bnav.php';
?>
<div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.4";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
<section id="aboutbrio">
<div class="container">
<div class="row">
<div class="text-center bgGFont opsix">NEWS</div>
<!-- <div class="arrow_box">
<h1 class="logo">css arrow please!</h1>
</div>-->
<div class="text-center meetbrio">WHAT'S NEW AT BRIO</div>
</div>
</div>
</section>
<!--HOME SECTION END -->
<section id="aboutus" class="arrow_box">
<div class="hidden-xs container">
<div class="row text-center pad-bottom">
<h2 class="pad-top30"></h2><h2 class="pad-top30"></h2>
<h4 class="brlineheight">Fair warning: This section may seem a bit flighty. We're constantly looking for ways to get involved in our community, share interesting tips and info, or give our awesome employees the recognition they deserve, so there's always something new for us to share with you here!
</h4>
</div>
</div>
<div class="container">
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading"> <span class="glyphicon glyphicon-list-alt"></span><b> BRIO NEWS</b></div>
<div class="panel-body">
<div class="row">
<div class="col-xs-12">
<ul id="nav">
<?php
//$string = file_get_contents("NewsArticle.json");
//$arrayj=json_decode($string,true);
$db = new PDO('sqlite:site.db');
$result = $db->query("SELECT * FROM NEWS");
foreach($result as $row)
{
echo "<li class='news-item' id="."><a href=#".$row['Id']."><strong>".$row['Title']."</strong></br>more...</a></li>";
}
echo '</ul>
</div></div></div><div class="panel-footer"> ';
</div></div>
?>
<div class="">
<?php
include_once 'jcar.php';
?>
</div>
<div class="fb-page" data-href="https://www.facebook.com/brioinsurance" data-width="500" data-height="300" data-small-header="true" data-adapt-container-width="true" data-hide-cover="false" data-show-facepile="false" data-show-posts="true"><div class="fb-xfbml-parse-ignore"><blockquote cite="https://www.facebook.com/brioinsurance"><a href="https://www.facebook.com/brioinsurance">Brio Insurance</a></blockquote></div></div>
</div>
<?php
echo '<div class="col-md-9"><div id="tab-content">';
$result = $db->query("SELECT * FROM NEWS");
foreach($result as $row)
{
echo "<div id=".$row['Id']." class='article' >".$row['TextData']."</div>";
}
$db = NULL;
?>
<div id="twitter-container">
<a href="https://twitter.com/SunovaCU" id="twitter-handle" target="_blank"></a>
<div id="twitter-feed">
<img src="http://sunovacu.ca/Images/News/quotations_left_teal.png" alt="" class="float-left">
<img src="http://sunovacu.ca/Images/News/quotations_right_teal.png" alt="" class="float-right">
<iframe id="twitter-widget-0" scrolling="no" frameborder="0" allowtransparency="true" class="twitter-timeline twitter-timeline-rendered" allowfullscreen="true" style="position: static; visibility: visible; display: inline-block; width: 100%; height: 125px; padding: 0px; border: none; max-width: 600px; min-width: 180px; margin-top: 0px; margin-bottom: 0px;" data-widget-id="302181776644771840" data-user-id="356440503" title="Twitter Timeline"></iframe>
<script>!function (d, s, id) { var js, fjs = d.getElementsByTagName(s)[0], p = 'https'; if (!d.getElementById(id)) { js = d.createElement(s); js.id = id; js.src = p + "://platform.twitter.com/widgets.js"; fjs.parentNode.insertBefore(js, fjs); } } (document, "script", "twitter-wjs");</script>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<script type="text/javascript">
$('#tab-content div').hide();
$('#tab-content div:first').show();
$(function () {
$("#nav").bootstrapNews({
newsPerPage: 3,
autoplay: true,
navigation:true,
onToDo: function () {
//console.log(this);
}
});
$('#nav li').click(function(event) {
$('#nav li a').removeClass("active");
$(this).find('a').addClass("active");
$('#tab-content div').hide();
var indexer = $(this).index(); //gets the current index of (this) which is #nav li
var target_news=$(this).children(":first").attr("href");
$(target_news).fadeIn();
}); //end of click
}); //end of function
</script>
<div class="container aboutbrio col-md-12">
<div class="row">
<div class="text-center bgGFont opsix"></div>
<div class="text-center meetbrio"></div>
</div>
</div>
<?php
include_once 'bfooter.php';
?>