mysql, header and varables

[jaredly]

here is my code:

<?php 

// Check to see if $PHP_AUTH_USER already contains info
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)) {

	mysql_connect("localhost", "root", "*******") or die ("Unable to connect to database.");

	// select database on MySQL server
	mysql_select_db("client_login") or die ("Unable to select database.");

	// Formulate the query
	$sql = "SELECT directory FROM clients WHERE user='$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 "this is $result";
		//header("Location: /$result");  
		exit;
		} else {
			header('WWW-Authenticate: Basic realm="My Private Stuff"');
			header('HTTP/1.0 401 Unauthorized');
			echo 'Authorization Required.';
			exit;
			}
		}
?>

I can not get $result to show up or the header to go to the right directory. What is wrong with my code here?

Here is an examplehttp://jinxydesign.com/clients/

user dan
pass noe

[drew010]

$result is actually going to be a variable of type 'resource'. if you want to retrieve the resultset from the sql query, you need to use functions such as [man]mysql_fetch_array[/man] or [man]mysql_fetch_row[/man].
setting
$data = mysql_fetch_array($result);
will assume only 1 row should be returned in this case of a username and password being used, that is probably true. now data contains an array of data where each fieldname in the database is an array index.

$data['user'], $data['password'], and $data['directory'] will be valid examples judging by your code. $data['directory'] will hold the directory, which appears to be what you are trying to display by echoing $result.

[jaredly]

This is what I have now. give it a try u: dan p: noe still no go?

<?php 

// Check to see if $PHP_AUTH_USER already contains info
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)) {

	mysql_connect("localhost", "root", "*******") or die ("Unable to connect to database.");

	// select database on MySQL server
	mysql_select_db("client_login") or die ("Unable to select database.");

	// Formulate the query
	$sql = "SELECT directory FROM clients WHERE user='$PHP_AUTH_USER' and password='$PHP_AUTH_PW";

	// Execute the query and put results in $result
	$result = mysql_query($sql);

	$data = mysql_fetch_array($result); 

	// Get number of rows in $result. 0 if invalid, 1 if valid.
	$num = mysql_numrows($result);
	if ($num != "0") {
		print "this is {$data['directory']} !";
		exit;
		} else {
			header('WWW-Authenticate: Basic realm="My Private Stuff"');
			header('HTTP/1.0 401 Unauthorized');
			echo 'Authorization Required.';
			exit;
			}
		}
?>

[drew010]

we can try to debug it and see what the problem is. i have stripped it of comments to shorten the code.

<?php 

if (!isset($PHP_AUTH_USER)) {
    header('WWW-Authenticate: Basic realm="My Private Stuff"');
    header('HTTP/1.0 401 Unauthorized');
    exit;
} else if (isset($PHP_AUTH_USER)) {    

	mysql_connect("localhost", "root", "*******") or die ("Unable to connect to database.");
    mysql_select_db("client_login") or die ("Unable to select database.");
    $sql = "SELECT directory FROM clients WHERE user='$PHP_AUTH_USER' and password='$PHP_AUTH_PW";

echo $sql . "<br />\n"; //DEBUG

$result = mysql_query($sql);

echo mysql_error() . "<br />\n"; //DEBUG

if (mysql_num_rows($result)) {
    $data = mysql_fetch_array($result); 

    print "this is {$data['directory']} for $PHP_AUTH_USER identified by $PHP_AUTH_PW!";
    exit;
} else {
  	header('WWW-Authenticate: Basic realm="My Private Stuff"');
    header('HTTP/1.0 401 Unauthorized');
    echo 'Authorization Required.';
    exit;
}
}
?> 

[jaredly]

I uploaded it and now I am not getting anything?

Here is my php info.

[jaredly]

Here is my final working code.

<?php 
	if (!isset($PHP_AUTH_USER)) {
		header('WWW-Authenticate: Basic realm="My Private Stuff"');
		header('HTTP/1.0 401 Unauthorized');
		exit;
		} else if (isset($PHP_AUTH_USER)) {
			mysql_connect("localhost", "root", "******") or die ("Unable to connect to database.");
			mysql_select_db("client_login") or die ("Unable to select database.");
			$sql = "SELECT * FROM clients WHERE username='$PHP_AUTH_USER' and password='$PHP_AUTH_PW'";
			$result = mysql_query($sql);
			$data = mysql_fetch_array($result);
			$num = mysql_numrows($result);
			if ($num != "0") {
				echo "<P>$PHP_AUTH_USER authorized! </p>";
				$goto=$data['directory'];
				header("Location: $goto");
				echo"$goto";
				exit;
				} else {
					header('WWW-Authenticate: Basic realm="My Private Stuff"');
					header('HTTP/1.0 401 Unauthorized');
				 	echo 'Authorization Required.';
					exit;
					}
				} 
?>