<option value=''>Year</option>
<?php
$year = date(Y);
for ($i = 1; $i <= 50; $i++) {
?>
<option value="<?php
echo getYears($year);
?>
" <?php
if (getYears($year) == $year_2) {
echo 'selected="selected"';
}
?>
><?php
echo getYears($year);
?>
</option>
<?php
$year = $year - 1;
}
?>
</select>
</div>
<!-- -->
<div class='select-circles small-circles vert-seperate' id='colour_select'>
<strong>Select Theme </strong>
<?php
$i = 0;
foreach ($colours as $name => $hex) {
<?php
require "access/connexion.php";
require "functions.php";
$objects = array();
$years = getYears();
$strings = array();
$sth = $dbh->query('SELECT artist.firstName, artist.name,
country.c_name,
edition.ed_1973, edition.ed_1974,
edition.ed_1975, edition.ed_1976,
edition.ed_1977, edition.ed_1978,
edition.ed_1979, edition.ed_1980,
edition.ed_1981, edition.ed_1982,
edition.ed_1983, edition.ed_1984,
edition.ed_1985, edition.ed_1986,
edition.ed_1987, edition.ed_1988,
edition.ed_1989, edition.ed_1990,
edition.ed_1991, edition.ed_1992,
edition.ed_1993, edition.ed_1994,
edition.ed_1995, edition.ed_1996,
edition.ed_1997, edition.ed_1998,
edition.ed_1999, edition.ed_2000,
edition.ed_2001, edition.ed_2002,
edition.ed_2003, edition.ed_2004,
edition.ed_2005, edition.ed_2006,
edition.ed_2007, edition.ed_2008,
edition.ed_2009
FROM artist
INNER JOIN country
?>
</span></a>
</li>
</ul>
</div>
</div><!-- /.container-fluid -->
</nav>
<div id="sidebar-collapse" class="col-sm-3 col-lg-2 sidebar">
<ul class="nav menu">
<li class="parent ">
<a href="index"><span class="glyphicon glyphicon-home"></span> Home</a>
<?php
$i = 0;
$yearList = getYears();
foreach ($yearList as $years) {
if (isset($_GET['year']) && $_GET['year'] == $years) {
echo "<a href=\"#d" . $i . "\" data-toggle=\"collapse\" data-parent=\"#MainMenu\"><span class=\"glyphicon glyphicon-chevron-down\"></span>" . $years . "<button onclick=\"openDeleteYear('" . $years . "');\" style=\"border:0; background:transparent\" class=\"pull-right hidden-xs showopacity glyphicon glyphicon-trash\"></button></a>";
echo "<div class=\"collapse in\" id=\"d" . $i . "\">";
foreach (getSections($years) as $section) {
if (isset($_GET['section']) && $_GET['section'] == $section["name"]) {
echo "<a onclick=\"updatePrams('" . $years . "','" . $section["name"] . "','" . $section["ID"] . "')\" class=\"active list-group-item\">" . $section["name"] . "<button onclick=\"openEditSection('" . $section["name"] . "','" . $section["ID"] . "','" . $years . "');\" style=\"border:0; background:transparent\" class=\"pull-right hidden-xs showopacity glyphicon glyphicon-pencil\"></button></a>\n";
} else {
echo "<a onclick=\"updatePrams('" . $years . "','" . $section["name"] . "','" . $section["ID"] . "')\" class=\"list-group-item\">" . $section["name"] . "<button onclick=\"openEditSection('" . $section["name"] . "','" . $section["ID"] . "','" . $years . "');\" style=\"border:0; background:transparent\" class=\"pull-right hidden-xs showopacity glyphicon glyphicon-pencil\"></button></a>\n";
}
}
echo "</div>";
} else {
echo "<a href=\"#d" . $i . "\" data-toggle=\"collapse\" data-parent=\"#MainMenu\"><span class=\"glyphicon glyphicon-chevron-down\"></span>" . $years . "<button onclick=\"openDeleteYear('" . $years . "');\" style=\"border:0; background:transparent\" class=\"pull-right hidden-xs showopacity glyphicon glyphicon-trash\"></button></a>";
echo "<div class=\"collapse\" id=\"d" . $i . "\">";