need help with login proble phpmyadmin

[daruga]

Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\mkjb\core\functions\users.php on line 4

 

i need help how to fix this 

[daruga]

<?php

function user_exists ($username) {

	$username = sanitize($username);

	return(mysql_result(mysql_query("SELECT COUNT('user_id') FROM 'users' WHERE 'username' = '$username'"), 0) == 1) ? true : false;

} 


function user_active($username){

     $username = sanitize($username);

     return (mysql_result(mysql_query("SELECT COUNT('user_id') FROM 'users' WHERE 'username' = '$username' AND 'active' = 1"), 0) == 1) ? true : false;   

}


function user_id_from_username($username) {

	$username = sanitize($username);

	return mysql_result(mysql_query("SELECT 'user_id' FROM 'users' WHERE 'username' ='$username'"), 0, 'user_id');

}


function login ($username, $password) {

	$user_id = user_id_from_username($username);


		$username = sanitize($username);

		$password = md5($password);


		return (mysql_result(mysql_query("SELECT COUNT ('user_id') From 'users' WHERE 'username' = '$username' AND 'password' = '$password'"), 0) ==1) ? $user_id : false;

}


?>

 

[Ch0cu3r]

Remove the quotes around the user_id, users and username fields. MySQL wont treat them as field names but as strings.

[daruga]

did i need to remove all the quotes around user_id

[Ch0cu3r]

 

 

SELECT COUNT ('user_id') From 'users' WHERE 'username' = '$username' AND 'password' = '$password'"

All words highlighted in red/purple are field/table names. These should not have quotes wrapped round them. only field values should be wrapped in quotes.

[daruga]

<aside id="Just_A_Random_ID">
        
<?php 
if (logged_in)() === true {
	echo 'Logged in';
} else {




include "includes/widgets/login.php";

}
?>
		
 </aside>

 

 Parse error: syntax error, unexpected ')' in C:\wamp\www\mkjb\includes\aside.php on line 4

Call Stack # Time Memory Function Location 1 0.0004 140960 {main}( ) ..\register.php:0 2 0.0008 142384 include( 'C:\wamp\www\mkjb\includes\overall\overallheader.php' )

..\register.php:1

 

 

 

how to fix this error

[Ch0cu3r]

Do you know PHP basic syntax. This is not correct syntax

if (logged_in)() === true {

Reading the manual on how to properly construct if statements will help

http://uk1.php.net/manual/en/control-structures.if.php

[daruga]

<?php 
if (logged_in)() === true {
	echo 'Logged in';
} else {

is there a way to do if statement other than my....what we learn in school we been using more familiar with that statement.

because i did confuse with java if statement

[daruga]

my php level still beginner  

[Ch0cu3r]

I guess logged_in is a function? Then you have the parenthesis's (these are the ( and ) characters ) in the wrong place
 
remove the red character (wrong place) and add the blue character (correct place)
 

if (logged_in)() === true){
         wrong ^             ^ right

[daruga]

thank you Ch0cu3r for help..

[daruga]

<?php
function logged_in() {
    return (isset($_SESSION['user_id'])) ? true : false;

	 
	}

function user_exists ($username) {
	$username = sanitize($username);
	return(mysql_result(mysql_query ("SELECT COUNT(user_id) FROM users WHERE username = '$username'"), 0) == 1) ? true : false;
} 

function user_active($username){
     $username = sanitize($username);
     return (mysql_result(mysql_query("SELECT COUNT(user_id) FROM users WHERE username = '$username' AND active = 1"), 0) == 1) ? true : false;   
}

function user_id_from_username($username) {
	$username = sanitize($username);
	return mysql_result(mysql_query("SELECT user_id FROM users WHERE username ='$username'"), 0, 'user_id');
}

function login ($username, $password) {
	$user_id = user_id_from_username($username);
	
		$username = sanitize($username);
		$password = md5($password);
		
		return (mysql_result(mysql_query("SELECT COUNT(user_id) From users WHERE username = '$username' AND password = '$password'"), 0) ==1) ? $user_id : false;
}
?>

<aside>
        
<?php 
if (logged_in() === true) {
include 'includes/widgets/loggedin.php';
} else {

include "includes/widgets/login.php";
}

?>
		
 </aside>

 Fatal error: Call to undefined function logged_in() in C:\wamp\www\mkjb\includes\aside.php on line 4 Call Stack # Time Memory Function Location 1 0.0008 140912 {main}( ) ..\register.php:0 2 0.0011 142336 include('C:\wamp\www\mkjb\includes\overall\overallheader.php') ..\register.php:1 3 0.0020 144880 include( 'C:\wamp\www\mkjb\includes\aside.php' ) ..\overallheader.php:8

 

could u help me fix this...i try different method it give same result

[Ch0cu3r]

In what file is the logged_in() function located?

 

Is it in the same file as aside.php? If it is not you need to include the file that contains this function before you can use it.