Welcome to Smarter QA, Questions, Answers Community
Welcome to Smarter QA, where you can ask questions and receive answers from other members of the community. Ask anything that you want. Guests Posting are allowed.
+2 votes
27 views
asked in PHP by (1.1k points)

1 Answer

0 votes

PHP code for inserting data into the database from the form.

You can insert the data into the database from the HTML form using PHP. Insert operation is executed by the insert query of MYSQL. You need to know about the MySQL insert query. How to work insert query and how exactly target the table where we want to insert out HTML form data.  You have to need focus on the MYSQL queries. After that move on PHP. PHP helps to connect the HTML form to the database. Without PHP you can not perform the insert operation. 

1. First of creating a database  XYZ etc. 

2. Create a table for insert the data. 

3. After that create an HTML form. Decide your form fields. How much fields you have to need to insert into the database. 

Like - 

Name 

Address. 

Mobile no 

Password etc

4. Now your HTML code (form) is ready. You need to create a PHP code for insert the data into the database.

PHP code for inserting data into the database - 

Create a PHP code for insert the data into the database using MYSQL query. 

1.Create a connection 

$cser=mysqli_connect("localhost","root","","dbname") or die("connection failed:".mysqli_error());

Your server address - localhost 

username - root

password - null (default password is empty ) 

database - dbname . 

2.PHP  insert query.

 

$result = mysqli_query($cser, "INSERT INTO tablename(name,email,address) VALUES('$name','$email','$address')");

As you know that insert operation required insert query. 

INSERT INTO tablename(name,email,address) VALUES('$name','$email','$address')

INSERT Into "table name " 

name, email, the address HTML form fields. 

PHP code for inserting data into database from form

answered by (800 points)
...