Try using this :

<?php 
$auth = false; // Assume user is not authenticated 
if (isset( $PHP_AUTH_USER ) && isset($PHP_AUTH_PW)) { 
    
        mysql_connect('localhost','root') or die (
'Unable to connect to server.' ); 
        mysql_select_db( 'myDB' ) or die ( 'Unable to
select database.' ); 

    // Formulate the query 

    $sql = "SELECT * FROM myTable WHERE 
            username = '$PHP_AUTH_USER' AND 
            password = '$PHP_AUTH_PW'"; 

    // Execute the query and put results in $result 

    $result = mysql_query( $sql ) or die ( 'Unable to
execute query.' ); 

    // Get number of rows in $result. 
    $num = mysql_numrows( $result ); 
    if ( $num != 0 ) { 

        // A matching row was found - the user is
authenticated. 

        $auth = true; 
    } 
} 

if ( ! $auth ) { 

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

} else { 

***your stuff goes here when authenticated****

}
?>

works excellent on any browser, apache server with PHP
module. 

T. Edison jr.


--- gary <[EMAIL PROTECTED]> wrote:
> Im having a problem with Authentication uisng
> $PHP_AUTH_USER and
> $PHP_AUTH_PASSWORD works fine connecting via
> netscape but automatically
> set to false when using IE 5. Apache server , PHP
> installed as a module
> on a freebie server. Code below:
> <?php
> 
>  // Assume user is not authenticated
> 
> if (isset($PHP_AUTH_USER) && isset($PHP_AUTH_PW)) {
> 
>   // Connect to database
>   $conn = pg_pconnect ("dbname=".$db.$login);
>   // Select database on MySQL server
> 
> 
>   // Formulate the query
> 
>   $sql = "SELECT * FROM ".$table2." WHERE
>   username = '$PHP_AUTH_USER' AND
>   password = '$PHP_AUTH_PW' and valid ='y'";
> 
>   // Execute the query and put results in $result
> 
>   $result = pg_Exec ( $sql );
> 
>   // Get number of rows in $result.
> 
>   $num = pg_numrows( $result );
>   if ( $num != 0 ) {
>   // A matching row was found - the user is
> authenticated.
>      $auth = true;
>    }
> }
> if ( ! $auth ) {
>   header("WWW-Authentucate: Basic
> realm=\"Private\"\\n");
>   Header ("Status: 401 Unauthorized\n");
>    header("HTTP/1.0 401 Unauthorized\n");
>     echo 'Authorization Required.<br>';
>     echo 'Please go to <a
> href=./index,php?pg=REGISTER>Registration</a>
> page to Get a logon, It is Free.';
>     echo
>
"<br><b>???????".$PHP_AUTH_USER."<br>???????".$PHP_AUTH_PW."</b>";
>   exit;
> } else {
> }
> pg_close($conn);
> ?>
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> 


=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
*******************************************

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to