1st Rank at Webdesign Contest

Web Design Contest

RX Script-Savings - Discount Drug Network

Customizable WordPress Website

static website template

Real Estate Front Page Design

Crafting Unique and Customizeable Websites is my Passion

Movie Database & User Reviews

Online Business Card and Blog

microblog blogpost

Real Estate Front Page Design

static website template

Customizable WordPress Website

❮ ❯

Crafting Unique and Customizeable Websites is my Passion

hero frame

My former Online Business Card and Blog | 1st project in PHP

wp_admin_portfolio September 12, 2020 Back End / Front End / Web Development Bootstrap, CSS, jQuery, MySQL, PHP

Online Business Card and Blog – Blog Page & Blog Post

blog post — Figure 4.0: Single Blog Post

weblog - blog page — Figure 4.1: Single Blog Post

The blog index with its pagination and the blogpost with its rating form are both displayed in the blog.php, depending on if $_GET is set (blogpost displayed) or not (index displayed). Here is the code:

<div class="ml-4">
	<?php
// Wieviel Beiträge seit...

if($posts_gesamt > 1){

?>
	<p class="text-right mx-4 mt-2">
		<?php echo $posts_gesamt;?> Beiträge seit
                                    
		<?php echo date("d.m.Y", strtotime($row["postDate"]));?>.
                                
	</p>
	<?php

}else{

?>
	<p class="text-right mx-4 mt-2">
		<?php echo $posts_gesamt;?> Beitrag seit
                                        
		<?php echo date("d.m.Y", strtotime($row["postDate"]));?>.
                                    
	</p>
</div>
<?php

}//Ende

//Auswahl der Datensätze aus posts
$sql="SELECT postID, postDate, postTitle, postBild, postBildAlt, postMedia, postTube, postBody
     FROM posts ORDER BY postDate DESC
     LIMIT :erster, :anzahl";


//Bei Limit Special
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$abfrage=$db->prepare($sql);

$abfrage->bindParam(":erster",$start);
$abfrage->bindParam(":anzahl",$posts_pro_seite);

$abfrage->execute();

//lokale Zeitzone
setlocale(LC_TIME, "de_DE.utf8");


//Ausgabe - Vorschau der Bloposts
while($row = $abfrage->fetch()){

        //Zeitstempel
        $strtotime = strtotime($row["postDate"]);
        //Wochentag
        $strftimeA = strftime("%A", $strtotime);
        //tag im Monat
        $strftimee = strftime("%e", $strtotime);
        //Monat ausgeschrieben
        $strftimeB = strftime("%B", $strtotime);
        //Jahr
        $strftimeY = strftime("%Y", $strtotime);
        //Stunden
        $strftimeH = strftime("%H", $strtotime);
        //Minuten
        $strftimeM = strftime("%M", $strtotime);

        //tags aus blogposts entfernen
        $dnotags = strip_tags($row["postBody"]);
        //Text kürzen für Post Vorschau
        $b375 = substr($dnotags, 0, 375);
        //position vor abgschnittenem Wort
        $bstrr = strrpos($b375, " ");
        // abgeschnittenes Wort entfernen
        $btrim = substr($b375, 0, $bstrr);

        //Durchschnittliche Bewertung pro Beitrag
        $sql2="SELECT AVG(rateRating) AS durchschnitt
            FROM pratings 
            WHERE postFID = :id    
            ";

        $postID = $row["postID"];


        $abfrage2=$db->prepare($sql2);

        $abfrage2->bindParam(":id",$postID);

        $abfrage2->execute();

        $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>";
        }
        
        //Anzahl Bewertungen pro Beitrag

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


        $abfrage3=$db->prepare($sql3);

        $abfrage3->bindParam(":id",$postID);

        $abfrage3->execute();

        $row3 = $abfrage3->fetch();

        $n =$row3["anzahl"];

        if($n == null){

            $anzahl = "
			<br>";

        }else {

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




?>
					<!-- Vorschauliste der Beiträge-->
					<div class="card bg-dark m-4">
						<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?>
									<a href="blog.php?blogpost=
										<?php echo $row[" postID "]?>#disqus_thread">
									</a>
								</p>
							</div>
							<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;?>h
									<?php echo $strftimeM;?>.
								</span>
								<p class="text-justify">
									<?php echo $btrim ?>...
									<a href="blog.php?blogpost=
										<?php echo $row[" postID "]?>"> Weiterlesen
									</a>
								</p>
							</div>
						</div>
					</div>
					<?php
}
}

//Pagination & Disqus
if(!isset($_GET["blogpost"])){

    include("include/pagination.php");

}else{

    $_GET["blogpost"] = $id;

?>
					<div id="disqus_thread" class="mx-4"></div>
					<script>
                                    /**
                                    *  RECOMMENDED CONFIGURATION VARIABLES: EDIT AND UNCOMMENT THE SECTION BELOW TO INSERT DYNAMIC VALUES FROM YOUR PLATFORM OR CMS.
                                    *  LEARN WHY DEFINING THESE VARIABLES IS IMPORTANT: https://disqus.com/admin/universalcode/#configuration-variables*/
                                    
                                    var disqus_config = function () {
                                    this.page.url = "https://hempel-joel.at/blog.php?blogpost=
						<?php echo $id;?>";  // Replace PAGE_URL with your page's canonical URL variable
                                    this.page.identifier = 
						<?php echo $id;?>; // Replace PAGE_IDENTIFIER with your page's unique identifier variable
                                    this.page.title = "
						<?php echo $title ;?>";
                                    };
                                    
                                    (function() { // DON'T EDIT BELOW THIS LINE
                                    var d = document, s = d.createElement('script');
                                    s.src = 'https://web-development-crypto-it.disqus.com/embed.js';
                                    s.setAttribute('data-timestamp', +new Date());
                                    (d.head || d.body).appendChild(s);
                                    })();
                                
					</script>
					<noscript>Please enable JavaScript to view the 
						<a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a>
					</noscript>
					<?php
}
?>
				</div>
			</div>
		</div>
	</div>
	<?php
include("include/foot.php");
?>

Online Business Card and Blog – blog.php

<ul class="pagination justify-content-center">
	<?php

// Link zur vorherigen Seite
if($seite > 1){

    $vorherige=$seite-1;

?>
	<li class="page-item">
		<a class="page-link bg-dark text-light" href="?seite=
			<?php echo $vorherige;?>">
			<i class="fas fa-angle-double-left">
			</a>
		</i>
	</li>
	<?php

}else{

?>
	<li class="page-item disabled">
		<a class="page-link bg-dark" href="#">
			<i class="fas fa-angle-double-left">
			</a>
		</i>
	</li>
	<?php
}

//Anzahl derSeiten ermitteln und ausgeben
for($x=0; $x < $gesamtSeiten; $x++){

    $seiten_nr = $x + 1;
    if($seite == $seiten_nr){

?>
	<li class="page-item active disabled">
		<a class="page-link bg-dark" href="#">
			<strong>
				<?php echo $seiten_nr ;?>
			</strong>
		</a>
	</li>
	<?php
    } else {
?>
	<li class="page-item">
		<a class="page-link bg-dark text-light" href="?seite=
			<?php echo $seiten_nr;?>">
			<?php echo $seiten_nr;?>
		</a>
	</li>
	<?php

    }
}

// Link zur nächsten Seite

if($seite < $gesamtSeiten){

    $naechste=$seite+1;

?>
	<li class="page-item">
		<a class="page-link bg-dark text-light" href="?seite=
			<?php echo $naechste;?>">
			<i class="fas fa-angle-double-right">
			</a>
		</i>
	</li>
	<?php

}else{

?>
	<li class="page-item disabled">
		<a class="page-link bg-dark" href="#">
			<i class="fas fa-angle-double-right">
			</a>
		</i>
	</li>
	<?php

}

?>
</ul>

pagination.php

<div class="ml-4">
	<?php
// Wieviel Beiträge seit...

if($posts_gesamt > 1){

?>
	<p class="text-right mx-4 mt-2">
		<?php echo $posts_gesamt;?> Beiträge seit
                                    
		<?php echo date("d.m.Y", strtotime($row["postDate"]));?>.
                                
	</p>
	<?php

}else{

?>
	<p class="text-right mx-4 mt-2">
		<?php echo $posts_gesamt;?> Beitrag seit
                                        
		<?php echo date("d.m.Y", strtotime($row["postDate"]));?>.
                                    
	</p>
</div>
<?php

}//Ende

//Auswahl der Datensätze aus posts
$sql="SELECT postID, postDate, postTitle, postBild, postBildAlt, postMedia, postTube, postBody
     FROM posts ORDER BY postDate DESC
     LIMIT :erster, :anzahl";


//Bei Limit Special
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$abfrage=$db->prepare($sql);

$abfrage->bindParam(":erster",$start);
$abfrage->bindParam(":anzahl",$posts_pro_seite);

$abfrage->execute();

//lokale Zeitzone
setlocale(LC_TIME, "de_DE.utf8");


//Ausgabe - Vorschau der Bloposts
while($row = $abfrage->fetch()){

        //Zeitstempel
        $strtotime = strtotime($row["postDate"]);
        //Wochentag
        $strftimeA = strftime("%A", $strtotime);
        //tag im Monat
        $strftimee = strftime("%e", $strtotime);
        //Monat ausgeschrieben
        $strftimeB = strftime("%B", $strtotime);
        //Jahr
        $strftimeY = strftime("%Y", $strtotime);
        //Stunden
        $strftimeH = strftime("%H", $strtotime);
        //Minuten
        $strftimeM = strftime("%M", $strtotime);

        //tags aus blogposts entfernen
        $dnotags = strip_tags($row["postBody"]);
        //Text kürzen für Post Vorschau
        $b375 = substr($dnotags, 0, 375);
        //position vor abgschnittenem Wort
        $bstrr = strrpos($b375, " ");
        // abgeschnittenes Wort entfernen
        $btrim = substr($b375, 0, $bstrr);

        //Durchschnittliche Bewertung pro Beitrag
        $sql2="SELECT AVG(rateRating) AS durchschnitt
            FROM pratings 
            WHERE postFID = :id    
            ";

        $postID = $row["postID"];


        $abfrage2=$db->prepare($sql2);

        $abfrage2->bindParam(":id",$postID);

        $abfrage2->execute();

        $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>";
        }
        
        //Anzahl Bewertungen pro Beitrag

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


        $abfrage3=$db->prepare($sql3);

        $abfrage3->bindParam(":id",$postID);

        $abfrage3->execute();

        $row3 = $abfrage3->fetch();

        $n =$row3["anzahl"];

        if($n == null){

            $anzahl = "
			<br>";

        }else {

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




?>
					<!-- Vorschauliste der Beiträge-->
					<div class="card bg-dark m-4">
						<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?>
									<a href="blog.php?blogpost=
										<?php echo $row[" postID "]?>#disqus_thread">
									</a>
								</p>
							</div>
							<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;?>h
									<?php echo $strftimeM;?>.
								</span>
								<p class="text-justify">
									<?php echo $btrim ?>...
									<a href="blog.php?blogpost=
										<?php echo $row[" postID "]?>"> Weiterlesen
									</a>
								</p>
							</div>
						</div>
					</div>
					<?php
}
}

//Pagination & Disqus
if(!isset($_GET["blogpost"])){

    include("include/pagination.php");

}else{

    $_GET["blogpost"] = $id;

?>
					<div id="disqus_thread" class="mx-4"></div>
					<script>
                                    /**
                                    *  RECOMMENDED CONFIGURATION VARIABLES: EDIT AND UNCOMMENT THE SECTION BELOW TO INSERT DYNAMIC VALUES FROM YOUR PLATFORM OR CMS.
                                    *  LEARN WHY DEFINING THESE VARIABLES IS IMPORTANT: https://disqus.com/admin/universalcode/#configuration-variables*/
                                    
                                    var disqus_config = function () {
                                    this.page.url = "https://hempel-joel.at/blog.php?blogpost=
						<?php echo $id;?>";  // Replace PAGE_URL with your page's canonical URL variable
                                    this.page.identifier = 
						<?php echo $id;?>; // Replace PAGE_IDENTIFIER with your page's unique identifier variable
                                    this.page.title = "
						<?php echo $title ;?>";
                                    };
                                    
                                    (function() { // DON'T EDIT BELOW THIS LINE
                                    var d = document, s = d.createElement('script');
                                    s.src = 'https://web-development-crypto-it.disqus.com/embed.js';
                                    s.setAttribute('data-timestamp', +new Date());
                                    (d.head || d.body).appendChild(s);
                                    })();
                                
					</script>
					<noscript>Please enable JavaScript to view the 
						<a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a>
					</noscript>
					<?php
}
?>
				</div>
			</div>
		</div>
	</div>
	<?php
include("include/foot.php");
?>

Pages: 1 2 3 4

Leave a Reply Cancel reply

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

Cookie	Duration	Description
__cfduid	1 month	The cookie is used by cdn services like CloudFare to identify individual clients behind a shared IP address and apply security settings on a per-client basis. It does not correspond to any user ID in the web application and does not store any personally identifiable information.
__cfruid	session	This cookie is set by the provider Cloudflare. This cookie is used for load balancing and for identifying trusted web traffic.
__zlcmid	1 year	This cookie is used by Zendesk live chat and is used to store the live chat ID.
_GRECAPTCHA	5 months 27 days	This cookie is set by Google. In addition to certain standard Google cookies, reCAPTCHA sets a necessary cookie (_GRECAPTCHA) when executed for the purpose of providing its risk analysis.
AWSALBCORS	7 days	This cookie is used for load balancing services provded by Amazon inorder to optimize the user experience. Amazon has updated the ALB and CLB so that customers can continue to use the CORS request with stickness.
cookielawinfo-checbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-advertisement	1 year	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Advertisement".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.

Cookie	Duration	Description
__zlcmid	1 year	This cookie is used by Zendesk live chat and is used to store the live chat ID.
lang		This cookie is used to store the language preferences of a user to serve up content in that stored language the next time user visit the website.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

Cookie	Duration	Description
YSC	session	This cookies is set by Youtube and is used to track the views of embedded videos.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.

Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.

Cookie	Duration	Description
_pxhd	1 year	This cookie is used by the Zoominfo. This cookie collects information on user behaviour on multiple websites. This information is used inorder to optimize the relevance of advertisements.
IDE	1 year 24 days	Used by Google DoubleClick and stores information about how the user uses the website and any other advertisement before visiting the website. This is used to present users with ads that are relevant to them according to the user profile.
test_cookie	15 minutes	This cookie is set by doubleclick.net. The purpose of the cookie is to determine if the user's browser supports cookies.
VISITOR_INFO1_LIVE	5 months 27 days	This cookie is set by Youtube. Used to track the information of the embedded YouTube videos on a website.

Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.

Cookie	Duration	Description
CONSENT	16 years 10 months 2 days 2 hours 3 minutes	No description
u_guid	1 year	No description

top frame

freebie picture

STAY TUNED &
SUBSCRIBE

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

Get in Touch

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