git.shiar.nl
/
minimedit.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
issue: select restricted by current page
[minimedit.git]
/
issue
/
index.php
diff --git
a/issue/index.php
b/issue/index.php
index ff99064574b88658893271e011dd49f0f97e09e1..d07a7863af8a57528077c5de10233c5d70d7e61a 100644
(file)
--- a/
issue/index.php
+++ b/
issue/index.php
@@
-7,7
+7,7
@@
if ($id) {
$Article->title = "Issue #$id";
$Issue = $Db->query(
$Article->title = "Issue #$id";
$Issue = $Db->query(
- 'SELECT * FROM issues WHERE
id = ?', [
$id]
+ 'SELECT * FROM issues WHERE
page = ? AND id = ?', [$Page,
$id]
)->fetch();
if (!$Issue) throw new Exception('Issuenummer niet gevonden');
)->fetch();
if (!$Issue) throw new Exception('Issuenummer niet gevonden');
@@
-50,12
+50,12
@@
if ($_POST) {
$_POST = [];
}
$_POST = [];
}
-$sql = 'SELECT * FROM issues';
+$sql = 'SELECT * FROM issues
WHERE page = ?
';
if (isset($_GET['open'])) {
if (isset($_GET['open'])) {
- $sql .= '
WHERE
closed IS NULL';
+ $sql .= '
AND
closed IS NULL';
}
$sql .= ' ORDER BY closed IS NOT NULL, updated DESC';
}
$sql .= ' ORDER BY closed IS NOT NULL, updated DESC';
-$query = $Db->query($sql);
+$query = $Db->query($sql
, [$Page]
);
ob_start();
print '<ul>';
ob_start();
print '<ul>';