login php (solve)

[arang67]

huh.... tere geng oding

yg duk reply2 ni terer..mesti gelak je ni..login pun x lepas2

 

[bluehyppo23]

$result = runQuery($sql); << kat bawah ni tambah
echo "<h1>".mysql_num_rows($result)."</h1>";

paste output kat sni....

 

[arang67]

$result = runQuery($sql); << kat bawah ni tambah
echo "<h1>".mysql_num_rows($result)."</h1>";

paste output kat sni....

ni output..dah tambah code atas tu

 

[bluehyppo23]

macam problems query ko je ni....

result ko x return apa pun....

yg ni ko dah try login balik...

tapi out put kuar camtu gak ?

 

[niurexx]

<?php
require_once*'database.php';

session_start();

function*signIn()
{
$sql*=*'SELECT*username,*user_type*FROM*users*WHERE*username*=*"'.addslashes($_POST['username']).'"*';
$sql*.=*'AND*password*=*"'.addslashes($_POST['password']).'";';
dbConnect();
$result*=*runQuery($sql);

if*(mysql_num_rows($result)*!=*0)
{
$data*=*mysql_fetch_assoc($result);
$_SESSION['username']*=*stripslashes($data['username']);
$_SESSION['user_type']*=*$data['user_type'];
echo $data['user_type']; die;

if*($_SESSION['user_type']*==*'student')
{
header('Location:*studentpage.php');
}
else*if*($_SESSION['user_type']*==*'staff')
{
header('Location:*adminpage.php');
}
}
else*{
header('Location:*login.php?status=SIGN-IN-FAILED');

}
}

function*signOut()
{
session_destroy();
header('Location:*index2.php');
}

function*isSessionValid()
{
if*(!isset($_SESSION['user_id'])*||*empty($_SESSION['user_id']))*{
signOut();
}

return*true;
}

if(isset($_POST)){
signIn();
}


if*(isset($_GET)*&&*$_GET['logout']*==*'true')*{
signOut();
}
?>

Copy n run code ni pastu bitau aku ape yg keluar lepas ko run

 

[arang67]

macam problems query ko je ni....

result ko x return apa pun....

yg ni ko dah try login balik...

tapi out put kuar camtu gak ?

haah..ni contoh db yg buat tu

kalau login akan keluar kat url
http://127.0.0.1/LMS/login.php?status=SIGN-IN-FAILED

 

[arang67]

Copy n run code ni pastu bitau aku ape yg keluar lepas ko run

yg simbol * kena buang la kan?

 

[bluehyppo23]

tengok function runQuery ko camne ...

 

[bluehyppo23]

pastikan filter semua bintang tu kui kui kui...

cuba post function runQuery ko tu ...

aku nak tengok code die...

 

[niurexx]

add ym aku [email protected]