PHP (code not nuke) Help

[DevilDog#1]

Getting


You do not have permission to access this page. Please login Below.
Username:
Password:
Submit -- Reset



You keep referring to code above... you talking about P's code or Elite's?

[KoBrA]

read the rest of the post

[DevilDog#1]

Can I see your code please?

[KoBrA]

mine? ... its the same as he gave me

<?
function login_form() {?>

	<form method="post" action="<?Echo($_SERVER['PHP_SELF']);?>">
	Username: <input type="text" name="username" /><br />
	Password: <input type="password" name="password" /><br />
	<input type="hidden" name="login" value="true" />
	<input type="submit" name="login" value=" Login " /> <input type="reset" value=" Reset " />
	</form>

<?}

If($_POST['login']) {

	$username=mysql_real_escape_string($_POST['username']);
	$password=mysql_real_escape_string($_POST['password']);
	
	$query=mysql_query("SELECT * FROM users WHERE username='".$username."' AND password='".$password."' LIMIT 1");
	
	If(mysql_num_rows($query) > 0) {
		setcookie("loggedin","true",time+36000); //1 day
		sleep(1);
	}
	mysql_free_result($query);
	
	header("Location: ".$_SERVER['PHP_SELF']);
	exit;

}



If($_COOKIE['loggedin']!="true") {

	Echo(" You do not have permission to access this page. Please login Below. ");
	login_form(); // print the login form
	exit;

}?>

[DevilDog#1]

Try

PHP Code:


<?php
function login_form() {?>

    <form method="post" action="<?php Echo($_SERVER['PHP_SELF']);?>">
    Username: <input type="text" name="username" /><br />
    Password: <input type="password" name="password" /><br />
    <input type="hidden" name="login" value="true" />
    <input type="submit" name="login" value=" Login " /> <input type="reset" value=" Reset " />
    </form>

<?php }

If($_POST['login']) {

     $username=mysql_real_escape_string($_POST['username']);
     $password=mysql_real_escape_string($_POST['password']);
    
    $query=mysql_query("SELECT * FROM users WHERE username='".$username."' AND password='".$password."' LIMIT 1");
    
    If(mysql_num_rows($query) > 0) {
        setcookie("loggedin","true",time+36000); //1 day
        sleep(1);
    }
    mysql_free_result($query);
    
    header("Location: ".$_SERVER['PHP_SELF']);
    exit;
}

If($_COOKIE['loggedin']!="true") {

    Echo(" You do not have permission to access this page. Please login Below. ");
    login_form(); // print the login form
    exit;
}?>

[KoBrA]

got an error now .... the login boxes don't show

[DevilDog#1]

Interesting ... Try now

PHP Code:

<?
function login_form() {?>

    <form method="post" action="<? Echo($_SERVER['PHP_SELF']);?>">
    Username: <input type="text" name="username" /><br />
    Password: <input type="password" name="password" /><br />
    <input type="hidden" name="login" value="true" />
    <input type="submit" name="login" value=" Login " /> <input type="reset" value=" Reset " />
    </form>

<? }

If($_POST['login']) {

     $username=mysql_real_escape_string($_POST['username']);
     $password=mysql_real_escape_string($_POST['password']);
    
    $query=mysql_query("SELECT * FROM users WHERE username='".$username."' AND password='".$password."' LIMIT 1");
    
    If(mysql_num_rows($query) > 0) {
        setcookie("loggedin","true",time+36000); //1 day
        sleep(1);
    }
    mysql_free_result($query);
    
    header("Location: ".$_SERVER['PHP_SELF']);
    exit;
}

If($_COOKIE['loggedin']!="true") {

    Echo(" You do not have permission to access this page. Please login Below. ");
    login_form(); // print the login form
    exit;
}?>

[KoBrA]

when i try to login with the user and pass that i registered and it said was success full i get this

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/kobra/public_html/unitedalliance/login.php on line 22

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home2/kobra/public_html/unitedalliance/login.php on line 26

Warning: Cannot modify header information - headers already sent by (output started at /home2/kobra/public_html/unitedalliance/login.php:22) in /home2/kobra/public_html/unitedalliance/login.php on line 28

[DevilDog#1]

Is your DB working ok?

Run this code ... you'll know if your DB is working. Save it as "mysql_connect.php"

PHP Code:

<html>

<head>
</head>

<body>

<?php


if ($dbc = @mysql_connect('localhost', 'username', 'password') ) {

    print '<p>Successfully connected to MySQL.</p>';

    mysql_close();

} else {

    die('<p>Could not connect to MySQL because: <b>'. mysql_error().'</b></p>');

}

?>

</body>
</html>

[KoBrA]

should i can run forums off it .. the user has all privlages ... umm

[DevilDog#1]

and the forum is up? and you do posts and stuff?

[KoBrA]

idk i just cleared everythign .. and made new a new database for this

[JonM]

u know what guys...i'm liking ur code and all, but how can you tell if there logged in? all it does is check if they aren't logged in if i'm readding it correctly...

PHP Code:

<? 
function login_form() {?> 

    <form method="post" action="<? Echo($_SERVER['PHP_SELF']);?>"> 
    Username: <input type="text" name="username" /><br /> 
    Password: <input type="password" name="password" /><br /> 
    <input type="hidden" name="login" value="true" /> 
    <input type="submit" name="login" value=" Login " /> <input type="reset" value=" Reset " /> 
    </form> 

<? } 

If($_POST['login']) { 

      $username=mysql_real_escape_string($_POST['userna
me']); 
      $password=mysql_real_escape_string($_POST['passwo
rd']); 
     
    $query=mysql_query("SELECT * FROM users WHERE username='".$username."' AND password='".$password."' LIMIT 1"); 
     
    If(mysql_num_rows($query) > 0) { 
        setcookie("loggedin","true",time+36000); //1 day 
        sleep(1); 
    } 
    mysql_free_result($query); 
     
    header("Location: ".$_SERVER['PHP_SELF']); 
    exit; 
} 

If($_COOKIE['loggedin']!="true") { 

    Echo(" You do not have permission to access this page. Please login Below. "); 
    login_form(); // print the login form 
    exit; 
}?>

c i would change the cookie to this to:

PHP Code:

setcookie("loggedin","".$username."",time+36000); //1 day 


then i would replace this part

PHP Code:

If($_COOKIE['loggedin']!="true") { 

    Echo(" You do not have permission to access this page. Please login Below. "); 
    login_form(); // print the login form 
    exit; 
}?> 


to:

PHP Code:


//replace with if(!$_COOKIE['loggedin'] || $_COOKIE['loggedin']==""){
echo'This is a restricted page to members only, you may login or <a href="register.php">Register</a>';
}else{
/*the users got the cookie and is loggedin*/
$nick=$_COOKIE['loggedin'];
echo'Welcome back <b>'.$nick.'</b>!  You may now access restricted parts of the site!';
} 


also u may just need to fix some db issues, like your connect or something for the error.

[Stu]

Your MySQL server might be currupt. I know when i was using Lycos i had alot of trouble for nothing

[DevilDog#1]

Just get EASYPHP and play locally. Then get Apache and PHP individually and play with that and then when you feel you're expert get a webspace.