Untitled

<?php
require 'db.php';
require 'user_required.php';

$ids = $_SESSION['cart'];
if (is_array($ids) && count($ids)>0) {

	$question_marks = str_repeat('?,', count($ids) - 1) . '?';

	$stmt = $db->prepare("SELECT * FROM products WHERE id IN ($question_marks) ORDER BY product_name");

	$stmt->execute(array_values($ids));
	$products = $stmt->fetchAll();


	$stmt_sum = $db->prepare("SELECT SUM(price) FROM products WHERE id IN ($question_marks)");
	$stmt_sum->execute(array_values($ids));
	$sum = $stmt_sum->fetchColumn();

}
?>


<!DOCTYPE html>

<html>

<head>
	<meta charset="utf-8" />
	<title>Můj eshop</title>

	<link rel="stylesheet" type="text/css" href="styly.css">

</head>

<body>

<!DOCTYPE html>
<html lang='cs'>

<head>
	<title>Hlavní strana</title>
  <meta charset='utf-8'>
   <link rel="stylesheet" href="styly.css" media="screen">
  <link rel="stylesheet" href="print.css" media="print">
    <meta name='description' content='Nacházíte se na informační stránce o Michalu Skramuském'>
    <meta name='keywords' content='vizitka, Michal, Skramusky, hobby, filmy, serialy, hry'>
    <meta name='author' content='Michal Skramusky'>
    <meta name='robots' content='all'>
</head>

<body class="background">
  <div class="popredi">

<div id="header">
<h1><a href="index.html">Michal Skramuský</a></h1>
</div>

<ul id="menu">
			<li><a href="omne.html">O mně</a></li>
			<li><a href="filmy.html">Filmy</a></li>
			<li><a href="serialy.html">Seriály</a></li>
			<li><a href="hry.html">Hry</a>
      <ul>
			<li><a href="heavyrain.html">Heavy_Rain</a></li>
			<li><a href="fable.html">Fable</a></li>

		</ul>
    </li>
      <li><a href="knihy.html">Knihy</a>
      <ul>
			<li><a href="coctu.html">Co čtu</a></li>
			<li><a href="zdroj.html">Zdroj</a></li>

		</ul>
       </li>
			<li><a href="eshop.php">Eshop</a></li>
		</ul>


	<div class="content">
	<?php include 'navbar.php' ?>

	<h1>Můj košík</h1>

	Celkově vybráno produktů: <?php count($products) ?>

	<br/><br/>

 <a href="eshop.php">Zpátky k výpisu produktů</a>

	<br/><br/>

	<?php if($products) { ?>


		<table border="2">

			<tr>

				<th></th>
				<th>Název</th>
				<th>Cena</th>
				<th>Popis</th>

			</tr>

			<tfoot>

				<tr>

					<th>Součet</th>
					<th></th>
					<th class="right"><?= $sum ?></th>
					<th></th>

				</tr>
			</tfoot>


			<?php foreach($products as $row) { ?>

				<tr>
					<td class="center">
						<a href='remove.php?id=<?= $row['id'] ?>'>Odstranit</a>
					</td>

					<td><?= $row['product_name'] ?></td>
					<td class="right"><?= $row['price'] ?></td>
					<td><?= $row['product_desc'] ?></td>

				</tr>

				<?php } ?>

			</table>


<?php } else { ?>
				Žádné zboží
				<?php } ?>
		</div>

<div id="footer">
Copyright © Michal Skramuský
</div>
</div>
</body>

</html>