My Little Scripts - mysql-login.php

Scripts.com - Get the best scripts NOW!
HotScripts.com - Over 10 web rings.
more links...

Index News Samples Downloads E-Mail me Forum Sign Up

MYSQL-LOGIN.PHP

Make PHP generated web content available only to you! I derived this function from some PHP code that I used on the administrative portion of my database driven sites. isLogged() returns true if the cookies named UserName and PassWord are not null, and successfully create a database connection when passed with the mysql_connect function. If not, it displays the content of $LogInPage.

This is a modified version of login.php. By doing this, I got rid of some redundancy in my code, and made it more portable. I would have used this to replace login.php, but I would have been neglecting the cases where sites don't have access to a MySQL database.

<?
function isLogged($LogInPage)
         {
         //Without this, PHP will create a local
         //variable called $HTTP_COOKIE_VARS.
         global $HTTP_COOKIE_VARS;

         $Host = "localhost";

         $Entered_UserName = "";
         $Entered_PassWord = "";

         if(isset($HTTP_COOKIE_VARS["UserName"]) &&
            isset($HTTP_COOKIE_VARS["PassWord"]))
           {
           $Entered_UserName = $HTTP_COOKIE_VARS["UserName"];
           $Entered_PassWord = $HTTP_COOKIE_VARS["PassWord"];
           }

         //I'm assuming that empty string user names and passwords are a no no.
         if(@mysql_connect($Host, $Entered_UserName, $Entered_PassWord) === false ||
           ($Entered_UserName == "" || $Entered_PassWord == ""))
           {
           //$LogInPage should be the name of an existing file
           //with alternative web content. If you don't wish to
           //provide such content, just pass the empty string.
           if($LogInPage != "") include($LogInPage);
           return(false);
           }
         else
           return(true);
         }
?>

<form name="login">
<table align="center" cellpadding="10" cellspacing="0" border="1">
<tr>
<td>User Name </td>
<td><input type="text" name="UserName" /></td>
</tr>

<tr>
<td>Password</td>
<td><input type="password" name="PassWord" /></td>
</tr>

<tr>
<td colspan="2" align="right">
<input type="button" value="log in"
       onclick="document.cookie = 'UserName=' + document.login.UserName.value;
                document.cookie = 'PassWord=' + document.login.PassWord.value;
                document.EmptyForm.submit();">
</td>
</tr>
</table>
</form>

<form name="EmptyForm" method="post">
</form>

see also :