Header auth.

[darkfunkel]

I have made a login script. In version two as apposed to a form I want to use that login box like phpmyadmin does. I checked the http 1.1 site and the php.net/header and have no idea. It gets there username from a database if mysql_num_row is greater than 0 on the query then if it is it runs a loop to get the password. How would I do this using headers?

[interactive]

I'm not sure if it's posible with headers? I believe you would have to use .htaccess. Thanks

[Daggeth]

I know what youre lookin for:

<?php
if (!isset($PHP_AUTH_USER)) {
  // If empty, send header causing dialog box to appear
  header('WWW-Authenticate: Basic realm="My Private Stuff"');
  header('HTTP/1.0 401 Unauthorized');
  exit;
  } else if (isset($PHP_AUTH_USER)) {
  // If non-empty, check the database for matches
  // connect to MySQL
  mysql_connect("hostname", "username", "password") 
  or die ("Unable to connect to database.");
  // select database on MySQL server
  mysql_select_db("dev_i2ii_com") 
  or die ("Unable to select database.");
     // Formulate the query
     $sql = "SELECT *
     FROM users WHERE username='$PHP_AUTH_USER' and password='$PHP_AUTH_PW'";



	// Execute the query and put results in $result

	$result = mysql_query($sql);

	// Get number of rows in $result. 0 if invalid, 1 if valid.

	$num = mysql_numrows($result);

	if ($num != "0") {
		echo "<P>You're authorized!</p>";	
		exit;

	} else {	

		header('WWW-Authenticate: Basic realm="My Private Stuff"');
		header('HTTP/1.0 401 Unauthorized');
		echo 'Authorization Required.';
		exit;

	}

} 
?>

Borrowed from: http://hotwired.lycos.com/webmonkey/03/09/index2a_page3.html?tw=jobs