Session End

From: Date: Wed, 27 Nov 2002 16:53:31 +0000
Subject: Session End
Groups: php.general 
Request: Send a blank email to php-general+get-126307@lists.php.net to get a copy of this message
Hi I am have created an authentication system, wherein the user is authenticated on the basis of a MySQL database. Here is the code <?php $auth = false; // Assume user is not authenticated if (isset( $PHP_AUTH_USER ) && isset($PHP_AUTH_PW)) {
    // Connect to MySQL
    mysql_pconnect( 'localhost', 'mysql', 'sunny' )
        or die ( 'Unable to connect to server.' );
    // Select database on MySQL server
    mysql_select_db( 'testbed' )
        or die ( 'Unable to select database.' );
    // Formulate the query
    $sql = "SELECT * FROM guest WHERE
            login    = '$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;
session_start();
    }
} if ( ! $auth ) {
    header( 'WWW-Authenticate: Basic realm="Pushpinder Singh\'s World"' );
    header( 'HTTP/1.0 401 Unauthorized' );
    echo 'Authorization Required.';
    exit;
} else {
    echo '<P>You are authorized!</P>';
} ?> However this keeps the user logged on. I want to be able to close the session once the user has finished his work. How do I do that?? Many Thanks --pS Pushpinder Singh Garcha _________________________________ Web Architect T. Falcon Napier and Associates, Inc. Off : 704 987 6500 Cell : 704 236 2939 Fax : 704 987 5002 _________________________________

« previous php.general (#126307) next »