-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsingle-post.php
112 lines (88 loc) · 5.03 KB
/
single-post.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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php
$servername = "127.0.0.1";
$username = "root";
$password = "root";
$dbname = "vivify_blog_3_dan";
try {
$connection = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
echo $e->getMessage();
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="shortcut icon" href="favicon.ico">
<title>Vivify Academy Blog - Homepage</title>
<link rel="stylesheet" href="css/styles.css">
</head>
<body class="va-l-page va-l-page--single">
<?php include('header.php'); ?>
<div class="va-l-container">
<main class="va-l-page-content">
<?php
if (isset($_GET['post_id'])) {
$postId = $_GET['post_id'];
// pripremamo upit
$sql = "SELECT id, title, created_at, content, created_by FROM posts WHERE id = {$postId}";
$statement = $connection->prepare($sql);
// izvrsavamo upit
$statement->execute();
// zelimo da se rezultat vrati kao asocijativni niz.
// ukoliko izostavimo ovu liniju, vratice nam se obican, numerisan niz
$statement->setFetchMode(PDO::FETCH_ASSOC);
// punimo promenjivu sa rezultatom upita
$singlePost = $statement->fetch();
// koristite var_dump kada god treba da proverite sadrzaj neke promenjive
// echo '<pre>';
// var_dump($singlePost);
// echo '</pre>';
?>
<article class="va-c-article">
<header>
<h1><?php echo($singlePost['title']) ?></h1>
<h3>category: <strong>Sports</strong></h3>
<div class="va-c-article__meta">12.06.2017. by John Doe</div>
</header>
<div>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Incidunt vitae molestias rem repellendus commodi provident? Magnam, nobis quisquam perferendis consectetur deserunt laboriosam pariatur a, eum suscipit ratione iusto ullam aperiam quas quod culpa dolore corrupti voluptatem placeat enim commodi in.</p>
<p>Vel quasi sunt rem unde ea repellat eveniet at officia totam. Provident ut harum temporibus impedit odio quam amet accusamus ad quisquam velit incidunt praesentium cupiditate consectetur repellendus, fugiat quidem, officiis laudantium autem possimus ullam minima adipisci itaque? Eos, minus!</p>
<p>Veritatis exercitationem enim magnam deserunt velit facere quos ea hic quibusdam molestiae minus, earum reprehenderit error architecto cum cumque perferendis quas impedit rerum sapiente facilis debitis! Error, obcaecati ea illum beatae voluptate consequatur, iusto quam sapiente fugiat, exercitationem maiores similique?</p>
<p>Magni provident ex, doloribus architecto labore corrupti numquam. Beatae cumque alias aliquam iste ratione dolore in, odio libero numquam nemo reprehenderit modi magnam a laboriosam, ab quidem itaque deserunt explicabo facere deleniti illum, fuga vitae. Officiis at laborum doloremque assumenda.</p>
</div>
<footer>
<h3>tags: <a>football</a>, <a>champions league</a>, <a>qualifiers</a></h3>
</footer>
<div class="comments">
<h3>comments</h3>
<div class="single-comment">
<div>posted by: <strong>Pera Peric</strong> on 15.06.2017.</div>
<div>Provident ut harum temporibus impedit odio quam amet accusamus ad quisquam velit incidunt praesentium cupiditate consectetur repellendus, fugiat quidem, officiis laudantium autem possimus ullam minima adipisci itaque? Eos, minus!</div>
</div>
<div class="single-comment">
<div>posted by: <strong>Mitar Miric</strong> on 18.06.2017.</div>
<div>Incidunt praesentium cupiditate consectetur repellendus, fugiat quidem, officiis laudantium autem possimus ullam minima adipisci itaque? Eos, minus!</div>
</div>
<div class="single-comment">
<div>posted by: <strong>Dule Savic</strong> on 20.06.2017.</div>
<div>Jedna je Crvena Zvezda!</div>
</div>
</div>
<?php
} else {
echo('post_id parameter was not sent through $_GET.');
}
?>
</article>
</main>
</div>
<?php include('footer.php'); ?>
</body>
</html>