Faizura Fadzil
Freshie
- Messages
- 7
- Joined
- Mar 9, 2011
- Messages
- 7
- Reaction score
- 0
- Points
- 3
salam warga warga CG .. 
saya nak buat satu sistem ni . saya dah buat interface untuk page login , coding untuk check login dan coding logout . bila saya dah login , nanti ada keluar undifine index
assword in checklogin line 20 . jadi , saya tidak tahu apa kesalahannya . database name dan table name saya sudah letakkan dengan betul .
* coding interface login page . saya save satu.php
<form name="input" action="check_login.php" method="post">
<b><center><font size="4">USERNAME : <input type="text" name="username" maxlength="150" /></font></center></b>
<br />
<b><center><font size="4">PASSWORD : <input type="text" name="username" maxlength="50" /></font></center></b>
<br/>
<b><center><font size="4">DEPARTMENT :
<select department="department" size="1">
<option selected>AGRO
<option>HR ADMIN
<option>O&F
<option>TTAS
<option>IT
<option>PNE
<option>Plant Lab
<option>WWW Lab
<option>Palm Product Lab
<option>Oil&Fats Lab
<option>FoodSc/OleoCham Lab
<option>Pest-microb lab
<option>Soil&Fert Lab
<option>SMR&Latex
<option>PAM
<option>Sel Zone
</select></font></center></b>
<br />
<br />
<center><input type="submit" value="LOG IN" />
<input type="reset" value="RESET" /></center>
</form>
<br />
<br />
<center>IT Department © 2011</center>
<center>SIME DARBY RESEARCH SDN.BHD</center>
<b><center>Privacy Policy</center>
<body>
</body>
</html>
* coding checklogin . saya save as check_login.php
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="faizura"; // Database name
$tbl_name="zura"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// username and password sent from form
$username=$_POST['username'];
$password=$_POST['password'];
// To protect MySQL injection (more detail about MySQL injection)
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);
$sql="SELECT * FROM login WHERE username='$username' and password='$password'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("username");
session_register("password");
header("location:menu.php");
}
else {
?>
<script language="JavaScript">
alert(" so sorry sorry morry!!!");
history.go(-1);
</script>
<?php
* coding logout . saya save as logins.php
<?php
error_reporting(0);
session_start();
if(session_is_registered('id')) {
session_unset();
session_destroy();
header( "Location: satu.php" );
}
else{
//the session variable isn't registered, the user shouldn't even be on this page
header( "Location: satu.php" );
}
?>
: harap kawan kawan dapat membantu .
saya nak buat satu sistem ni . saya dah buat interface untuk page login , coding untuk check login dan coding logout . bila saya dah login , nanti ada keluar undifine index
assword in checklogin line 20 . jadi , saya tidak tahu apa kesalahannya . database name dan table name saya sudah letakkan dengan betul . * coding interface login page . saya save satu.php
<form name="input" action="check_login.php" method="post">
<b><center><font size="4">USERNAME : <input type="text" name="username" maxlength="150" /></font></center></b>
<br />
<b><center><font size="4">PASSWORD : <input type="text" name="username" maxlength="50" /></font></center></b>
<br/>
<b><center><font size="4">DEPARTMENT :
<select department="department" size="1">
<option selected>AGRO
<option>HR ADMIN
<option>O&F
<option>TTAS
<option>IT
<option>PNE
<option>Plant Lab
<option>WWW Lab
<option>Palm Product Lab
<option>Oil&Fats Lab
<option>FoodSc/OleoCham Lab
<option>Pest-microb lab
<option>Soil&Fert Lab
<option>SMR&Latex
<option>PAM
<option>Sel Zone
</select></font></center></b>
<br />
<br />
<center><input type="submit" value="LOG IN" />
<input type="reset" value="RESET" /></center>
</form>
<br />
<br />
<center>IT Department © 2011</center>
<center>SIME DARBY RESEARCH SDN.BHD</center>
<b><center>Privacy Policy</center>
<body>
</body>
</html>
* coding checklogin . saya save as check_login.php
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="faizura"; // Database name
$tbl_name="zura"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// username and password sent from form
$username=$_POST['username'];
$password=$_POST['password'];
// To protect MySQL injection (more detail about MySQL injection)
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);
$sql="SELECT * FROM login WHERE username='$username' and password='$password'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("username");
session_register("password");
header("location:menu.php");
}
else {
?>
<script language="JavaScript">
alert(" so sorry sorry morry!!!");
history.go(-1);
</script>
<?php
* coding logout . saya save as logins.php
<?php
error_reporting(0);
session_start();
if(session_is_registered('id')) {
session_unset();
session_destroy();
header( "Location: satu.php" );
}
else{
//the session variable isn't registered, the user shouldn't even be on this page
header( "Location: satu.php" );
}
?>
: harap kawan kawan dapat membantu .
