<?php
error_reporting(-1);
ini_set('display_errors', 'On');

$host = 'localhost';
$dbname = 'mebel-baby-ua';
$username = 'mebel-baby-ua';
$password = 'erhdthcbz';
$dsn = sprintf('mysql:host=%s;dbname=%s;charset=utf-8', $host, $dbname);
$db = new PDO($dsn, $username, $password);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

if (!isset($_GET['cat'])) {
    die('Произошла ошибка!');
}
$category = (int)$_GET['cat'];

$sql = "SELECT pro.productID as productID, name, Price as price, url ,filename
        FROM MB_product_related re
        INNER JOIN  MB_products pro ON re.relatedID = pro.productID
        INNER JOIN  MB_category_products cat ON re.relatedID = cat.productID
        LEFT JOIN MB_product_pictures pic ON pic.photoID = default_picture
        WHERE re.productID=:category ORDER BY RAND()";

$statement = $db->prepare($sql);
$statement->execute(array(
    ':category' => $category
));
$rows = $statement->fetchAll(PDO::FETCH_OBJ);
if (!$rows) {
    die('Произошла ошибка!');
}
$defaultImage = 'http://www.mebel-baby.com.ua/products_pictures/mebel_baby_no_img.jpg';
$urlFormat = 'http://www.mebel-baby.com.ua/%s.html';
$imageFormat = 'http://www.mebel-baby.com.ua/products_pictures/%s';
$carouselItems = array();
$itemsPerPage = 3;
$maxColumns = 12;
$group = 0;
$activeGroup = 0;
$colSize = $maxColumns/$itemsPerPage;
foreach ($rows as $number => $row) {
    $url = sprintf($urlFormat, $row->url);
    $image = sprintf($imageFormat, $row->filename);

    if ($number % $itemsPerPage === 0) {
        $group++;
    }
    if (!isset($carouselItems[$group])) {
        $carouselItems[$group] = array();
    }
    $carouselItems[$group][] = array(
        'url' => $url,
        'image' => $image,
        'name' => $row->name,
        'price' => $row->price
    );
}
?>

<div id="carousel" class="carousel slide" data-ride="carousel">
    <div class="carousel-inner" role="listbox">
        <?php foreach ($carouselItems as $currentNumber => $itemGroup) : ?>
            <?php $class = $currentNumber === $activeGroup ? ' active' : ''; ?>
            <div class="item<?= $class ?>">
                <div class="row">
                    <?php foreach ($itemGroup as $item): ?>
                        <div class="col-md-<?= $colSize ?> col-xs-<?= $colSize ?> col-lg-<?= $colSize ?>">
                            <a href="<?= $item['url'] ?>" class="thumbnail">
                                <?= $item['name'] ?> <?= $item['price'] ?>
                                <img src="<?= $item['image'] ?>" alt="<?= $item['name'] ?>">
                            </a>
                        </div>
                    <?php endforeach; ?>
                </div>
            </div>
        <?php endforeach; ?>
    </div>
    <ol class="carousel-indicators">
        <?php foreach ($carouselItems as $currentNumber => $itemGroup) : ?>
            <?php $class = $currentNumber === $activeGroup ? ' class="active"' : ''; ?>
            <li data-target="#carousel" data-slide-to="<?= $currentNumber ?>" <?= $class ?>></li>
        <?php endforeach; ?>
    </ol>
    <a class="left carousel-control" href="#carousel" role="button" data-slide="prev">
        <span class="glyphicon glyphicon-chevron-left" aria-hidden="true"></span>
        <span class="sr-only">Previous</span>
    </a>
    <a class="right carousel-control" href="#carousel" role="button" data-slide="next">
        <span class="glyphicon glyphicon-chevron-right" aria-hidden="true"></span>
        <span class="sr-only">Next</span>
    </a>
</div>