{"id":1339,"date":"2022-11-28T08:45:21","date_gmt":"2022-11-28T00:45:21","guid":{"rendered":"https:\/\/hostscripter.com\/?p=1339"},"modified":"2022-11-28T08:45:21","modified_gmt":"2022-11-28T00:45:21","slug":"part-6-create-your-own-login-system-using-php-and-mysql","status":"publish","type":"post","link":"https:\/\/hostscripter.com\/?p=1339","title":{"rendered":"Part 6: Create your own Login System using PHP and MySql"},"content":{"rendered":"

6. Creating the Profile Page<\/h2>\n

The profile page will display the account information for the logged-in user.<\/p>\n

Edit the\u00a0profile.php<\/i>\u00a0file and add the following code:<\/p>\n

<\/div>\n
<?php<\/span>\r\n\/\/ We need to use sessions, so you should always start sessions using the below code.<\/span>\r\nsession_start<\/span>(<\/span>)<\/span>;<\/span>\r\n\/\/ If the user is not logged in redirect to the login page...<\/span>\r\nif<\/span> (<\/span>!<\/span>isset<\/span>(<\/span>$_SESSION<\/span>[<\/span>'loggedin'<\/span>]<\/span>)<\/span>)<\/span> {<\/span>\r\n\theader<\/span>(<\/span>'Location: index.html'<\/span>)<\/span>;<\/span>\r\n\texit;<\/span>\r\n}<\/span>\r\n$DATABASE_HOST<\/span> =<\/span> 'localhost'<\/span>;<\/span>\r\n$DATABASE_USER<\/span> =<\/span> 'root'<\/span>;<\/span>\r\n$DATABASE_PASS<\/span> =<\/span> ''<\/span>;<\/span>\r\n$DATABASE_NAME<\/span> =<\/span> 'phplogin'<\/span>;<\/span>\r\n$con<\/span> =<\/span> mysqli_connect<\/span>(<\/span>$DATABASE_HOST<\/span>,<\/span> $DATABASE_USER<\/span>,<\/span> $DATABASE_PASS<\/span>,<\/span> $DATABASE_NAME<\/span>)<\/span>;<\/span>\r\nif<\/span> (<\/span>mysqli_connect_errno<\/span>(<\/span>)<\/span>)<\/span> {<\/span>\r\n\texit<\/span>(<\/span>'Failed to connect to MySQL: '<\/span> .<\/span> mysqli_connect_error<\/span>(<\/span>)<\/span>)<\/span>;<\/span>\r\n}<\/span>\r\n\/\/ We don't have the password or email info stored in sessions so instead we can get the results from the database.<\/span>\r\n$stmt<\/span> =<\/span> $con<\/span>-<\/span>><\/span>prepare<\/span>(<\/span>'SELECT password, email FROM accounts WHERE id = ?'<\/span>)<\/span>;<\/span>\r\n\/\/ In this case we can use the account ID to get the account info.<\/span>\r\n$stmt<\/span>-<\/span>><\/span>bind_param<\/span>(<\/span>'i'<\/span>,<\/span> $_SESSION<\/span>[<\/span>'id'<\/span>]<\/span>)<\/span>;<\/span>\r\n$stmt<\/span>-<\/span>><\/span>execute<\/span>(<\/span>)<\/span>;<\/span>\r\n$stmt<\/span>-<\/span>><\/span>bind_result<\/span>(<\/span>$password<\/span>,<\/span> $email<\/span>)<\/span>;<\/span>\r\n$stmt<\/span>-<\/span>><\/span>fetch<\/span>(<\/span>)<\/span>;<\/span>\r\n$stmt<\/span>-<\/span>><\/span>close<\/span>(<\/span>)<\/span>;<\/span>\r\n?><\/span><\/span><\/code><\/pre>\n
The above code retrieves additional account information from the database, as before with the home page, we didn’t need to connect to the database because we retrieved the data stored in sessions.<\/p>\n
We’re going to populate all the account information for the user and therefore we must retrieve the\u00a0password<\/i>\u00a0and\u00a0email<\/i>\u00a0columns from the database. We don’t need to retrieve the\u00a0username<\/i>\u00a0or\u00a0id<\/i>\u00a0columns because we’ve them stored in session variables that were declared in the\u00a0authenticate.php<\/i>\u00a0file.<\/p>\n
After the closing tag, add the following code:<\/p>\n
<\/div>\n
<!DOCTYPE html><\/span>\r\n<<\/span>html><\/span><\/span>\r\n\t<<\/span>head><\/span><\/span>\r\n\t\t<<\/span>meta charset<\/span>=<\/span>\"<\/span>utf-8\"<\/span><\/span>><\/span><\/span>\r\n\t\t<<\/span>title><\/span><\/span>Profile Page<\/<\/span>title><\/span><\/span>\r\n\t\t<<\/span>link href<\/span>=<\/span>\"<\/span>style.css\"<\/span><\/span> rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span>><\/span><\/span>\r\n\t\t<<\/span>link rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>https:\/\/use.fontawesome.com\/releases\/v5.7.1\/css\/all.css\"<\/span><\/span>><\/span><\/span>\r\n\t<\/<\/span>head><\/span><\/span>\r\n\t<<\/span>body class<\/span>=<\/span>\"<\/span>loggedin\"<\/span><\/span>><\/span><\/span>\r\n\t\t<<\/span>nav class<\/span>=<\/span>\"<\/span>navtop\"<\/span><\/span>><\/span><\/span>\r\n\t\t\t<<\/span>div><\/span><\/span>\r\n\t\t\t\t<<\/span>h1><\/span><\/span>Website Title<\/<\/span>h1><\/span><\/span>\r\n\t\t\t\t<<\/span>a href<\/span>=<\/span>\"<\/span>profile.php\"<\/span><\/span>><\/span><\/span><<\/span>i class<\/span>=<\/span>\"<\/span>fas fa-user-circle\"<\/span><\/span>><\/span><\/span><\/<\/span>i><\/span><\/span>Profile<\/<\/span>a><\/span><\/span>\r\n\t\t\t\t<<\/span>a href<\/span>=<\/span>\"<\/span>logout.php\"<\/span><\/span>><\/span><\/span><<\/span>i class<\/span>=<\/span>\"<\/span>fas fa-sign-out-alt\"<\/span><\/span>><\/span><\/span><\/<\/span>i><\/span><\/span>Logout<\/<\/span>a><\/span><\/span>\r\n\t\t\t<\/<\/span>div><\/span><\/span>\r\n\t\t<\/<\/span>nav><\/span><\/span>\r\n\t\t<<\/span>div class<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span>\r\n\t\t\t<<\/span>h2><\/span><\/span>Profile Page<\/<\/span>h2><\/span><\/span>\r\n\t\t\t<<\/span>div><\/span><\/span>\r\n\t\t\t\t<<\/span>p><\/span><\/span>Your account details are below:<\/<\/span>p><\/span><\/span>\r\n\t\t\t\t<<\/span>table><\/span><\/span>\r\n\t\t\t\t\t<<\/span>tr><\/span><\/span>\r\n\t\t\t\t\t\t<<\/span>td><\/span><\/span>Username:<\/<\/span>td><\/span><\/span>\r\n\t\t\t\t\t\t<<\/span>td><\/span><\/span><?=<\/span>$_SESSION<\/span>[<\/span>'name'<\/span>]<\/span>?><\/span><\/span><\/<\/span>td><\/span><\/span>\r\n\t\t\t\t\t<\/<\/span>tr><\/span><\/span>\r\n\t\t\t\t\t<<\/span>tr><\/span><\/span>\r\n\t\t\t\t\t\t<<\/span>td><\/span><\/span>Password:<\/<\/span>td><\/span><\/span>\r\n\t\t\t\t\t\t<<\/span>td><\/span><\/span><?=<\/span>$password<\/span>?><\/span><\/span><\/<\/span>td><\/span><\/span>\r\n\t\t\t\t\t<\/<\/span>tr><\/span><\/span>\r\n\t\t\t\t\t<<\/span>tr><\/span><\/span>\r\n\t\t\t\t\t\t<<\/span>td><\/span><\/span>Email:<\/<\/span>td><\/span><\/span>\r\n\t\t\t\t\t\t<<\/span>td><\/span><\/span><?=<\/span>$email<\/span>?><\/span><\/span><\/<\/span>td><\/span><\/span>\r\n\t\t\t\t\t<\/<\/span>tr><\/span><\/span>\r\n\t\t\t\t<\/<\/span>table><\/span><\/span>\r\n\t\t\t<\/<\/span>div><\/span><\/span>\r\n\t\t<\/<\/span>div><\/span><\/span>\r\n\t<\/<\/span>body><\/span><\/span>\r\n<\/<\/span>html><\/span><\/span><\/code><\/pre>\n
A simple layout that will populate account information. If you navigate to the\u00a0profile.php<\/i>\u00a0file, it will look like the following:<\/p>\n
\n
http:\/\/localhost\/phplogin\/profile.php<\/span><\/div>\n
\"PHP<\/div>\n
Remember, the passwords are encrypted, so you cannot see the decrypted password unless you create a new session variable and store the password in the\u00a0authenticate.php<\/i>\u00a0file.<\/p>\n
<\/a><\/a><\/a><\/a><\/div>
<\/a><\/a><\/a><\/a><\/div>","protected":false},"excerpt":{"rendered":"
6. Creating the Profile Page The profile page will display the account information for the logged-in user. Edit the\u00a0profile.php\u00a0file and add the following code: <?php \/\/ We need to use […]<\/p>\n","protected":false},"author":301,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"footnotes":""},"categories":[4],"tags":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9KaPo-lB","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1341,"url":"https:\/\/hostscripter.com\/?p=1341","url_meta":{"origin":1339,"position":0},"title":"Part 7: Create your own Login System using PHP and MySql","author":"h05t5cr1pt3r","date":"November 28, 2022","format":false,"excerpt":"7. Creating the Logout Script Creating the logout script is straightforward. All you need to do is destroy the sessions that were declared in the authenticate file. Edit the\u00a0logout.php\u00a0file and add the following code:  Initialize sessions, destroy them,\u2026","rel":"","context":"In "Blog"","block_context":{"text":"Blog","link":"https:\/\/hostscripter.com\/?cat=4"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1329,"url":"https:\/\/hostscripter.com\/?p=1329","url_meta":{"origin":1339,"position":1},"title":"Part 1: Create your own Login System using PHP and MySql","author":"h05t5cr1pt3r","date":"November 28, 2022","format":false,"excerpt":"In this tutorial, I'll be teaching you how you can create your very own secure PHP login system. A login form is what your website's visitors can use to log in to your website to access restricted content, such as a profile page. We will leverage MySQL to retrieve account\u2026","rel":"","context":"In "Blog"","block_context":{"text":"Blog","link":"https:\/\/hostscripter.com\/?cat=4"},"img":{"alt_text":"Secure Login System with PHP and MySQL","src":"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/posts\/secure-login-system-php-mysql.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/posts\/secure-login-system-php-mysql.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/codeshack.io\/web\/img\/posts\/secure-login-system-php-mysql.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/codeshack.io\/web\/img\/posts\/secure-login-system-php-mysql.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1337,"url":"https:\/\/hostscripter.com\/?p=1337","url_meta":{"origin":1339,"position":2},"title":"Part 5: Create your own Login System using PHP and MySql","author":"h05t5cr1pt3r","date":"November 28, 2022","format":false,"excerpt":"5. Creating the Home Page The home page will be the first page our users see when they've logged-in. The only way they can access this page is if they're logged-in, whereas if they aren't, they will be redirected back to the login page. Edit the\u00a0home.php\u00a0file and add the following\u2026","rel":"","context":"In "Blog"","block_context":{"text":"Blog","link":"https:\/\/hostscripter.com\/?cat=4"},"img":{"alt_text":"PHP Loggedin Home Page","src":"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/loggedin-home-page.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/loggedin-home-page.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/loggedin-home-page.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/loggedin-home-page.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1335,"url":"https:\/\/hostscripter.com\/?p=1335","url_meta":{"origin":1339,"position":3},"title":"Part 4: Create your own Login System using PHP and MySql","author":"h05t5cr1pt3r","date":"November 28, 2022","format":false,"excerpt":"4. Authenticating Users with PHP Now that we have our database setup, we can go ahead and start coding with PHP. We're going to start with the authentication file, which will process and validate the form data that we'll send from our\u00a0index.html\u00a0file. Edit the\u00a0authenticate.php\u00a0file and add the following: