login system not working

[barryknight]

Hi guys could someone please check my code and see whats wrong, i just cant see the error myself.

<?php
ini_set('display_error', 1);
error_reporting(E_ALL | E_STRICT);

session_start();

$username =$_POST['username'];
$password = $_POST['password'];

require('../include/db_include.php');   
$query = "SELECT id, 
                 username,
                 password,
                 is_admin
FROM cvk_runners WHERE username = '$username'";


$Result = $objConnection->query($query);



$row = $Result->fetch_assoc();

$_SESSION['id'] = $row['id'];

if($username == $row['username'] && $password == $row['password'] && $row['is_admin'] == 0){
    $_SESSION['auth']=0;
    header("location:../pages/admin.php");

    }
elseif($username == $row['username'] && $password == $row['password'] && $row['is_admin'] == 1){
    $_SESSION['auth']=1;
    header("location:../index.php");

} else {

   $_SESSION['loginmessage'] = 'forkert login info';
	header ('location:../index.php');


}



?>

[bradgrafelman]

Welcome to PHPBuilder! When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

barryknight;10999190 wrote:

i just cant see the error myself.

Which error? What's the problem? For what purpose should we be checking your code?

[barryknight]

HI again, i want to make sure the code is correct, im trying to find a error, i get sent to my check login page when the login button is clicked but the check login is meant to send the user to the admin area or back to the index page with the welcome your logged in or your not logged in, im not sure if the error is in the code i have posted or the error is on the check login page, hense asking for one some to check the code before proceeding to check login page to find error, it could be just a simple header location error on that page, but im new to php so everything looks ok to me!

[Derokorian]

at the top of your script add:

ini_set('error_reporting',-1);
ini_set('display_errors','On');

Then run the script again... are you getting any errors on the page?

[barryknight]

i have included the script you posted on both the index.page and the code_check_login page and there shows no error on index page, the check logig is all php code and there returns nothing on that page, could it be just the header location thats no sending onwards?

[barryknight]

<?php ini_set('error_reporting',-1);
ini_set('display_errors','On'); 
?> 
<?php
require('../includes/db_include.php');  

ini_set('display_error', 1);
error_reporting(E_ALL | E_STRICT);

session_start();

$username =$_POST['username'];
$password = $_POST['password'];


$query = "SELECT  
                 username,
                 password,
                 is_admin
FROM club WHERE username = '$username'";


$Result = $objConnection->query($query);


$row = $Result->fetch_assoc();

//   $_SESSION['id'] = $row['id'];

if($username == $row['username'] && $password == $row['password'] && $row['is_admin'] == 0){
    $_SESSION['auth']=0;
    header('location:../pages/admin.php');

    }
elseif($username == $row['username'] && $password == $row['password'] && $row['is_admin'] == 1){
    $_SESSION['auth']=1;
    header("location:../index.php");

} else {

   $_SESSION['loginmessage'] = 'wrong login info';
	header ('location:../index.php');


}



?>