<?php


class Database
{
    private static $_instance;

    public static function getInstance()
    {
        if ( ! ( self::$_instance instanceof DB ) ) {
            self::$_instance = new DB();
            self::$_instance->connect();
        }
        return self::$_instance;
    }

    private function __clone(){}
    private function __construct(){}
    private function __wakeup(){}
}


class DB
{
    const USER = 'root';
    const PASS = '';
    const DATABASE = 'colina';
    const SERVER = 'localhost';

    private $_conection;

    public function connect()
    {
        $this->_conection = mysql_connect(
            self::SERVER,
            self::USER,
            self::PASS
        );

        mysql_select_db(
            self::DATABASE,
            $this->_conection
        );
    }

    public function disconnect()
    {
        mysql_close($this->_conection);
    }

    public function execute($sql)
    {
        return mysql_query($sql, $this->_conection);
    }

    public function getArray($sql)
    {
        $rs = $this->execute(sql);
        if($rs && mysql_num_rows($rs) > 0){
            while ($row = mysql_fetch_assoc($rs)){
                $ret[] = $row;
            }
            return $ret;
        }
        return null;
    }
}

class CommentsManager
{
    public static function getComments()
    {
        $db = Database::getInstance();
        $comments = $db->getArray("SELECT nombre_visita,fecha_visita,comentario_visita FROM 'visitas'");
        if( $comments ){
            return $comments;
        }
        return null;
    }

    public static function buildComments()
    {
        $t = Template::getInstance();

        $t->set_block( '_COMENTARIOS', '_BLK_COMMENTS','TPL_COMMENTS_ITEMS' );
        $comments = self::getComments();
        if($comments){
            foreach (comments as $item) {
                $t->set_var("TPL_COMMENT_NAME", $item['nombre_visita']);
                $t->set_var("TPL_COMMENT_DATE", $item['fecha_visita']);
                $t->set_var("TPL_COMMENT_BODY", $item['comentario_visita']);
                $t->parse( 'TPL_COMMENTS_ITEMS', '_BLK_COMMENTS', 1) ;
            }
        }

        $t->parse('TPL_COMMENTS','_COMENTARIOS');
    }
}