How to Connect HTML Form with MySQL Database using PHP

——————————————————————————–
https://www.youtube.com/embed/2HVKizgcfjo

In this video you will learn How to store form data into the database
First of all to send the form data into the database we need a server side programming language which will take form data and that program will make a connection with database and then using sql insert query will store the form data into database.
Here I have used php as a server side programming language and MySQL as a database
To Send The form data to server side php file we have to specify php file name inside the form tag using action attribute so this php file will execute when we will submit this form

we have two different method to send the data to sever GET or POST post method is more secure way to send data to the server side

In php to get the data which is send from client side we have to use appropriate global variable if client send data using post method then we have to use $_POST if client has send using GET method then we have to use $_GET variable to get that data

after getting the data at server side We have to do a Connection with the database. PHP provide the Full support and method to do MySQL database connection in php

Prepare method save your query from sql injection

prepare method provide the binding mechanism to bind the data at run time not at compile time

#HTML_Form #MySQL #PHP

-~-~~-~~~-~~-~-
Please watch: “MySQL Database connection in java 12 using eclipse 2019”

-~-~~-~~~-~~-~-