WebSystem/index.php at master · B7-OBookStore/WebSystem · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
<?php
	$dsn = 'mysql:dbname=b7_obookstore;host=ja-cdbr-azure-east-a.cloudapp.net;charset=utf8';
	$username = 'b62d87cb5623a5';
	$password = '6d93d6d8';
	$pdo = new PDO($dsn, $username, $password);
?>

<!DOCTYPE html>
<html>

	<head>
		<meta charset="UTF-8">
		<meta name="viewport" content="width=device-width,initial-scale=1">
		<link rel="stylesheet" href="css/index.css">
		<link rel="icon" href="img/favicon.ico">
		<title>O書店</title>
	</head>

	<body>
		<header>
			<span>Web注文機能を使うためには、ログインしてください</span>
			<a id="login" href="">ログイン</a>
		</header>

		<div id="main">
			<div>
				<h1>O書店</h1>
				<p>お客様は王様であり、私たちは本の王様である。</p>

				<form id="search" method="get" action="search.php">
					<input name="q" type="search" placeholder="書籍を検索">
					<input type="submit" value="">
				</form>
			</div>
		</div>

		<footer>
			<section id="pickedbooks">
				<?php
					$stmt = $pdo->query("SELECT book.JANCode,GoogleID,ProductName,SUM(Num) AS NumSum FROM book,product,stock WHERE book.JANCode = product.JANCode AND book.JANCode = stock.JANCode AND GoogleID IS NOT NULL GROUP BY book.JANCode ORDER BY NumSum DESC LIMIT 40");

					foreach ($stmt as $row) {
						echo "<a class='book' href='book.php?id=$row[GoogleID]'>";
						echo "<img alt='$row[ProductName]' src='http://books.google.com/books/content?id=$row[GoogleID]&printsec=frontcover&img=1&zoom=5&source=gbs_api'>";
						echo "<p>$row[ProductName]</p>";
						echo "</a>";
					}
				?>
			</section>

			<nav>
				<a href="">規約</a>
				<a href="">プライバシー</a>
				<a href="">店舗</a>
			</nav>
		</footer>
	</body>

</html>