Forum PHP.pl

<?php
include('mysql_login.php');
$s = (int)$_GET['kat'];

$query = '';

switch ($s) {
    case 1:
        $query = 'SELECT * FROM foto WHERE kat=1 ORDER BY poz ASC';
        break;
    case 2:
        $query = 'SELECT * FROM foto WHERE kat=2 ORDER BY poz ASC';
        break;
    case 3:
        $query = 'SELECT * FROM foto WHERE kat=3 ORDER BY poz ASC';
        break;
    default:
        $query = 'SELECT * FROM foto ORDER BY kat, poz ASC';
}

try {    
    $pdo = new PDO(HOST, USER, PASS, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
    $pdo -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $pdo -> query($query);
    $details = $stmt -> rowCount();
    if($details == 0) {
        echo '<p>Brak zdjęć w galerii</p>';
    }
    else {
        echo '<div id="gallery_container">';
        foreach($stmt as $row)
        {
            echo "\r\n\t\t\t" . '<div style="float: left"><a href="imgs/foto/max/' . $row['max'] . '" title="' . $row['tytul'] . '"><img src="imgs/foto/min/' . $row['min'] . '" alt="' . $row['tytul'] . '" /></a><p class="nazwa_foto">' . $row['tytul'] .'</p></div>';
        }
        $stmt -> closeCursor();
        echo "\r\n\t\t" . '</div>' . "\r\n";
    }
} catch(PDOException $e)
{
    echo 'Połączenie nie mogło zostać utworzone: ' . $e->getMessage();
}
?>