Thanks Ive fixed my problem..............
"Thomas Edison Jr." wrote:
> 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]
--
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]
