<?php

$db_host = 'localhost';
$db_port = 3306;

$db_name = 'agenstvo';
$db_user = 'admin';
$db_password = 'admin';
//$db_tableprefix = 'towny';

$charset = 'utf8';
$dsn = "mysql:host=$db_host;dbname=$db_name;charset=$charset";
$opt = array(
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
);
$pdo = new PDO($dsn, $db_user, $db_password, $opt);
$stmt = $dpo->query('SELECT * FROM spr_vid_obr');
while ($row = $stmt->fetch)
{
    echo $row['vid_obr'];
}
?>