How to insert form data into MYSQL database using PHP | PHP Lecture 15 | How to do this

Insert Form data into MYSQL database using php, SQL query for inserting data, INSERT INTO query in SQL
#InsertFormDataIntoMYSQLDatabaseUsingPHP,#SQL,#HowToDoThis


For further discussion join us on Facebook:---
https://web.facebook.com/groups/1184520091737540/


Insert Data Into MySQL Using MySQLi:

After a database and a table have been created, we can start adding data in them.

Here are some syntax rules to follow:

The SQL query must be quoted in PHP
String values inside the SQL query must be quoted
Numeric values must not be quoted
The word NULL must not be quoted

The INSERT INTO statement is used to add new records to a MySQL table:


INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)



Inserting Multiple Rows into a Table:


You can also insert multiple rows into a table with a single insert query at once. To do this, include multiple lists of column values within the INSERT INTO statement, where column values for each row must be enclosed within parentheses and separated by a comma.





Insert Data into a Database from an HTML Form:

In the previous section, we have learned how to insert data into database from a PHP script. Now, we'll see how we can insert data into database obtained from an HTML form. Let's create an HTML form that can be used to insert new records to persons table.