adminsitatinon login troubles

justinb

Hello,
I am trying to create a login page for my admin site, which starts a session, If the admin name and pass are in db (logged in), they get a main menu buttun and a session is started. If not in db they get a try again link. Whats happeneing is that the page is coming up blank, no errors, just blank.

The do_html_url() function is a function in outputFns.php which diplays the links. This is my code , can someone help please.

<html><head></head><body>
<?
include_once("outputFns.php");
?>
<?
function login($username, $password)

{ // begin login function
// this function checks the username and password with the db table for admin users
// connect to db
// check if username is unique
$db_name = "xxxxxxxxxxx";

$table = "admin";

//1

$connection = @mysql_connect("xxxxxxx", "xxxxxxx", "xxxxx") or die("Problems connecting - Try again");

//2

$result = mysql_query("SELECT adminID, adminName, adminPass FROM '$table' WHERE adminName='$username' AND adminPass ='$password'");

if(!$result)

  do_html_url("login.php", " Wrong Login Infromation try agin");

if(mysql_num_rows($result) > 0)

  do_html_url("MenuView.php", " Welcome to the Adminsitration Site");
  session_register('valid');
  $valid = "yes";

else

  do_html_url("login.php", " Wrong Login Infromation try aagin");

} // end login() function
?>
</body></html>

surfer

Seems you defined the login() function but don't call it anywhere, can you provide more information ?

justinb

Oh,
That is all i wrote, how should I use it ?

justinb

doh,

of course, I'm using it now, but I am just getting both messages

not logged in

but i have the right user name and pass, i have 3 entries in db, the first is empty, maybe its not looping

twilson

After the user submits your login form, you need to call the login() function like:

login($HTTP_POST_VARS['username'],$HTTP_POST_VARS['password']);

$HTTP_POST_VARS may be replaced with $_POST if you are running PHP 4.1.0 or higher.

Hope this helps,
Tom

justinb

ok i changed the code to this, and i am getting the error 3 message

any ideas

<?
function login($username, $password)

{ // begin login function
// this function checks the username and password with the db table for admin users
// connect to db
// check if username is unique
$db_name = "xxxxxxxxxx";

$table = "admin";

//1

$connection = @mysql_connect("xxxxxx", "xxxxxxx", "xxxxxx") or die("Problems connecting - Try again");

//2

$sql = "SELECT * FROM $table WHERE adminUser = '$username' AND adminPass = password('$password')";

$result = @($sql, $connection) or die("Error3 - Couldn't connect - try again later");

if(mysql_num_rows($result) > 0){

  do_html_url("MenuView.php", " Welcome to the Adminsitration Site");
  session_register('valid');
  $valid = "yes";

  } else

do_html_url("login.php", " Wrong Login Infromation try again");

} // end login() function
?>
<?
error_reporting (E_ALL ^ E_NOTICE);
?>
<?
login($HTTP_POST_VARS['username'],$HTTP_POST_VARS['password']);
?>

</body></html>