PHP MySQL Secure Log In: Register and login users in a MySQL database

Recommend this page to a friend!

Download .zip

Info

Example

View files (8)

Download .zip

Reputation

Support forum (2)

Blog

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2024-01-09 (3 days ago)		Not enough user ratings				Total: 819 This week: 10		All time: 4,206 This week: 22

Version		License		PHP version		Categories
`php-mysql-secure-log` 1.10		GNU General Publi...		5.0		PHP 5, Databases, User Management, Lo...

Description

Author

Radovan Janjic

This package can register and login users in a MySQL database.

It provides several classes that can register users by creating the respective MySQL database records, authenticate registered users, and manage sessions of authenticated storing session data also in a MySQL database table.

MySQL database SQL queries are logged to a file.

Radovan Janjic

Performance

Level

Name:	Radovan Janjic `<contact>`
Classes:	14 packages by Radovan Janjic
Country:	Serbia

Level 5

Innovation award

Nominee: 3x

Example


<?php



define('MYSQL_HOST', 'localhost');

define('MYSQL_USERNAME', 'root');

define('MYSQL_PASSWORD', '');

define('MYSQL_DATABASE', 'users');

define('MYSQL_TABLE_USERS', 'users');



include 'MySQL_wrapper.class.php';

include 'MySQL_Session_Handler.class.php';

include 'User_Validation.class.php';

include 'User_Log_In.class.php';







$db = MySQL_wrapper::getInstance(MYSQL_HOST, MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DATABASE);



// Logging only for testing!

$db->logQueries = TRUE;



// Log errors

$db->logErrors = TRUE;



// Create object

$GLOBALS['MYSQL_SESSION'] = new MySQL_Session_Handler($db, 'sessions');



$a = new User_Log_In;



$a->db = &$db;



echo '<pre>';



echo 'Session before login check:' . PHP_EOL, print_r($_SESSION, TRUE);



$loggedin = FALSE;

if ($a->loggedIn()) {

    $loggedin = TRUE;

    if (!empty($_POST['logout'])) { // Log out

        $a->logOut('example.php?loggedOutLocation');

    }

    echo '<b>Logged in!</b>' . PHP_EOL;

    

} else {

    $loggedin = FALSE;

    if (isset($_POST['login'])) {

        if ($a->logInUser($_POST['email'], $_POST['password'])) { // Login

            header('Location: example.php?loggedInLocation');

            $loggedin = TRUE;

        } else {

            echo '<b>Woops!</b>' . PHP_EOL;

            echo '<b>Email or password is wrong!</b>' . PHP_EOL;

        }

    }

}





echo 'Session after login check:' . PHP_EOL, print_r($_SESSION, TRUE);





echo PHP_EOL . PHP_EOL . 'POST:' . PHP_EOL . print_r($_POST, TRUE) . PHP_EOL;



/* */

$hash = $a->hash("foobar");

echo "Hashed pass: " . $hash . PHP_EOL;

if ($a->validatePassword("foobar", $hash)) {

    echo 'Valid password' . PHP_EOL;

} else {

    echo 'Wrong password' . PHP_EOL;

}



?>

</pre>



<?php if ($loggedin): ?>

    <form method="post">

        <input type="hidden" name="logout" value="1" />

        Log out

        <input type="submit" />

    </form>

<?php else: ?>

    <form method="post">

        <input type="hidden" name="login" value="1" />

        <input type="text" name="email" value="rade@it-radionica.com" /><br />

        <input type="text" name="password" value="foobar" />

        <input type="submit" />

    </form>

<?php endif; ?>

Files

File	Role	Description
`example.php`	Example	Example script
`log-mysql.txt`	Output	Sample output
`MySQL_Session_Handler.class.php`	Class	Class source
`MySQL_wrapper.class.php`	Class	Class source
`users.sql`	Data	Auxiliary data
`User_Log_In.class.php`	Class	Class source
`User_Register.class.php`	Class	Class source
`User_Validation.class.php`	Class	Class source