brc/collections.php

32 lines
851 B
PHP
Raw Permalink Normal View History

2020-10-30 23:14:38 +01:00
<?php
$show_sep=true;
$db = new PDO('sqlite:projects_data/projects.db') or die('database error');
2020-10-30 23:14:38 +01:00
include('header.tpl');
?>
2020-10-30 22:27:38 +01:00
<div id="content_padding">
<div class="collection_container">
<?php
foreach($db->query('select id, name, cover_image from collections;') as $c) {
$collection_id = $c['id'];
$cover_image = $c['cover_image'];
$collection_name = $c['name'];
print("
<div class='collection'>
<div class='flexbox-col-img'>
<div class='col-img-container'>
<a class='col-img-desc' href='show_collection.php?id={$collection_id}'>
<img class='col-image' src='projects_data/img/{$cover_image}' alt='example image for {$collection_name}'>
</a>
2020-10-30 01:12:05 +01:00
</div>
</div>
<h1>{$collection_name}</h1>
</div>
");
}
?>
</div>
</div>
2020-10-28 21:14:03 +01:00
<?php include('footer.tpl'); ?>