<?php
//include ("includes/security.php");
include ("includes/database.php");
include ("includes/setting.php");

?>




<!DOCTYPE html>
<html>
<head>
	<title></title>
	<link rel="stylesheet" type="text/css" href="style3.css">


</head>
<body>

	<div id="nav1">
	<h1><a href="index.php">TakeAction!</a></h1>
	<ul>
		<li><a href="admin.php"> Admin </a></li>
		<li><a href="admindelete.php"> Delete</a></li>
		<li><a href="index.php"> Logout</a></li>
	</ul>
</div>

<div >
<br><br><h1 align="center"> HELLO ADMIN OF TAKE ACTION PORTAL </h1>
</div>

<div class="greet">
<br><br><br><p>Where community can share what happen around them.</p>
</div>


<?php
			$dataSubjects=mysqli_query($newcon,"SELECT * from tbl_complaint");
            $bil_subjects=mysqli_num_rows($dataSubjects);

    
while ($showSubjects=mysqli_fetch_array($dataSubjects))
{

?>   
	
 
   <div class="col-sm-10">
   <br><br>
   
    <table width="517" border="1" align="left" class="dashboardcomplaintview">
      <tbody>
      
      <tr align="center" bgcolor="#D0F13A">
		<td class="viewcol">ID</td>
		<td class="viewco2">Complaint Picture</td>
		<td>Complaint Subject</td>
		<td>Complaint Location</td>
		<td>Complaint Explanation</td>
		<td>Action</td>
		
	</tr>
    
        <tr>
        <td align="left" bgcolor="#6CA2F4" class="viewcol"><?php echo $showSubjects['complaint_id'];?>&nbsp;</td>
         <td class="viewcolpic"><a target="_blank" href="product\pta.jpg"><img src="product/<?php echo $showSubjects['complaint_pic'];?>" width="64" width="64"></a></td></td>
         <td align="left" bgcolor="#6CA2F4" class="viewcol1"><?php echo $showSubjects['complaint_subject'];?>&nbsp;</td>
          <td align="left" bgcolor="#C8C8C8" class="viewcol2"><?php echo $showSubjects['complaint_location'];?>&nbsp;</td>
         <td align="left" bgcolor="#C8C8C8" class="viewcol3"><?php echo $showSubjects['complaint_explain'];?>&nbsp;</td>
         
         <td align="left" bgcolor="#C8C8C8" class="viewcol4">
         <?php echo"<a href='admindelete.php?del=$showSubjects[complaint_id]'>Delete</a>";?>
		</td>

        </tr>
        </tbody>
    </table>
    </div>
                   
     <?php
}

?>
                                       
</tbody>              







</body>
</html>