数据库不显示使用GET方法

Question

I need help.i have this database

student_code: 1234

student_id: angel

namaFoto: angel.jpg

using GET method to call specific data from database, i use this code below, but the data doesn't show up. what did i do wrong?

<?php
include_once "library/inc.sesadmin.php";
$row    = 25;
$hal    = isset($_GET['hal']) ? $_GET['hal'] : 1;

if($usertype != 'Admission'||$usertype != 'Administrator'){
    
if($_GET) {
    $Kode   = $_GET['Kode'];
    $myQry=$db->prepare("SELECT * FROM student WHERE student_code='$Kode'");
    $myQry->execute();
    $myQryCount = $myQry->rowCount();

    while ($myData = $myQry->fetch()) {
    }
}

?>
<table >
        <tr>
      <td ><img src="foto/<?php echo $namaFoto; ?>"></td>
      <td ><b>Code</b></td>
      <td ><b>:</b></td>
      <td ><?php echo $myData['student_code']; ?></td>
    </tr>
    <tr>
      <td><b>Student ID </b></td>
      <td><b>:</b></td>
      <td> <?php echo $myData['student_id']; ?>  </td>
    </tr>
</table>
      <?php } else { ?>
      <br /> <br /> <br /> <br /> <br /> <br />
      <p align="center">You are not authorized to access this area</p>
      <?php } ?>

</div>

Answer 1

Are you including ?Kode=1234 on the URL you are using to access the page? Also the image isn't using the same $myData collection to retrieve the image value. That may not be a root-cause issue, but does look to be a big.