<?php
//include "header.php";
$key = $_GET['id'];
	$SQL1 = $mysqli->query("SELECT * FROM grand where stucode='$key' ");
?>
<?php
$sql= $mysqli->query("SELECT * FROM student where code='$key' ");
$Row = mysqli_fetch_array($sql);
?>
       <section class="content-header">
      <h1>
        <?=$Row['prefix'];?><?=$Row['name'];?>  <?=$Row['sname'];?>
        <small></small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="index.php?dash=<?=md5("4");?>"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
      </ol>
    </section> 	
  <section class="content">
           <div class="box">

            <div class="box-header">
              <h3 class="box-title">ข้อมูลผู้ปกครอง </h3>
            </div>
            <!-- /.box-header -->
            <div class="box-body">
              <table id="example1" class="table table-bordered table-striped table-hover">
                <thead>
                <tr>
									<td width="30"><a href="index.php?dash=<?=md5("8");?>&id=<?=$key;?>&op=mstudent&m=2"><button type="button" class="btn btn-success btn-xs"><span class="glyphicon glyphicon-plus"></span> เพิ่ม</button></a></td> 
                                    <td>ชื่อ-นามสกุล</td>
									<td width="50">สถานะ</td>
									<td width="130">เลขบัตรประชาชน</td>
									<td width="80">โทรศัพท์1</td>	
									<td width="80">โทรศัพท์2</td>
									<td width="70">รูปภาพ</td>										
                                    <td width="100">จัดการ</td>  
                </tr>
                </thead>
                <tbody>
         <?php 
			$i=0;
			while($Row=mysqli_fetch_array($SQL1)) { 
			$i++
         ?>				
                <tr>
									<td align="center"><?=$i;?></td> 
                                    <td><?=$Row["tprefix"];?><?=$Row["tname"];?>  <?=$Row["tsname"];?></td>
									<td><?=$Row["tstatus"];?></td>
									<td><?=$Row["idcard"];?></td>
									<td><?=$Row["ttel1"];?></td>
									<td><?=$Row["ttel2"];?></td>
									<td align="center">
<?php if($Row["tpic"]==""){echo "-";}else { ?>
										<button type="button" class="btn btn-default btn-xs" data-toggle = "modal" data-target="#pic<?=$Row["tid"];?>">
										<span class='glyphicon glyphicon-picture'></span> Picture</button>
<?php } ?>
<!-- Modal -->
  <div class="modal fade" id="pic<?=$Row['tid'];?>" role="dialog">
    <div class="modal-dialog">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">รูปผู้ปกครอง</h4>
        </div>
        <div class="modal-body">
          <p><center><img src="../photo/grand/<?=$Row["tpic"];?>" class="img-thumbnail" alt="<?=$Row["tid"];?>" width="300" height="320"><br>
		  <h4><?=$Row["tprefix"];?><?=$Row["tname"];?>   <?=$Row["tsname"];?></h4>
		  </center></p>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">ปิด</button>
        </div>
      </div>      
    </div>
  </div>									
									</td>
                                <td align="center">
<a href="index.php?dash=<?=md5("9");?>&id=<?=$Row['tid'];?>&stucode=<?=$Row["stucode"];?>&op=mstudent&m=2">								
<button type="button" class="btn btn-info btn-xs"><span class="glyphicon glyphicon-edit"></span> แก้ไข</button></a>&nbsp;&nbsp;	
								
<a href="#<?=$Row['tid'];?>" type="input" class="btn btn-danger btn-xs glyphicon glyphicon-trash del-co"  data-toggle="modal"  data-toggle="tooltip" title="ลบข้อมูล"></a>
<!-- Modal -->
  <div class="modal fade" id="<?=$Row['tid'];?>" role="dialog">
    <div class="modal-dialog">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">ลบข้อมูล</h4>
        </div>
        <div class="modal-body">
          <p><center>คุณต้องการลบข้อมูล <?=$Row["tprefix"];?><?=$Row["tname"];?>  <?=$Row["tsname"];?> จากระบบหรือไม่?</center><br></p>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">ยกเลิก</button>
		  <a href="del.php?id=<?=$Row['tid'];?>&action=delgrand&code=<?=$Row['stucode'];?>&op=mstudent&m=2" class="btn btn-danger" role="button">ลบข้อมูล</a>
        </div>
      </div>      
    </div>
  </div>
  
									</td>   
                </tr>
				<?php } ?>  
				</tbody>
              </table>
            </div>
            <!-- /.box-body -->
          </div>			

   </section>