tutorialapap1

<?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);
	$flag = false;

	while($row = mysqli_fetch_row($result)){

		$flag = true;
		$nomor = $row[0];
		$nama = $row[1];
		$ttl = $row[2];
	}
	if($flag === false){
		echo "Peserta " .$noPeserta. " tidak terdaftar.";
	}else{
		$flag2 = false;
		$kelulusan = "SELECT nama_prodi, nama_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);


		while($rowlulus = mysqli_fetch_row($resultlulus)){
			$flag2 = true;
			$univ = $rowlulus[1];
			$prodi = $rowlulus[0];
			break;
		}
		if($flag2 === false){
			echo "Nomor: " .$nomor. "<br>";
			echo "Nama: " .$nama. "<br>";
			echo "Tanggal Lahir: " .$ttl. "<br>";
			echo "Maaf, Anda tidak lulus SBMPTN";
		}else {
			echo "Nomor: " .$nomor. "<br>";
			echo "Nama: " .$nama. "<br>";
			echo "Tanggal Lahir: " .$ttl. "<br>";
			echo "Selamat! Anda lulus SBMPTN<br>Pada Program Studi ";
			echo $prodi. " " .$univ;
		}
	}
?>