Untitled

<?
session_start();
session_register("user");
echo 'tes pertama';
include("connec.php");
echo (" <body background='bg.gif'><html><head>
		<LINK rel='stylesheet' href='style.css' type='text/css'> ");
?>
<body>
<?
echo 'tes kedua';
if ($pilih=="t0") {
	echo "Tentukan <strong>status</strong> anda <br>";
	echo "<font face=verdana>Cek <strong>username</strong> dan <strong>password</strong> anda, silahkan <a href=smansa.php>login</a> kembali</font> ";
    session_destroy();
}
$host="localhost";
$username="abg";
$password="anakgaul";
$databasename="abg_web";

//$host="localhost";
//$username="root";
//$password="";
//$databasename="web";
$link=mysql_connect($host,$username,$password)or die (mysql_error());
mysql_select_db($databasename) or die(mysql_error());
if ($pilih=="login_siswa")
{
	echo 'tes ketiga';

	$sql = "select * from login_siswa WHERE username='{$_POST['user']}' and password='{$_POST['pass']}'";
	$res = mysql_query($sql) or die(mysql_error());
	while ($ro=mysql_fetch_assoc($res) or die(mysql_error()))
	{
		$username=$ro['username'];
	}
		if(mysql_num_rows($res) !== 0)
	    { //dua
				$sqlstr="select siswa.username,siswa.nama,siswa.kelas from siswa,login_siswa where siswa.username=login_siswa.username and login_siswa.username='$username' ";
				$result = mysql_query($sqlstr) or die (mysql_error());
				while ($row=mysql_fetch_assoc($result) or die(mysql_error()))
				{  //tiga
					$username=$row['username'];
					$nama=$row['nama'];
					$kelas=$row['kelas'];

					echo ("<hr>
						<font face=verdana>Selamat Datang, <h1>$nama</h1> </font><br>
						<font face=verdana>Silahkan <a href='login_siswa.php?username=$username'>Masuk</a> sebagai <strong>Siswa Kelas $kelas</strong> SMU NEGERI 1 DEPOK</font>
						<hr>
						");

				} //tiga
		} //dua
			else {
				    echo "Ini Login Untuk <strong>SISWA</strong><br>";
					echo "Tentukan <strong>status</strong> anda <br>";
					echo "<font face=verdana>Cek <strong>username</strong> dan <strong>password</strong> anda, silahkan <a href=smansa.php>login</a> kembali</font> ";
					session_destroy();
		  		}

		/*	if ($user=="" or $pass=="") {
				session_destroy();
				header("location:index.php");
			} else {
			$conn=mysql_connect("localhost","root","");
			mysql_select_db("web");
			$sqlstr="select * from login_siswa where username='{$_POST['user']}' and password='{$_POST['pass']}'";
			$hasil=mysql_query($sqlstr,$conn);
			$row=mysql_fetch_row($hasil);
			if ($row) {
					session_register("user");
					header("location:login_siswa.php?username=$user");

				}
				else
				{
					session_destroy();
					header("location:index.php");
				}
			}*/
}

if ($pilih=="login_wali")
	{
	$link = open_connection();
	$sql = "select * from login_wali WHERE username='{$_POST['user']}' and password='{$_POST['pass']}'";
	$res = mysql_query($sql);
	while ($ro=mysql_fetch_assoc($res))
	{
		$username=$ro['username'];
	}
		if(mysql_num_rows($res) !== 0)
	    { //dua
				$sqlstr="select wali_kelas.username,wali_kelas.nama,wali_kelas.kelas from wali_kelas,login_wali where wali_kelas.username=login_wali.username and login_wali.username='$username' ";
				$result = mysql_query($sqlstr) or die (mysql_error());
				while ($row=mysql_fetch_assoc($result))
				{  //tiga
					$username=$row['username'];
					$nama=$row['nama'];
					$kelas=$row['kelas'];

					echo ("<hr>
						<font face=verdana>Selamat Datang, <h1>Bpk/Ibu $nama</h1> </font><br>
						<font face=verdana>Silahkan <a href='aksi_wali.php?username=$username'>Masuk</a> sebagai <strong>Wali Kelas $kelas</strong> SMU NEGERI 1 DEPOK</font>
						<hr>
						");

				} //tiga
		} //dua
			else {
				    echo "Ini Login Untuk <strong>WALI KELAS</strong><br>";
					echo "Tentukan <strong>status</strong> anda <br>";
					echo "<font face=verdana>Cek <strong>username</strong> dan <strong>password</strong> anda, silahkan <a href=smansa.php>login</a> kembali</font> ";
					session_destroy();
		  		}

	/*	if ($user=="" or $pass=="") {
			session_destroy();
			header("location:index.php");
		} else {
		$conn=mysql_connect("localhost","root","");
		mysql_select_db("web");
		$sqlstr="select * from login_wali where username='{$_POST['user']}' and password='{$_POST['pass']}'";
		$hasil=mysql_query($sqlstr,$conn);
		$row=mysql_fetch_row($hasil);
		if ($row) {
				session_register("user");
				header("location:aksi_wali.php?username=$user");

			}
			else
			{
				session_destroy();
				header("location:index.php");
			}
		}*/

	}


if ($pilih=="login_admin")
	{

    $sql = "select * from login_admin WHERE username='{$_POST['user']}' and password='{$_POST['pass']}'";
	$res = mysql_query($sql);
	if(mysql_num_rows($res) !== 0)
	    {
		$_SESSION['username']=$_POST['user'];
				$sqlstr="select * from login_admin where username='{$_SESSION['username']}'";
				$result = mysql_query($sqlstr) or die (mysql_error());
				while ($row=mysql_fetch_assoc($result))
				{
					$username=$row['username'];
					echo ("<hr>
						<font face=verdana>Selamat Datang, <h1>$username</h1> </font><br>
						<font face=verdana>Silahkan <a href='admin_all.php?username=$username'>Masuk</a> sebagai <strong>Administrator</strong> Web site SMU NEGERI 1 DEPOK</font>
						<hr>
						");
				}
		}
	else {
			echo "Ini Login Untuk <strong>ADMINISTRATOR</strong><br>";
			echo "Tentukan <strong>status</strong> anda <br>";
			echo "<font face=verdana>Cek <strong>username</strong> dan <strong>password</strong> anda, silahkan <a href=smansa.php>login</a> kembali</font> ";
			session_destroy();
		 }


	}


?>
</body>