problem with php

[ruzana]

Filename apa? kalau laluan betol, pegi ke page pentadbir.php, kalau laluan salah, pegi ke page yg salah.

proses kau ni xde leveling. jap aku tules.

ha level ape..ok2

 

[faidzal]

<?php

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

$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'];

$sql="SELECT * FROM pengguna WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

$count=mysql_num_rows($result);

if($count==1) {

if($row['level'] == 'admin') {
$_SESSION['username']= $row['myusername'];
$_SESSION['password']= $row['mypassword'];
$_SESSION['level'] = $row['level'];
header('Location: admin/index.php'); //page ke halaman admin
}

if($row['level'] == 'staff') {
$_SESSION['username']= $row['myusername'];
$_SESSION['password']= $row['mypassword'];
$_SESSION['level'] = $row['level'];
header('Location: admin/index.php'); //kalau nk buat 3 level, admin, staff, user.
}

elseif ($row['level'] == 'user') {
$_SESSION['username']= $row['myusername'];
$_SESSION['password']= $row['mypassword'];
$_SESSION['level'] = $row['level'];
header("Location: index.php"); //redirect user ke page user
}

else
echo "Not Authorized";
}

else {
$_SESSION['logged'] = 0;
header("Location: index.php?error=1");

}
?>

btw, aku xtest pn, anda cubela ye

 

[faidzal]

harapnya dpt bantu, dan fhm flow utk leveling. otai-otai sini bantulah cik ruzana.

 

[ruzana]

<?php

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

$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'];

$sql="SELECT * FROM pengguna WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

$count=mysql_num_rows($result);

if($count==1) {

if($row['level'] == 'admin') {
$_SESSION['username']= $row['myusername'];
$_SESSION['password']= $row['mypassword'];
$_SESSION['level'] = $row['level'];
header('Location: admin/index.php'); //page ke halaman admin
}

if($row['level'] == 'staff') {
$_SESSION['username']= $row['myusername'];
$_SESSION['password']= $row['mypassword'];
$_SESSION['level'] = $row['level'];
header('Location: admin/index.php'); //kalau nk buat 3 level, admin, staff, user.
}

elseif ($row['level'] == 'user') {
$_SESSION['username']= $row['myusername'];
$_SESSION['password']= $row['mypassword'];
$_SESSION['level'] = $row['level'];
header("Location: index.php"); //redirect user ke page user
}

else
echo "Not Authorized";
}

else {
$_SESSION['logged'] = 0;
header("Location: index.php?error=1");

}
?>

nanti kat database kene tukar ape??

 

[anuar76]

nanti kat database kene tukar ape??

Kalau guna code yg bro Faidzal bagi kat table pengguna kena tambah lagi satu column "level" dan untuk setiap user kena specify user tu admin, staff atau user.

Contohnya mungkin table pengguna mcm ni:

username	password		level
user1		mypassword1		admin
user2		mypassword2		staff
user3		mypassword3		user

 

[faidzal]

Kalau guna code yg bro Faidzal bagi kat table pengguna kena tambah lagi satu column "level" dan untuk setiap user kena specify user tu admin, staff atau user.

Contohnya mungkin table pengguna mcm ni:

username	password		level
user1		mypassword1		admin
user2		mypassword2		staff
user3		mypassword3		user

ya betol. tambah satu field, "level".

 

[ruzana]

Kalau guna code yg bro Faidzal bagi kat table pengguna kena tambah lagi satu column "level" dan untuk setiap user kena specify user tu admin, staff atau user.

Contohnya mungkin table pengguna mcm ni:

username	password		level
user1		mypassword1		admin
user2		mypassword2		staff
user3		mypassword3		user

ok sy da buat mcm tu,,then sy da btolkan coding tok panggil level tu,,mcm ni,,xtw la btol or x,,tp dye kua error

coding :
// username and password sent from form
$myusername=$_POST['No_KP'];
$mypassword=$_POST['Kata_Laluan'];
$mylevel=$_POST ['level'];

$sql="SELECT * FROM pengguna WHERE No_KP='$myusername' , level='$mylevel' and Kata_Laluan='$mypassword'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

$count=mysql_num_rows($result);

y sy bold tu,y sy tambah sendiri,,
ni error even da msukkan kata laluan y btol.pic dlm post no 1 tu,,

 

[ruzana]

ok done!!dah setle,,thanks guys!!

 

[Padeyl]

guna software apa..wamp ke

 

[ruzana]

guna software apa..wamp ke

xla,,xampp