[PHP] Session End

[Pushpinder Singh Garcha]

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
_________________________________