admin_userSelect.php

<?php

include 'bbdd_db_conn.php';

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
session_start();

$adminCast = "admin";
$editorCast = "editor";
$authorCast = "author";

$uname = $_SESSION['username'];

// $sql = "SELECT * FROM user_data ORDER BY id DESC";


$URL = "./admin_index.php";
if(!isset($_SESSION['username'])) {
    ?>              <script>
                            // alert("권한이 없습니다.");
                            location.replace("<?php echo $URL?>");
                    </script>
    <?php   }
            //cast: admin인 경우
            else if($_SESSION['cast']==$adminCast) {

                $sql = "SELECT * FROM user_data ORDER BY id DESC";
                
            } else if ($_SESSION['cast']==$editorCast) {
                
                $sql = "SELECT * FROM user_data WHERE `cast` != '$adminCast' ORDER BY id DESC";
                
            } else if ($_SESSION['cast']!==$adminCast && $_SESSION['cast']!==$editorCast) {
                
                $sql = "SELECT * FROM user_data WHERE username = '$uname' ORDER BY id DESC";

            }










$result = $conn->query($sql) or die($conn->error);


echo "<tr>
<th onclick='sortTable(0)'>번호</th>
<th onclick='sortTable(1)'>아이디</th> 
<th onclick='sortTable(2)'>이메일</th> 
<th onclick='sortTable(3)'>필명</th>
<th onclick='sortTable(4)'>이름</th>
       
<th onclick='sortTable(5)'>등급</th>           
<th >관리</th>        
</tr>";


if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
                        
        // echo "<li id='{$row["id"]}' onclick = 'showClickedObject(this.id)'>"/*."<a href='VisitContentClick()'>"*/.
        
        // "<h3>{$row['title']}</h3>".
        // "<img src='{$row['img0_dir']}' width='210px' heigit='70px'>".
        // "  ".
        // $row["username"].
        // "  ".
        // $row["created"].
        // "</a>".
        // "</li>";
        // <td class='{$row["id"]}'><img src='{$row['img_dir']}' width='90px' heigit='60px'></td>
echo
        "<tr id='{$row["id"]}' >
            <td class='{$row["id"]}'>{$row['id']}</td>    
            <td class='{$row["id"]}'>{$row['username']}</td>
            <td class='{$row["id"]}'>{$row['email']}</td>
            <td class='{$row["id"]}'>{$row['author']}</td>
            <td class='{$row["id"]}'>{$row['realname']}</td>
            <td class='{$row["id"]}'>{$row['cast']}</td>
            <td class='{$row["id"]}'><button class='view_btn1' name='{$row["id"]}' onclick='userModi(this.name)'>수정</button>";
echo " | ";
echo             "<button class='view_btn1' name='{$row["id"]}' onclick='userDel(this.name)'>삭제</button></td>
        </tr>";
        
    }
} else {
    echo "0 results";
}
$conn->close();
?>
<!-- <script src="imgList.js"></script> -->
<!-- <script src="sortTable.js"></script> -->
<!-- <td id='{$row["id"]}' class='{$row["id"]}' onclick = 'imgList(this.id)'>{$row['title']}</td> -->