-
Notifications
You must be signed in to change notification settings - Fork 3
/
view_article.php
70 lines (54 loc) · 1.63 KB
/
view_article.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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<?php //TODO make this a smarty template
include('db.php');
include('function.php');
include('related_articles.php');
// Require id in query params
$id = $_GET["id"];
$related_article_ids = get_related_articles($id);
$statement = $connection->prepare(
"SELECT * FROM articles WHERE id=:id"
);
$statement->execute(
array(
":id" => $id
)
);
// Grab article info
$article = $statement->fetchObject("ArticleDTO");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<title>Article</title>
</head>
<body>
<a id="add_button" data-toggle="modal" data-target="#userModal" class="btn btn-info btn-lg"
href="edit_article.php?id=<?= $article->id ?>">
Edit This Article
</a>
<p>
<b>Author name:</b>
<?= $article->author_name ?>
</p>
<div class="container">
<?= $article->article_text ?>
</div>
<p>
<b><br>Related Articles</b>
</p>
</body>
</html>
<?php
foreach ($related_article_ids as $related_id) {
$statement = $connection->prepare("SELECT * FROM articles WHERE id = :id");
$statement->execute(array(":id" => $related_id));
$related_article = $statement->fetch(PDO::FETCH_ASSOC);
// Display the related article (modify this as per your design)
echo "<h5>" . $related_article['author_name'] . "</h5>";
echo "<p>" . $related_article['article_text'] . "</p>";
echo "<a href='view_article.php?id=" . $related_article['id'] . "'>Read More</a>";
echo "<hr>"; // a line separator for each article
}
?>