December 23, 2017 / Comments: 0

How to reset a password using PHP and MYSQL?

Create a password reset using PHP and MYSQL So in this tutorial, which will basically be a follow up to how to create a registration form, we will take a look at how to reset a password from already defined MYSQL table called sql_users. For this purpose, another table will be added that will handle password reset tokens which will only be active for 12 hours or...

Tags: php  mysql  html  

December 15, 2017 / Comments: 0

How to create PHP registration form with email activation?

PHP registration form with email confirmation A time comes when a project requires more than just one time user that will be managing a blog or a website so, for this purpose alone, we will be looking at how to create a simple registration form using PHP and MYSQL. To protect against spam user creation, I'll include the captcha condition that anyone using the...

Tags: php  mysql  html  

November 30, 2017 / Comments: 0

How to create ADD, EDIT, DELETE system using PHP?

PHP and MYSQL event(ADD/EDIT/DELETE) system In this tutorial we will take a look at how to create a basic event system using PHP and MYSQL. The system will have an option to add, edit and delete events as desired. It will contain two files, one for manipulating events and the other to display the output. The former I will name addeditdel.php and the latter...

Tags: php  mysql  html  css  

October 13, 2017 / Comments: 0

Shell script - PHP and MYSQL login system addendum

Shell script to keep tabs on MYSQL database In previous post, we've taken a closer look at how to create PHP and MYSQL login system that collects attempt and ban data and compares a user's IP against it to see whether the IP is banned or not. While the system works like it is supposed to, the data collected in the login_attempts and login_banned tables becomes...

Tags: bash  mysql  logging  

October 12, 2017 / Comments: 0

How to create a login system using PHP and MYSQL?

PHP and MYSQL login system using PBKDF2 Today we are going to create a secure login system using PHP and MYSQL. It will use PBDKF2 hashing method with username as a salt and 100k iteration rounds to authenticate the user. Another feature we will make is to count login attempts and ban the ip address for 10 minutes after a few unsuccessful attempts. We will use...

Tags: php  mysql  sessions  hashing  

September 14, 2017 / Comments: 0

How to connect to MYSQL database?

How to connect to MYSQL database? This tutorial will contain information about how to connect to MYSQL database using different programming languages and different techniques. In the first part, we will take a look at PHP mysqli, both procedural and object-oriented programming(OOP) methods and PDO(OOP only) and its prepared statements. In the second part, we'll...

Tags: mysql  php  bash  python