ProsesSelect.php

<?php
	//if (!@$_POST["cari"] == "cari")
	if (!@$_POST["cari"] == "cari")
		{

			$host = "127.0.0.1";
			$user = "jackhack";
			$pass = "dancing01";

			$id_mysql = mysql_connect("$host","$user","$pass");
			if(! $id_mysql)
				die("Connection to server is failed");

			$db_personalia = mysql_select_db("personalia", $id_mysql);
			if(! $db_personalia)
				die("Connection to database is failed");

			$nomor = 0;
			print("<table align=\"center\" border=\"1\">");
			print("<tr>");
			print("<td align=\"center\">No</td>");
			print("<td align=\"center\">NIP</td>");
			print("<td align=\"center\">Nama</td>");
			print("<td align=\"center\">Kode Departemen</td>");
			print("<td align=\"center\">Tanggal Lahir</td>");
			print("<td align=\"center\">Jumlah Anak</td>");
			print("</tr>");

			$sql = 	"select K.NIP, K.Nama, K.Tanggal_lahir" .
					"from karyawan AS K, departemen AS D" .
					"where K.Kode_Dep = D.Kode_Dep";

			$hasil = mysql_query($sql, $id_mysql);
			if(! $hasil)
				die("An error occure in SQL query");

			while($baris = mysql_fetch_row($hasil))
			{
				$nomor ++;

				$NIP = $baris[0];
				$Nama = $baris[1];
				$Kode_Dep = $baris[3];
				$Tanggal_Lahir = $baris[4];
				$Jumlah_Anak = $baris[5];

				print("<tr>");
				print("<td align=\"center\">$NIP</td>");
				print("<td align=\"center\">$Nama</td>");
				print("<td align=\"center\">$Kode_Dep</td>");
				print("<td align=\"center\">$Tanggal_Lahir</td>");
				print("<td align=\"center\">$Jumlah_Anak</td>");
			}
				print("</table>");
		}
?>