SUCCESSFUL~!!! Alhamdulillah

ruzana · Apr 15, 2011

Alhamdulillah,,
dengan semua bntuan kwn2 CG,sy da berjaye solve problem sy,,
tqvm~!!
even hnye login page,,
tp bg sy y noob sal coding2 ni,sy rse bangge sbb dapt wt,,

^_^

mood : xsaba nk bgtaw bos yg sy da berjaye

ruzana · Apr 15, 2011

##NI FAIL index.php (login form)##

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<?php

// Inialize session
//session_start();

// Check, if user is already login, then jump to secured page
//if (isset($_SESSION['username'])) {
//header('Location: prog/semak.php');
//}

?>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>KELAB 1221</title>
</head>
<body background="img/ABSTRACT-SunergosGreyWallpaper_1600x1200.png">

<p> </p>
<p><br />
</p>
<b><center><font face="Arial, Helvetica, sans-serif" size="7" color="#0006f3">KELAB 1221</font></center></b>
<p> </p>
<p><br />
</p>
<form id="form1" name="form1" method="post" action="prog/semak.php">
<label></label>
<table width="329" border="3" align="center">
<tr>
<td width="115">Username</td>
<td width="8">:</td>
<td width="180"><input name="username" type="text" id="username" size="30" /></td>
</tr>
<tr>
<td>Kata Laluan</td>
<td>:
<label></label></td>
<td><input name="password" type="password" id="password" size="30" /></td>
</tr>
</table>
<p align="center">
<label>
<input type="submit" name="button" id="button" value="Submit" />
</label>
<label>
<input type="reset" name="button2" id="button2" value="Reset" />
</label>
</p>
</form>
<p> </p>
<p align="center"><strong>KELAB 1221</strong></p>
<p align="center"><strong>MAJLIS BANDARAYA SHAH ALAM</strong></p>
</body>
</html>

ruzana · Apr 15, 2011

##NI FAIL semak.php (dye akn semak username n password,,kat sini slhnye,,tp xtw y mne##

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<?php

$mysql_server = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "club_1221";

$conn = mysql_connect($mysql_server, $mysql_user, $mysql_password);

mysql_select_db($mysql_database, $conn);

// username and password sent from form
$myusername=$_POST['username'];
$mypassword=$_POST['password'];

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$result = mysql_query("SELECT * FROM jos_users WHERE username='$myusername' and password='$mypassword'", $conn) or die ('Could not connect');

// If result matched $myusername and $mypassword, table row must be 1 row

if(mysql_num_rows($result) > 0){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_start();
$_SESSION['username'] = $myusername;
$_SESSION['password'] = $mypassword;
header("location:berjaya.php");
}
else {
echo "Username dan Kata Laluan salah";
}
?>

<body>
</body>
</html>

ruzana · Apr 15, 2011

##NI FAIL berjaya.php##

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<?
include("../connect db/connct.php");

//if(!session_is_registered(username)){
//header("location:frameset.php");
//}
//new from me

if(!isset($_SESSION['username'])){
header("location:../../login.php");
}
?>

<html>
<body>
Login Successful
</body>
</html>

<body>
</body>
</html>

azraneus · Apr 15, 2011

ada 2 benda nampak mcm silap:

1. sql select tu....select from table $jos_users...rasanya nama table ni patut xde $

2. $count punya syarat mcm salah....mysql_num_rows ni sebenarnnya mengira ada berapa data dalam row field kita....so bila u buat syarat $count mesti 1, mestila x jumpa, padahal kalo user ada 10, camana? mesti username dan katalaluan salah

Apexi7 · Apr 15, 2011

ni sy x smpi llg thp ni#:-S

ruzana · Apr 15, 2011

azraneus said:
ada 2 benda nampak mcm silap:

1. sql select tu....select from table $jos_users...rasanya nama table ni patut xde $

2. $count punya syarat mcm salah....mysql_num_rows ni sebenarnnya mengira ada berapa data dalam row field kita....so bila u buat syarat $count mesti 1, mestila x jumpa, padahal kalo user ada 10, camana? mesti username dan katalaluan salah

yg 1st 2 sy fhm,,
y 2nd mcm xfhm

ruzana · Apr 15, 2011

yg table $jos_esers,
sy da buang $...
skrg da ok,,
cume klua salh msuk username n password

fnd75 · Apr 15, 2011

azraneus said:
ada 2 benda nampak mcm silap:

1. sql select tu....select from table $jos_users...rasanya nama table ni patut xde $

2. $count punya syarat mcm salah....mysql_num_rows ni sebenarnnya mengira ada berapa data dalam row field kita....so bila u buat syarat $count mesti 1, mestila x jumpa, padahal kalo user ada 10, camana? mesti username dan katalaluan salah

jos_users? bunyi mcm joomla punye mysl table je? :-?:-? ni buat form sendiri ke pakai form generator atau pun copy paste dr mana form?

azraneus · Apr 15, 2011

utk yang ni: $count=mysql_num_rows($result);

kalao dalam db, user kita ada 15 orang,

mesti akan hasilkan $count = 15;

so...bila u buat syarat $count == 1...mesti la xleh login...

so, rasanya u akan jumpa masalah ni bila setel masalah sql error tu...

SUCCESSFUL~!!! Alhamdulillah

ruzana

Active Member

Attachments

ruzana

Active Member

ruzana

Active Member

ruzana

Active Member

azraneus

Active+ Member

Apexi7

Passed Away - Al Fatihah

ruzana

Active Member

ruzana

Active Member

fnd75

Active Member

azraneus

Active+ Member

Forum statistics

Connect with us