{"id":1352,"date":"2022-11-28T09:07:14","date_gmt":"2022-11-28T01:07:14","guid":{"rendered":"https:\/\/hostscripter.com\/?p=1352"},"modified":"2022-11-28T09:07:14","modified_gmt":"2022-11-28T01:07:14","slug":"part-5-create-your-own-registration-system-using-php-and-mysql","status":"publish","type":"post","link":"https:\/\/hostscripter.com\/?p=1352","title":{"rendered":"Part 5: Create your own Registration System using PHP and MySql"},"content":{"rendered":"

5. Validating Form Data<\/h2>\n

We already have basic validation in our PHP script but what if we want to check if the email is actually an email or if the username and password should be a certain amount of characters long, you can do that with the codes below, add them in the\u00a0register.php<\/i>\u00a0file before the following line:<\/p>\n

if<\/span> (<\/span>$stmt<\/span> =<\/span> $con<\/span>-<\/span>><\/span>prepare<\/span>(<\/span>'SELECT id, password FROM accounts WHERE username = ?'<\/span>)<\/span>)<\/span> {<\/span><\/code><\/pre>\n
 <\/p>\n
Email Validation<\/h3>\n
<\/div>\n
if<\/span> (<\/span>!<\/span>filter_var<\/span>(<\/span>$_POST<\/span>[<\/span>'email'<\/span>]<\/span>,<\/span> FILTER_VALIDATE_EMAIL<\/span>)<\/span>)<\/span> {<\/span>\r\n\texit<\/span>(<\/span>'Email is not valid!'<\/span>)<\/span>;<\/span>\r\n}<\/span><\/code><\/pre>\n
 <\/p>\n
Invalid Characters Validation<\/h3>\n
<\/div>\n
if<\/span> (<\/span>preg_match<\/span>(<\/span>'\/^[a-zA-Z0-9]+$\/'<\/span>,<\/span> $_POST<\/span>[<\/span>'username'<\/span>]<\/span>)<\/span> ==<\/span> 0<\/span>)<\/span> {<\/span>\r\n    exit<\/span>(<\/span>'Username is not valid!'<\/span>)<\/span>;<\/span>\r\n}<\/span><\/code><\/pre>\n
 <\/p>\n
Character Length Check<\/h3>\n
<\/div>\n
if<\/span> (<\/span>strlen<\/span>(<\/span>$_POST<\/span>[<\/span>'password'<\/span>]<\/span>)<\/span> ><\/span> 20<\/span> ||<\/span> strlen<\/span>(<\/span>$_POST<\/span>[<\/span>'password'<\/span>]<\/span>)<\/span> <<\/span> 5<\/span>)<\/span> {<\/span>\r\n\texit<\/span>(<\/span>'Password must be between 5 and 20 characters long!'<\/span>)<\/span>;<\/span>\r\n}<\/span><\/code><\/pre>\n
You should always implement your own validation, these are just basic examples.<\/p>\n
<\/a><\/a><\/a><\/a><\/div>
<\/a><\/a><\/a><\/a><\/div>","protected":false},"excerpt":{"rendered":"
5. Validating Form Data We already have basic validation in our PHP script but what if we want to check if the email is actually an email or if the […]<\/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-lO","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1349,"url":"https:\/\/hostscripter.com\/?p=1349","url_meta":{"origin":1352,"position":0},"title":"Part 4: Create your own Registration System using PHP and MySql","author":"h05t5cr1pt3r","date":"November 28, 2022","format":false,"excerpt":"4. Registering Users with PHP & MySQL Now we need to create the registration file that will process the form fields, check for basic validation, and insert the new account into our database. The registration page will require a connection to our database and therefore we must include the necessary\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":1354,"url":"https:\/\/hostscripter.com\/?p=1354","url_meta":{"origin":1352,"position":1},"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 "Blog"","block_context":{"text":"Blog","link":"https:\/\/hostscripter.com\/?cat=4"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1343,"url":"https:\/\/hostscripter.com\/?p=1343","url_meta":{"origin":1352,"position":2},"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 "Blog"","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":1335,"url":"https:\/\/hostscripter.com\/?p=1335","url_meta":{"origin":1352,"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: