forked from jmatholia/fundbook
-
Notifications
You must be signed in to change notification settings - Fork 0
/
music.php
39 lines (36 loc) · 1.23 KB
/
music.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
<?php include("headers.php"); ?>
<!-- TOP PROJECTS INFO-->
<center>
<h1 id="topic_heading"> Top Projects in <font color=#265a88>Music</font> </h1>
</center>
<!-- 3 Project Previews-->
<center>
<hr color=#6699FF size="6">
<div class="row">
<center>
<?php // GET THE ART PROJECTS
$dsn = "mysql:host=localhost;dbname=fundbook";
$db = new PDO($dsn, "root", "fundbook");
$projects=$db->query("SELECT * FROM projects where topic='Music'");
if ($projects->rowCount() > 0) {
foreach ($projects as $project) {
echo '<div class="col-sm-6 col-md-4">
<div class="thumbnail">
<img src= ' . $project["picture"] . ' alt="..." width="450" height="300">
<div class="caption">
<h3>'. $project["name"] .'</h3>
<p>' . $project["description"] . '</p>
<p><a href="example.php?pid='. $project["pid"] .
'" class="btn btn-primary" role="button">View Page</a>
<button href="" class="btn btn-default" role="button" val="like" pid="'. $project["pid"] . '">Add To Interests</button>
</p>
</div>
</div>
</div>';
}
}
?>
</center>
</div>
</center>
<?php include("footers.php"); ?>