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 

Edited September 29, 2013 by daruga

[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;

}


?>

 

Edited September 29, 2013 by daruga

[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.

Edited September 29, 2013 by Ch0cu3r

[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

Edited September 29, 2013 by Ch0cu3r

[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

Edited September 29, 2013 by Ch0cu3r

[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.

Edited September 29, 2013 by Ch0cu3r