BootstrapSQLiteBlog/pages/directory.php

47 lines
2.0 KiB
PHP

<?php
global $c;
$varPostLocations = $c->query("SELECT distinct location from posts order by location");
$varLinks = $c->query("SELECT * from links order by sort");
?>
<div class="navbar navbar-expand bg-body-tertiary d-flex px-3 sticky-top">
<div class="container justify-content-between">
<div class="navbar-nav d-inline-flex align-items-center">
<span class="navbar-brand">Directory</span>
</div>
<div class="navbar-nav d-inline-flex">
</div>
</div>
</div>
<div class="container my-5">
<div class="row mb-4">
<div class="col-lg-6">
<h5 class="mb-3"><i class="fa fa-fw fa-comment pe-2"></i> Posts</h5>
<?php foreach ($varPostLocations as $i): ?>
<?php
$intPostCount = $c->query("SELECT count(*) as c from posts where location = ?", $i["location"])[0]["c"];
?>
<div class="border p-2 mb-2">
<a class="link-underline link-underline-opacity-0" href="<?= $i["location"]; ?>"><i class="fa fa-fw fa-file pe-2"></i> <?= $i["location"]; ?></a>
<small class="text-muted">&mdash; <?= $intPostCount !== 1? "{$intPostCount} posts": "{$intPostCount} post"; ?></small>
</div>
<?php endforeach; ?>
</div>
</div>
<div class="row mb-4">
<div class="col-lg-6">
<h5 class="mb-3"><i class="fa fa-fw fa-link pe-2"></i> Links</h5>
<?php foreach ($varLinks as $i): ?>
<?php if (!UserAuth::visible($i["visibility"])) continue; ?>
<div class="border p-2 mb-2">
<a class="link-underline link-underline-opacity-0" href="<?= $i["url"]; ?>"><i class="fa fa-fw fa-<?= $i["icon"]; ?> pe-2"></i> <?= $i["label"]; ?></a>
<small class="text-muted">&mdash; <?= $i["position"]; ?></small>
</div>
<?php endforeach; ?>
</div>
</div>
</div>