Creating a Simple Registration Using MySQLi Prepared Statement

In this tutorial, we will create a simple registration form using MySQLi prepared statement. it is an advanced and secured kind of script to prevent MySQL injection threat. Due to depreciated of MySQL most of the website are required to use MySQL / PDO statement. Now be prepared, let's start coding 1. We open the database server, then type localhost/phpmyadmin 2. Then name the database "sample" 3. After creating the database, click SQL and paste the code below Creating HTML form After setting up the database, we will create the HTML form, The code below will display a simple registration form. To create a form, open any kind of text editor (notepad++, etc.). Then copy the code below, paste it inside the body tag, name it "index.php" Then, we will add some design for the form, just copy and paste it inside the head tag Next, we will create the database connection, just copy the code below, then name it "connect.php" Lastly, we will now create the script for saving the data from the HTML form. The code below holds the data that has been input in the HTML form, then it will directly send to database server. Just copy the code below, then name it "submit_query.php" There you have it, we created a simple registration form. I hope that this tutorial help you to your projects. For more tutorials and updates, just kindly visit this site. Enjoy Coding!!!