33 lines
1.1 KiB
PHP
33 lines
1.1 KiB
PHP
<?php
|
|
include('templates/header.php');
|
|
include('templates/bio.php');
|
|
|
|
require('creds.php');
|
|
|
|
$result = mysqli_query($mysqli, "SELECT ID, Title, Mood, MoodImage, Song, DATE_FORMAT(Time, '%d-%m-%Y %H:%i'), Message FROM articles ORDER BY ID DESC");
|
|
|
|
while($res = mysqli_fetch_array($result)) {
|
|
echo "<div class='window' id='".$res['ID']."'>";
|
|
echo " <div class='window-bar'>";
|
|
echo " <span>".$res['Title']."</span>";
|
|
echo " <span class='post-date'>".$res["DATE_FORMAT(Time, '%d-%m-%Y %H:%i')"]."</span>";
|
|
echo " </div>";
|
|
echo " <div class='window-content'>";
|
|
echo " <span class='pre-post'>";
|
|
echo " <b class='mood'>current mood:</b> <img class='mood' src='img/moods/".$res['MoodImage']."' alt='".$res['MoodImage']."'> ".$res['Mood'];
|
|
echo " </span>";
|
|
echo " <br>";
|
|
echo " <span class='pre-post'>";
|
|
echo " <b class='tunes'>current tunes:</b> ".$res['Song'];
|
|
echo " </span>";
|
|
echo " <hr>";
|
|
echo $res['Message'];
|
|
echo " <hr>";
|
|
echo " <span class='options'>share: <input type='text' readonly='readonly' value='".$root."/#".$res['ID']."'></span>";
|
|
echo " </div>";
|
|
echo "</div>";
|
|
}
|
|
|
|
include('templates/footer.php');
|
|
?>
|