OwlCyberSecurity - MANAGER

Edit File: post_api.php

<html>
<head>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
    <link href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN" crossorigin="anonymous">
    <link href="https://fonts.googleapis.com/css?family=Alegreya+Sans" rel="stylesheet">
</head>
<body>
<div class="container-fluid" style="margin-top: 20px;">
    <style>
        @media (max-width: 975px) {
            .smallOnPhone{
                max-height: 70px;
            }
            .floatSM{

}
        }
    </style>
    <div class="row">
        <?php

include('wp-load.php');
        //enter the connection details here

$database	= "myedubas_stagatv";
        $password	= "stagaTV109$";
        $hostname	= "localhost";
        $username	= 'myedubas_stagatv';
        $charset = 'utf8mb4';

//connection to the database
        $dsn = "mysql:host=$hostname;dbname=$database;charset=$charset";
        $options = [
            PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_EMULATE_PREPARES   => false,
        ];
        try {
            $pdo = new PDO($dsn, $username, $password, $options);
        } catch (\PDOException $e) {
            throw new \PDOException($e->getMessage(), (int)$e->getCode());
        }

$range = $_GET['range'];

//        $stmt1	= $pdo->prepare("SELECT * FROM wpwh_posts WHERE post_status = 'publish' ORDER BY id DESC LIMIT $range");
//        $stmt1->execute();
//        $posts = $stmt1->fetchAll();

$args = array(
            'tag' => get_queried_object()->slug, // If permalink like example.com/tag/example-tag, etc.
            'posts_per_page' => $range,
            'tax_query' => array(
                array(
                    'taxonomy' => 'category', // Taxonomy, in my case I need default post categories
                    'field'    => 'slug',
                    'terms'    => 'sport-videos', // Your category slug (I have a category 'interior')
                ),
                "orderby"          => "post_date",
                "post_type"        => "post",
                "post_status"      => "publish",
                "order"            => "DESC",
            )
        ); // Get all posts
        $posts_new = get_posts( $args );

foreach ($posts_new as $key => $post){
            $thumbnail = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ) );
            ?>
            <a href="https://stagatv.com/<?php echo $post->post_name;?>" target="_blank">
                <div class="col-md-4" style="margin-top: 8px;">
                    <div class="col-sm-12" style="padding: 0px; margin-bottom: 12px;">
                        <div style="height: 90px; overflow: hidden; padding: 0px; margin-bottom: 10px;">
                            <img class="img-responsive" alt="<?php echo $post->post_title; ?>" style="height: 90px; width: 115px; float: left; margin-right: 10px;" src="<?php echo $thumbnail[0]; ?>">
                            <h3 class="text-danger" style="font-family: 'Alegreya Sans', sans-serif; margin-top: 0px;"><?php echo $post->post_title; ?> <br> <small><p style="margin-top: 8px;"><?php echo date('F j, Y', strtotime($post->post_date));?></p></small></h3>
                        </div>
                        
                        
                    </div>
                </div>
            </a>
            <?php
        }

//        echo "<h1>" . $post->post_title . "</h1><br>";
//        echo "<p>" . $post->post_content . "</p><br>";
//        echo get_the_post_thumbnail( $post->ID );

</div>
</div>
</body>
</html>