{"id":1331,"date":"2022-11-28T08:07:42","date_gmt":"2022-11-28T00:07:42","guid":{"rendered":"https:\/\/hostscripter.com\/?p=1331"},"modified":"2022-11-28T08:07:42","modified_gmt":"2022-11-28T00:07:42","slug":"part-2-create-your-own-login-system-using-php-and-mysql","status":"publish","type":"post","link":"https:\/\/hostscripter.com\/?p=1331","title":{"rendered":"Part 2: Create your own Login System using PHP and MySql"},"content":{"rendered":"<h2 id=\"creatingtheloginformdesign\">2. Creating the Login Form Design<\/h2>\n<p>We will now create a form that our users can use to enter their details and submit them for processing. We will be using HTML and CSS for this part of the tutorial as PHP will not be necessary on this page.<\/p>\n<p>Edit the\u00a0<i>index.html<\/i>\u00a0file with your favorite code editor and add the following code:<\/p>\n<div class=\"code-header\"><\/div>\n<pre class=\" language-html\"><code class=\" language-html\"><span class=\"token doctype\">&lt;!DOCTYPE html&gt;<\/span>\r\n<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>html<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>head<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>meta <span class=\"token attr-name\">charset<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>utf-8<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>title<span class=\"token punctuation\">&gt;<\/span><\/span>Login<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>title<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>link <span class=\"token attr-name\">rel<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>stylesheet<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">href<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>https:\/\/use.fontawesome.com\/releases\/v5.7.1\/css\/all.css<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>head<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>body<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>div <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>login<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>h1<span class=\"token punctuation\">&gt;<\/span><\/span>Login<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>h1<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>form <span class=\"token attr-name\">action<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>authenticate.php<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">method<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>post<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>label <span class=\"token attr-name\">for<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>username<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>i <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>fas fa-user<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>i<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>label<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>input <span class=\"token attr-name\">type<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>text<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">name<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>username<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">placeholder<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>Username<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">id<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>username<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">required<\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>label <span class=\"token attr-name\">for<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>password<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>i <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>fas fa-lock<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>i<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>label<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>input <span class=\"token attr-name\">type<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>password<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">name<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>password<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">placeholder<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>Password<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">id<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>password<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">required<\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>input <span class=\"token attr-name\">type<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>submit<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">value<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>Login<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>form<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>div<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n\t<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>body<span class=\"token punctuation\">&gt;<\/span><\/span>\r\n<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>html<span class=\"token punctuation\">&gt;<\/span><\/span><\/code><\/pre>\n<p>If we navigate to the index page in our web browser, it will look like the following:<\/p>\n<div class=\"browser\">\n<div><span class=\"url\">http:\/\/localhost\/phplogin\/index.html<\/span><\/div>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/basic-html-login-form-layout.png?resize=750%2C489&#038;ssl=1\" alt=\"Basic HTML Login Form Layout\" width=\"750\" height=\"489\" data-recalc-dims=\"1\" \/><\/div>\n<p>Pretty basic right? Let&#8217;s edit our\u00a0<i>style.css<\/i>\u00a0file and implement code that will improve the appearance of the form.<\/p>\n<p>Add the following code to the\u00a0<i>style.css<\/i>\u00a0file:<\/p>\n<div class=\"code-header\"><\/div>\n<pre class=\" language-css\"><code class=\" language-css\"><span class=\"token selector\">* <\/span><span class=\"token punctuation\">{<\/span>\r\n  \t<span class=\"token property\">box-sizing<\/span><span class=\"token punctuation\">:<\/span> border-box<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">font-family<\/span><span class=\"token punctuation\">:<\/span> -apple-system, BlinkMacSystemFont, <span class=\"token string\">\"segoe ui\"<\/span>, roboto, oxygen, ubuntu, cantarell, <span class=\"token string\">\"fira sans\"<\/span>, <span class=\"token string\">\"droid sans\"<\/span>, <span class=\"token string\">\"helvetica neue\"<\/span>, Arial, sans-serif<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">font-size<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">16<\/span>px<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">-webkit-font-smoothing<\/span><span class=\"token punctuation\">:<\/span> antialiased<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">-moz-osx-font-smoothing<\/span><span class=\"token punctuation\">:<\/span> grayscale<span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token selector\">body <\/span><span class=\"token punctuation\">{<\/span>\r\n  \t<span class=\"token property\">background-color<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token hexcode\">#435165<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token selector\"><span class=\"token class\">.login<\/span> <\/span><span class=\"token punctuation\">{<\/span>\r\n  \t<span class=\"token property\">width<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">400<\/span>px<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">background-color<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token hexcode\">#ffffff<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">box-shadow<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span> <span class=\"token number\">0<\/span> <span class=\"token number\">9<\/span>px <span class=\"token number\">0<\/span> <span class=\"token function\">rgba<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span>, <span class=\"token number\">0<\/span>, <span class=\"token number\">0<\/span>, <span class=\"token number\">0.3<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">margin<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">100<\/span>px auto<span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token selector\"><span class=\"token class\">.login<\/span> h1 <\/span><span class=\"token punctuation\">{<\/span>\r\n  \t<span class=\"token property\">text-align<\/span><span class=\"token punctuation\">:<\/span> center<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">color<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token hexcode\">#5b6574<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">font-size<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">24<\/span>px<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">padding<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">20<\/span>px <span class=\"token number\">0<\/span> <span class=\"token number\">20<\/span>px <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">border-bottom<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span>px solid <span class=\"token hexcode\">#dee0e4<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token selector\"><span class=\"token class\">.login<\/span> form <\/span><span class=\"token punctuation\">{<\/span>\r\n  \t<span class=\"token property\">display<\/span><span class=\"token punctuation\">:<\/span> flex<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">flex-wrap<\/span><span class=\"token punctuation\">:<\/span> wrap<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">justify-content<\/span><span class=\"token punctuation\">:<\/span> center<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">padding-top<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">20<\/span>px<span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token selector\"><span class=\"token class\">.login<\/span> form label <\/span><span class=\"token punctuation\">{<\/span>\r\n  \t<span class=\"token property\">display<\/span><span class=\"token punctuation\">:<\/span> flex<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">justify-content<\/span><span class=\"token punctuation\">:<\/span> center<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">align-items<\/span><span class=\"token punctuation\">:<\/span> center<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">width<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">50<\/span>px<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">height<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">50<\/span>px<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">background-color<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token hexcode\">#3274d6<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">color<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token hexcode\">#ffffff<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token selector\"><span class=\"token class\">.login<\/span> form input<span class=\"token attribute\">[type=\"password\"]<\/span>, <span class=\"token class\">.login<\/span> form input<span class=\"token attribute\">[type=\"text\"]<\/span> <\/span><span class=\"token punctuation\">{<\/span>\r\n  \t<span class=\"token property\">width<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">310<\/span>px<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">height<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">50<\/span>px<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">border<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span>px solid <span class=\"token hexcode\">#dee0e4<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">margin-bottom<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">20<\/span>px<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">padding<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span> <span class=\"token number\">15<\/span>px<span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token selector\"><span class=\"token class\">.login<\/span> form input<span class=\"token attribute\">[type=\"submit\"]<\/span> <\/span><span class=\"token punctuation\">{<\/span>\r\n  \t<span class=\"token property\">width<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">100%<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">padding<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">15<\/span>px<span class=\"token punctuation\">;<\/span>\r\n \t<span class=\"token property\">margin-top<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">20<\/span>px<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">background-color<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token hexcode\">#3274d6<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">border<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">cursor<\/span><span class=\"token punctuation\">:<\/span> pointer<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">font-weight<\/span><span class=\"token punctuation\">:<\/span> bold<span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">color<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token hexcode\">#ffffff<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">transition<\/span><span class=\"token punctuation\">:<\/span> background-color <span class=\"token number\">0.2<\/span>s<span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token selector\"><span class=\"token class\">.login<\/span> form input<span class=\"token attribute\">[type=\"submit\"]<\/span><span class=\"token pseudo-class\">:hover<\/span> <\/span><span class=\"token punctuation\">{<\/span>\r\n\t<span class=\"token property\">background-color<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token hexcode\">#2868c7<\/span><span class=\"token punctuation\">;<\/span>\r\n  \t<span class=\"token property\">transition<\/span><span class=\"token punctuation\">:<\/span> background-color <span class=\"token number\">0.2<\/span>s<span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span><\/code><\/pre>\n<p>We need to include our stylesheet in our\u00a0<i>index.html<\/i>\u00a0file and therefore we must add the following code to the head section:<\/p>\n<pre class=\" language-html\"><code class=\" language-html\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>link <span class=\"token attr-name\">href<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>style.css<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">rel<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>stylesheet<span class=\"token punctuation\">\"<\/span><\/span> <span class=\"token attr-name\">type<\/span><span class=\"token attr-value\"><span class=\"token punctuation\">=<\/span><span class=\"token punctuation\">\"<\/span>text\/css<span class=\"token punctuation\">\"<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span><\/code><\/pre>\n<p>And now if we refresh the\u00a0<i>index.html<\/i>\u00a0page in our web browser, our login form will look more appealing:<\/p>\n<div class=\"browser\">\n<div><span class=\"url\">http:\/\/localhost\/phplogin\/index.html<\/span><\/div>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/awesome-html-login-form-layout.png?resize=750%2C489&#038;ssl=1\" alt=\"Awesome HTML Login Form Layout\" width=\"750\" height=\"489\" data-recalc-dims=\"1\" \/><\/div>\n<p>That looks much better! Let&#8217;s narrow down the form elements, so we can get a better understanding on what&#8217;s going on.<\/p>\n<ul>\n<li><b>Form<\/b>\u00a0\u2014 We need to use both the\u00a0<i class=\"hl\">action<\/i>\u00a0and\u00a0<i class=\"hl\">post<\/i>\u00a0attributes. The\u00a0<i class=\"hl\">action<\/i>\u00a0attribute will be set to the authentication file. When the form is submitted, the form data will be sent to the authentication file for processing. In addition, the\u00a0<i class=\"hl\">method<\/i>\u00a0is declared as\u00a0<i class=\"hl\">post<\/i>\u00a0as this will enable us to process the form data using the POST request method.\n<ul>\n<li><b>Input (text\/password)<\/b>\u00a0\u2014 We need to name our form fields so the server can recognize them. The value of the attribute\u00a0<i class=\"hl\">name<\/i>\u00a0we can declare as\u00a0<i class=\"hl\">username<\/i>, which we can use to retrieve the post variable in our authentication file to get the data, for example:\u00a0<i class=\"hl\">$_POST[&#8216;username&#8217;]<\/i>.<\/li>\n<li><b>Input (submit)<\/b>\u00a0\u2014 On form submission, the data will be sent to our authentication file for processing.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div data-counters='false' data-style='square' data-size='small' data-url='https:\/\/hostscripter.com\/?p=1331' data-title='Part 2: Create your own Login System using PHP and MySql' class='linksalpha_container linksalpha_app_3'><a href='\/\/www.linksalpha.com\/share?network='facebook' class='linksalpha_icon_facebook'><\/a><a href='\/\/www.linksalpha.com\/share?network='twitter' class='linksalpha_icon_twitter'><\/a><a href='\/\/www.linksalpha.com\/share?network='googleplus' class='linksalpha_icon_googleplus'><\/a><a href='\/\/www.linksalpha.com\/share?network='mail' class='linksalpha_icon_mail'><\/a><\/div><div data-position='' data-url='https:\/\/hostscripter.com\/?p=1331' data-title='Part 2: Create your own Login System using PHP and MySql' class='linksalpha_container linksalpha_app_7'><a href='\/\/www.linksalpha.com\/share?network='facebook' class='linksalpha_icon_facebook'><\/a><a href='\/\/www.linksalpha.com\/share?network='twitter' class='linksalpha_icon_twitter'><\/a><a href='\/\/www.linksalpha.com\/share?network='googleplus' class='linksalpha_icon_googleplus'><\/a><a href='\/\/www.linksalpha.com\/share?network='mail' class='linksalpha_icon_mail'><\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>2. Creating the Login Form Design We will now create a form that our users can use to enter their details and submit them for processing. We will be using [&hellip;]<\/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-lt","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1329,"url":"https:\/\/hostscripter.com\/?p=1329","url_meta":{"origin":1331,"position":0},"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 &quot;Blog&quot;","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":1343,"url":"https:\/\/hostscripter.com\/?p=1343","url_meta":{"origin":1331,"position":1},"title":"Part 1: Create your own Registration System using PHP and MySql","author":"h05t5cr1pt3r","date":"November 28, 2022","format":false,"excerpt":"This tutorial is a follow up to our previous tutorial\u00a0Secure Login System with PHP and MySQL. In this tutorial, we'll be creating a secure registration form and implementing basic validation. A registration form is what your website's visitors can use to register their details, which will subsequently be stored in\u2026","rel":"","context":"In &quot;Blog&quot;","block_context":{"text":"Blog","link":"https:\/\/hostscripter.com\/?cat=4"},"img":{"alt_text":"Secure Registration System with PHP and MySQL","src":"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/posts\/secure-registration-system-php-mysql.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/posts\/secure-registration-system-php-mysql.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/codeshack.io\/web\/img\/posts\/secure-registration-system-php-mysql.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/codeshack.io\/web\/img\/posts\/secure-registration-system-php-mysql.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1339,"url":"https:\/\/hostscripter.com\/?p=1339","url_meta":{"origin":1331,"position":2},"title":"Part 6: Create your own Login System using PHP and MySql","author":"h05t5cr1pt3r","date":"November 28, 2022","format":false,"excerpt":"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 sessions, so you should always start sessions using the below code. session_start(); \/\/ If the user is not logged in\u2026","rel":"","context":"In &quot;Blog&quot;","block_context":{"text":"Blog","link":"https:\/\/hostscripter.com\/?cat=4"},"img":{"alt_text":"PHP Loggedin Profile Page","src":"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/loggedin-profile-page.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/loggedin-profile-page.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/loggedin-profile-page.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/codeshack.io\/web\/img\/phplogin\/loggedin-profile-page.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1341,"url":"https:\/\/hostscripter.com\/?p=1341","url_meta":{"origin":1331,"position":3},"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: <?php session_start(); session_destroy(); \/\/ Redirect to the login page: header('Location: index.html'); ?> Initialize sessions, destroy them,\u2026","rel":"","context":"In &quot;Blog&quot;","block_context":{"text":"Blog","link":"https:\/\/hostscripter.com\/?cat=4"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1337,"url":"https:\/\/hostscripter.com\/?p=1337","url_meta":{"origin":1331,"position":4},"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 &quot;Blog&quot;","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":1354,"url":"https:\/\/hostscripter.com\/?p=1354","url_meta":{"origin":1331,"position":5},"title":"Part 6: Create your own Registration System using PHP and MySql","author":"h05t5cr1pt3r","date":"November 28, 2022","format":false,"excerpt":"6. Implementing Account Activation The account activation system will send an email to the user with the activation link when the user has registered. The first thing we need to do is to go into\u00a0phpMyAdmin\u00a0and select our database, in our case this would be\u00a0phplogin, you can either add the column\u00a0activation_code\u00a0to\u2026","rel":"","context":"In &quot;Blog&quot;","block_context":{"text":"Blog","link":"https:\/\/hostscripter.com\/?cat=4"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/hostscripter.com\/index.php?rest_route=\/wp\/v2\/posts\/1331"}],"collection":[{"href":"https:\/\/hostscripter.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostscripter.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostscripter.com\/index.php?rest_route=\/wp\/v2\/users\/301"}],"replies":[{"embeddable":true,"href":"https:\/\/hostscripter.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1331"}],"version-history":[{"count":1,"href":"https:\/\/hostscripter.com\/index.php?rest_route=\/wp\/v2\/posts\/1331\/revisions"}],"predecessor-version":[{"id":1332,"href":"https:\/\/hostscripter.com\/index.php?rest_route=\/wp\/v2\/posts\/1331\/revisions\/1332"}],"wp:attachment":[{"href":"https:\/\/hostscripter.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostscripter.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostscripter.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}