How to Insert any value in php database by using form in php mysqli ?

Step 1 : Creating a table

First of all, we have to create a table for your data. It is a very simple procedure that you can do with phpMyAdmin, which is located your hosting control panel.

After entering your phpMyAdmin page, you should see something similar to this:

We will create a table named signup for our database phpcodes. You can create a new table by clicking Create Table button. After that, you will see this new page where you can enter all the needed information for your table:
Step 2 : Writing PHP code to INSERT data into MySQLI database
MYSQLI Connectivity Code
Now , We can proceed with the SQL query INSERT
This is the most important line of our code, it does everything we want to learn in this tutorial – inserts data into MySQL database. The INSERT INTO is a statement which adds data into the specified database table. In our example, we are adding data to the table signup.

Going further, between the brackets, we have table columns specified to which we want to add the values: (name,email,password,mobile). Data will be added in the specified order.