It's very important to secure your login system which can be attacked by various attacking methode. SQL Injection is the common attacking methode that is used to gain the login authetication of the login system.
One of the most common SQL Injection look like this:
' or '1'='1' --
It's very unsecured to use the simple login verification methode to login in your system while currently most online web login system use the more secured way of login.
This tutorial will help to secure your login sytem by just implementing the mysqli_prepare to your login function.
Are you finding a way to get your utf8 characters displayed in your website content?
Actually, there are many languages that use uft8 characters while some others use the alphabet/Latin characters. This PHP function will help you to query your utf8 database contents to your website.
However, there are two functions you can see here: standard query named exec_query() and utf8 query named exec_query_utf8().
This PHP functions will help you to encrypt and decrypt your string to the complex code that no one can understand the original string.
For the security reason, this function should be used to encode your secret data to the unreadable string. However, we might know the MD5 or SHA which is the popular PHP built-in encrypting function and cannot be decrypted in the previous time. Now, MD5 is already cracked down with some online website or library that can do that job well.
Now, we introduce you the hand-made functions that is reliable and secured enough to work with your project. So, now let's see how it works.
This is the technique to check our data input whether they are changed or not before sending them to the database via ajax.
This function will help you to save your ajax request time if there is nothing changed in your data input. So, when you did not change anything in your form input, this function will check and return you back an value (true/false). In this case, if you can stop your ajax requesting to update the exactly the same data to your database.
For more detail, please see the bellow instruction.