Web-Programming/buy.php at master · tnwjd4623/Web-Programming · 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
60
61
62
63
64
65
66
67
68
<!DOCTYPE html>
<html>
<head>
	<meta charset='utf-8'>
	<link rel="stylesheet" type="text/css" href="board.css">
	<script src="search.js"></script>
</head>
<body>
	<?php
		$connect = mysqli_connect('localhost', 'tnwjd4623', '1q2w3e4r', 'tnwjd4623') or die ('connect fail');

		$query = "select * from board_buy order by number desc";
		$result = $connect->query($query);
		$total = mysqli_num_rows($result);
		session_start();
	?>
	<header>
	<p class="header">책 구매 게시판</p>
	</header>
	<table align = center>
	<thead>
		<tr>
		<td width="50">번호</td>
		<td width="500">제목</td>
		<td width="100">작성자</td>
		<td width="200">날짜</td>
		<td width="50">조회수</td>
		</tr>
	</thead>

	<tbody>
	<?php
		while($rows = mysqli_fetch_assoc($result)) {
			if($total%2==0) {
	?>			<tr class="even">
	<?php		}
			else {
	?>			<tr>
	<?php		}
	?>


		<td width="50"><?php echo $total?></td>
		<td width="500"><a href="./view.php?type=1&number=<?php echo $rows['number'];?>"><?php echo $rows['title']?></a></td>
		<td width="100"><?php echo $rows['id']?></td>
		<td width="200"><?php echo $rows['date']?></td>
		<td width="50"><?php echo $rows['hit']?></td>
		</tr>
	<?php
		$total--;
		}
	?>
	</tbody>
	</table>
	<div class="write">
		<div class="box">
		<span class="text" onClick="location.href='./search_book.php'">책 구매하기</a></span>
		</div>
		<div class="box">
		<span class="text" onClick="location.href='./main.php'">메인으로</a></span>
		</div>

		<div class="box">
		<span class="text" onClick="location.href='./search_board.php'">글 검색</span>
		</div>
	</div>
</body>
</html>