<iframe width="560" height="315" src="//www.youtube.com/embed/Hmlo0Lc2aKU" frameborder="0" allowfullscreen></iframe>
CONNECTION DATABASE
<?php
/*
Database connection file
*/
define ("SVR","localhost");
define("DB","mdsdb");
define("USER","root");
define("PASS","");
mysql_connect (SVR, USER, PASS) or die ("unable to connect to database -->> ".DB);
$result = mysql_select_db(DB);
if(!$result){
die("error: mysql_select_db()");
}
//mysql_close();clossing database connection
error_reporting(0);//to hide from displaying error
?>
LOGIN
<?php
include_once "conndb.php";
if (isset($_POST['Enter'])){
$user = $_POST['Username'];
$pass = $_POST['Password'];
$query_login="select username,password from login where username = '$user' and password = '$pass'";
$result_login=mysql_query($query_login) or die (mysql_error());
while($data_login=mysql_fetch_array($result_login)){
$username=$data_login['0'];
$password=$data_login['1'];
if (($username==$user) and ($password==$pass)){
?>
<script language="javascript">
window.location.href="home.php?user=<?php echo $user;?>";
</script>
<?php
}//if
else
echo "invalid username and password";
}}
?>
BORANG
<?php
include_once 'conndb.php';
//simpan data dalam table login
if (isset($_POST['hantar'])){
$namapenuh=$_POST['namapenuh'];
$namalogin=$_POST['namalogin'];
$katalaluan=$_POST['katalaluan'];
$email=$_POST['email'];
$query_simpan="insert into login (namapenuh,namalogin,katalaluan,email) values ('$namapenuh','$namalogin','$katalaluan','$email')";
$result_simpan=mysql_query($query_simpan)or die(mysql_error());
?>
<script language="javascript">
alert("Data anda telah disimpan,terima kasih");
window.location.href="index.php";
</script>
<?php
}
mysql_close();
?>
DISPLAY DATA
<?php
if(isset($_POST['cari'])){
//display all the info
include_once 'conndb.php';
$nama=$_POST['nama'];
$query_display="select * from aduan where nama like '$nama%'";
$result_display=mysql_query ($query_display);
while ($data_display=mysql_fetch_array ($result_display)){
?>
<p>
Nama:<?php echo $data_display['nama'];?>
</p>
<p>
Jenis Aduan :<?php echo $data_display['jenis'];?>
</p>
<p>
Aduan :<?php echo $data_display['aduan'];?>
<br />
<br />
Cadangan:<?php echo $data_display['cadangan'];?>
</p>
<br />
<br />
<br />
</p>
<?php
}
}
//if
else
echo "Haraf Maaf, Data Tiada";
?>
DISPLAY NAMA
<?php
$pengunjung=$_GET['namalogin'];
?>
dan
<div><marquee>Selamat Datang <?php echo $pengunjung;?>,Terima Kasih Kerana Mengunjungi Laman Web Ini.</marquee></div>
