You must be authenticated to connect to this stream.
'; } } function login($username, $password) // check username and password with db // if yes, return true // else return an error string... { $username = trim($username); // connect to db $conn = db_connect(); if (!$conn) return 'Could not connect to database server - please try later.'; // check username & pass $result = mysql_query("select * from users where user_name='$username' and password = password('$password')"); if (!$result) return 'Could not execute authenication query; please report this to the admin.'; // if there's exactly one result, the user is validated. Otherwise, they're invalid if (mysql_num_rows($result) == 1) { return true; } } function db_connect() { // hostname for db $db_hostname = 'localhost'; // Names of DB to connect to $db_name = 'user_auth_db'; // User for accessing the db $db_username = 'db_user'; // Password for DB user above $db_password = 'db_pass'; $result = mysql_pconnect($db_hostname, $db_username, $db_password); if (!$result) return false; if (!mysql_select_db($global_db_name)) return false; return $result; } ?>