$connection = mysql_connect('localhost', 'refincz', 'XWdjDv7X94S5BjGF');
mysql_select_db('refincz_donator');
mysql_query('SET CHARACTER SET utf8');
// Načtení dat
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `darci`'), 0, 0);
$offset = isset($_GET['offset']) ? intval($_GET['offset']) : $count;
$offset = $offset < 1 ? 1 : ($offset > $count ? $count : $offset);
$itemsCount = 4;
$queryOffset = $count - $offset;
$result = mysql_query('SELECT * FROM `darci` ORDER BY `datum` DESC, `id` DESC LIMIT ' . $itemsCount . ' OFFSET ' . $queryOffset);
// Obsah webu
// ----------
while ($item = mysql_fetch_object($result)) {
echo '
' . PHP_EOL;
// Logo
// ----
$logo = $item->logo;
if (mb_strlen($logo) == 0) { // Zobrazit prázdné logo
$logo = 'no-logo.png';
}
echo '

' . PHP_EOL;
// Text
// ----
echo '
' . $item->nazev_spolecnosti . ' - ' . number_format($item->castka, 0, ',', ' ') . ' Kč
' . PHP_EOL;
echo '
' . $item->popis . '
' . PHP_EOL;
echo '
' . PHP_EOL;
echo '
' . PHP_EOL;
}
?>