<?php
    error_reporting(-1);
    ini_set('display_errors', 'On');
	
	class Catalog
	{
	    private $host="localhost";
		private $dbname="areostar_media";
        private $user_DB="areostar_admin";
        private $password_DB = "Aa1123581321"; 
	
	    private $_type = 0;
	    private $_category = 0;
		private $_search = 0;
		private $_page = 0;
		
		
	    function __construct() 
	    {
	    
		}
		
		public function mainPage()
		{
		    $dbh = new PDO("mysql:host=$this->host;dbname=$this->dbname", $this->user_DB, $this->password_DB);

            $stmt = $dbh->prepare("SELECT * FROM content_table ORDER BY date_create DESC");
			if ($stmt->execute()) {
				while ($row = $stmt->fetch()) {
					echo"<div class='loops-wrapper list-thumb-image'>
						<article class='post'>
							<div class='post-content'>
								<time datetime='".$row['date_create']."' class='ost-date'>".$row['date_create']."</time>
								<p class='post-meta'> 
									<span class='post-author'><a href='#'>".getUserName($row['user_id'])."</a></span>
									<span class='post-category'><a href='#'>General</a></span>
									<span class='post-comment'><a href='#'>0 Comment</a></span>
								</p>
								<p>".$row['content']."</p>
							</div>
							<!-- /.post-content -->
						</article>
					</div>";
				}
            }				
		}
		
		private function getUserName($id)
		{
		    $dbh = new PDO("mysql:host=$this->host;dbname=$this->dbname", $this->user_DB, $this->password_DB);
			
		    $stmt = $dbh->prepare("SELECT nickname FROM users_table WHERE user_id = :id");
			$stmt->bindValue(':id', $id, PDO::PARAM_INT);
			if ($stmt->execute()) {
				while ($row = $stmt->fetch()) {
				    echo $row["nickname"];
				}
            }
		}
..........................................................................