LatihanSelect.php

<HTML>
<head>
</head>
<body>
	<form action="prosesSelect.php" method="post">
		<table border="1" align="center">
			<tr>
				<td align="center">Silahkan Pilih Berdasarkan Kode Departemen</td>
			</tr>
			<tr>
				<td align="center">
					<select name="selectDep">
						<option value="selected">-Pilih-</option>
							<?php
									$host = "127.0.0.1";
									$user = "jackhack";
									$pass = "dancing01";

									$id_mysql = mysql_connect("$host", "$user", "$pass");
										if(! $id_mysql)
											die("An error occure when try to connect to MYSQL server");//koneksi ke mysql

									$db_personalia = mysql_select_db("Personalia", $id_mysql);
										if(! $db_personalia)
											die("An error occure when try to connect to database personalia");//koneksi ke database personalia

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

									while ($baris = mysql_fetch_row($hasil))
										{
											$Kode_Dep = $baris[0];

												print("<option value=\"$Kode_Dep\"> "." $Kode_Dep</option> \n");
										}
									mysql_close($id_mysql);
							?>
					</select>
				</td>
			</tr>
			<tr>
				<td align="center">
					<input type="submit" name="cari" value="Cari" />
				</td>
			</tr>
		</table>
	</form>
</body>
</html>