Crafting Unique and Customizeable Websites is my Passion

Crafting Unique and Customizeable Websites is my Passion

hero frame

Section 3 displays a preview of the latest blog post, including the date, thumbnail, and excerpt:

Figure 3.0: Latest Blog Post

In order to render the latest blog entry, we first must query the database like so:

//Connect Database include("connect.php")

    $db = new PDO("mysql:host=localhost;dbname=john_doe_db;charset=utf8",

} catch(PDOException $e){

    //if connections fails
    die("No Connection!");

//SQL statement to query the latest blog post from the POSTS TABLE
$sql="SELECT postID, postDate, postTitle, postBild, postBildAlt, postMedia, postTube, postBody
     FROM posts LIMIT 1";

//prepared statement. Optional in this case due to no wildcard and no $_GET
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

//local german timezone. 
setlocale(LC_TIME, "de_DE.utf8");

$row = $abfrage->fetch();

Next we first convert from English to German time format (IT’s a german blog) and then calculate the average post rating with another SQL statement. we use an if statement in order to distinguish between two cases. case 1 the post hasn’t been rated yet. case 2 the post already has been rated.

//Timestamp is saved as strin in the db therefor we neeed the strtotime() method
$strtotime = strtotime($row["postDate"]);
//German weekday
$strftimeA = strftime("%A", $strtotime);
//Day of the month
$strftimee = strftime("%e", $strtotime);
//Month no abbr.
$strftimeB = strftime("%B", $strtotime);
$strftimeY = strftime("%Y", $strtotime);
$strftimeH = strftime("%H", $strtotime);
$strftimeM = strftime("%M", $strtotime);

//trim text and strip tags...
$dnotags = strip_tags($row["postBody"]);
$b200 = substr($dnotags, 0, 200);
$bstrr = strrpos($b200, " ");
$btrim = substr($b200, 0, $bstrr);

//Calculate average rating form the RATING TABLE using sql
$sql2="SELECT AVG(rateRating) AS durchschnitt
    FROM pratings 
    WHERE postFID = :id    
//We use the id from the POSTS TABLE 
$postID = $row["postID"];

$row2 = $abfrage2->fetch();

$avg = number_format($row2["durchschnitt"], 1, ",", ".");

if($row2["durchschnitt"] == null){

    $durchschnitt = "<p class='ml-2'>noch nicht bewertet";

} else {

    $durchschnitt = "<p class='ml-2'><span class='text-danger'> $avg</span>/5 Punkten <br>";

Let’s now count how many time the post was rated


$sql3="SELECT COUNT(rateRating) AS anzahl
    FROM pratings 
    WHERE postFID = :id    


$row3 = $abfrage3->fetch();

$n =$row3["anzahl"];

if($n == null){

    $anzahl = "</p>";

}else {

    $anzahl = "Bewertet von <span class='text-danger'> $n </span> Besucher</p>";


Finally let’s render our latest post and produce some HTML.

<!-- Render latest post-->
<div class="card bg-dark text-light mx-5 mt-1 mb-5">            
    <div class="card-body ppost">
        <div class="pimg mt-2 mx-2 rounded">
            <img class="rounded-top" src="bilder/<?php echo $row["postBild"];?>" alt="<?php echo $row["postBildAlt"]?>" style="max-width:100%;">
                <?php echo $durchschnitt?>
                <?php echo $anzahl?>
        <div class="ml-2 ">
                <h4 class="mt-0 pt-0"><?php echo $row["postTitle"];?></h4>
                <span class="text-danger">gepostet am: <?php echo $strftimeA;?> den <?php echo $strftimee;?>. <?php echo $strftimeB;?> <?php echo $strftimeY;?> um <?php echo $strftimeH;?>:<?php echo $strftimeM;?> Uhr.</span>          
                <p class="text-justify"><?php echo $btrim ?>...<a href="blog.php?blogpost=<?php echo $row["postID"]?>"> Weiterlesen</a></p>


be the first to share shared this post

Leave a Reply

Your email address will not be published. Required fields are marked *

top frame
freebie picture

Sign up to my mailing list and receive occasional updates, new bogposts, freebies, giveaways and more

    Terms of privacy and data protection

    Get in Touch

    Feel free to send me a message. I'll gladly respond to all your requests.