<?php /* Template Name: InfobriefPage */?>
<?php
get_header();
//LOAD LETTERS:
global $wpdb;
$table_name = $wpdb->prefix . 'custom_infobriefe';
$id = $_GET["l"];
if($id) {
    $sql = "SELECT * FROM $table_name WHERE id=$id ORDER BY date DESC";
    $single_letter = $wpdb->get_results($sql)[0];
    $sql = "SELECT id, title, thumbnail_url FROM $table_name WHERE recommended = 1 AND thumbnail_url IS NOT NULL AND id != '$id' ORDER BY RAND() LIMIT 8";
    $recommendations = $wpdb->get_results($sql);
    ?>
    <div class="infobriefe-container">
        <?php
        $tempDate = date_create($single_letter->date);
        $transformed_date = date_format($tempDate, "d.m.Y");
        if(current_user_can("edit_posts")) { ?>
            <a href="https://www.mein-persoenliches-konzept.com/wp-admin/admin.php?page=infobriefAdminPage.php"><div class="back-to-admin-page-link">
                <p>--> Zurück zur Adminseite <--</p>
            </div></a>
        <?php }
        ?>
        <div class="infobrief-wrapper">
            <h1><?php echo $single_letter->title; ?></h1>
            <p><?php echo apply_filters('the_content', $single_letter->content); ?></p>
            <span class="infobrief-date"><?php echo $transformed_date; ?></span>
        </div>
        <div class="clearfix"></div>
        <?php if($recommendations) { ?>
            <div class="infobrief-recommendations-container">
                <h3>Auch lesenswert:</h3>
                <div class="infobrief-recommendations-wrapper">
                    <?php foreach($recommendations as $recom) {
                        $title = $recom->title; //maybe shorten
                        if(strlen($title) > 30) {
                            $title = substr($title, 0, 30) . "...";
                        }
                        $thumbnail_url = $recom->thumbnail_url;
                        $recom_id = $recom->id;

            }
 
            break;
        }
    }
 
    if ( ! $template ) {
        $template = get_index_template();
    }
 
    /**
     * Filters the path of the current template before including it.
     *
     * @since 3.0.0
     *
     * @param string $template The path of the template to include.
     */
    $template = apply_filters( 'template_include', $template );
    if ( $template ) {
        include $template;
    } elseif ( current_user_can( 'switch_themes' ) ) {
        $theme = wp_get_theme();
        if ( $theme->errors() ) {
            wp_die( $theme->errors() );
        }
    }
    return;
}
 

<?php
/**
 * Loads the WordPress environment and template.
 *
 * @package WordPress
 */
 
if ( ! isset( $wp_did_header ) ) {
 
    $wp_did_header = true;
 
    // Load the WordPress library.
    require_once __DIR__ . '/wp-load.php';
 
    // Set up the WordPress query.
    wp();
 
    // Load the theme template.
    require_once ABSPATH . WPINC . '/template-loader.php';
 
}
 

<?php
/**
 * Front to the WordPress application. This file doesn't do anything, but loads
 * wp-blog-header.php which does and tells WordPress to load the theme.
 *
 * @package WordPress
 */
 
/**
 * Tells WordPress to load the WordPress theme and output it.
 *
 * @var bool
 */
define( 'WP_USE_THEMES', true );
 
/** Loads the WordPress Environment and Template */
require __DIR__ . '/wp-blog-header.php';