doongdoong/admin_checkAuthCatRem.php at master · fatihohn/doongdoong · 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
69
70
71
72
73
74
75
<?php
	include "bbdd_db_conn.php";
	$authCat = $_GET["q"];
	$authCatId = $_GET["r"];

	$contSql = "SELECT * FROM contents WHERE id = '$authCatId'";
	$resultCont = $conn->query($contSql);
	$rowCont = $resultCont->fetch_assoc();
	$SessFrId = $rowCont['sess'];

	// echo $authCat;
	$sessOnSql = "SELECT * FROM contents WHERE `category` = '$authCat' AND `display`='on' ORDER BY `sess` DESC LIMIT 1 ";
	$resultSessOn = $conn->query($sessOnSql);
	$rowSessOn = $resultSessOn->fetch_assoc();
	$sessOnLatest = intval($rowSessOn['sess']);


	$sessSql = "SELECT * FROM contents WHERE `category` = '$authCat' AND `display`='on' OR `display`='ok' ORDER BY `sess` DESC LIMIT 1 ";
	$resultSess = $conn->query($sessSql);
	$rowSess = $resultSess->fetch_assoc();
	$sess = intval($rowSess['sess']);
	$sessOkLatest = intval($rowSess['sess']);

	// echo "
	// <label class='createGrid1'>

	// 회차
	// </label>";

	echo '<select class="createGrid2" name="sess" id="sessCat" required>';
	if($sess-1 < 0) {
		echo "
		<option class='sess_slct' value='1'>1회</option>
		<option class='sess_slct' value='2'>2회</option>
		<option class='sess_slct' value='3'>3회</option>
		<option class='sess_slct' value='4'>4회</option>
		<option class='sess_slct' value='5'>5회</option>
		<option class='sess_slct' value='6'>6회</option>
		<option class='sess_slct' value='7'>7회</option>
		<option class='sess_slct' value='8'>8회</option>
		<option class='sess_slct' value='9'>9회</option>
		<option class='sess_slct' value='10'>10회</option>
		";

	} else {

		$sessNum = 1;
		while($sess+10 >= 0) {
			echo "<option class='sess_slct' value='";
			echo $sessNum;
			echo "'";

			if($sessNum == $SessFrId) {
				echo "selected";
			}

			echo ">";
			echo $sessNum;
			echo "회</option>";
			$sess = $sess-1;
			$sessNum++;

		}


	}
	echo "</select>";
	echo " 최신 발행 회차 ";
	echo $sessOnLatest;
	echo "회 | ";
	echo " 최신 내부공개 회차 ";
	echo $sessOkLatest;
	echo "회";

	?>