<?php function user_exists($username) { $username = sanitize($username); return (mysql_result(mysql_query("SELECT COUNT ('id') FROM 'practice' WHERE 'login' = '$username'"), 0) == 1) ? TRUE : FALSE; } // "SELECT COUNT ('id') FROM 'practice' WHERE 'login' = '$username'"), 0) == 1) ? TRUE : FALSE; function user_active($username) { $username = sanitize($username); return (mysql_result(mysql_query("SELECT COUNT ('id') FROM 'practice' WHERE 'login' = '$username' AND 'active' = 1"),0)===1)?TRUE:FALSE; } function id_from_username($username) { $username = sanitize($username); return mysql_result(mysql_query("SELECT 'id' FROM 'practice' WHERE 'login'='$username'"),0,'id'); } function login($username, $password) { $user_id = id_from_username($username); $username = sanitize($username); //$password = md5($password); return (mysql_result(mysql_query("SELECT COUNT('id') FROM 'practice' WHERE 'login'='$username' AND 'password'='$password'"),0)==1) ?$user_id : FALSE; } ?>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)