apap

<?php
  $servername="localhost";
  $username="root";
  $password="";

  $dbname="tutoriall1";
  $conn = mysqli_connect($servername, $username, $password, $dbname);

  if(!$conn){
    die("Connection failed: " + mysqli_connect_error());
  }

  $noPeserta = $_GET['nomor_peserta'];
  $sql = "SELECT * FROM peserta WHERE nomor='".$noPeserta."';";
  $result = mysqli_query($conn, $sql);

  if ($result->num_rows <= 0){
    echo "Peserta " .$noPeserta. " tidak terdaftar.";
  } else {
    $resultRow = $result->fetch_assoc();
    $nama = $resultRow["nama"];
    $ttl = $resultRow["tgl_lahir"];

    $kelulusan = "SELECT nama_prodi, nama_univ, url_univ FROM result, prodi, univ WHERE result.nomor = '".$noPeserta."' AND result.kode_prodi = prodi.kode_prodi AND result.kode_univ = univ.kode_univ;";

    $resultlulus = mysqli_query($conn, $kelulusan);

    if ($resultlulus->num_rows <= 0){
      echo "Nomor: " .$noPeserta. "<br>";
      echo "Nama: " .$nama. "<br>";
      echo "Tanggal Lahir: " .$ttl. "<br>";
      echo "Maaf, Anda tidak lulus SBMPTN";
    } else {
      $resultlulusRow = $resultlulus->fetch_assoc();
      $urlUniv = $resultlulusRow["url_univ"];
      $univ = $resultlulusRow["nama_univ"];
      $prodi = $resultlulusRow["nama_prodi"];

      echo "Nomor: " .$noPeserta. "<br>";
      echo "Nama: " .$nama. "<br>";
      echo "Tanggal Lahir: " .$ttl. "<br>";
      echo "Selamat! Anda lulus SBMPTN<br>Pada Program Studi ";
      echo $prodi. " <a href='" .$urlUniv. "' target='_blank'>" .$univ. "</a>";
    }
  }
?>