How send data from database to html?

Hello @Sign,

It is simple to create contact form to send email or any other information  and storing in mysql database.

Using INSERT INTO statement you can insert new data into a database table.

See the example below:

Output:

Step 1: Connection with Database

This is dbConn.php file which is used to connect the database.

This dbConn.php file will use everywhere, where you want to perform a task with the database.

Here it is connected with the local database and check database connected or not.

dbConn.php

Step 2: Creating HTML form and inserting data

Here's a simple HTML form which is index.php file. It has two text input and a submit button.

The INSERT INTO statement is used to add new data into the database. This insert query will execute passing through to the PHP mysqli_query() function to insert new data.

And also created a simple HTML form which has two input text and a submit button which is used to take data from users.

In the index.php file the dbConn.php file includes for connecting with the database and insert new data. The form has two field fullname and age which are get data from users and store into the database.

In this example the PHP code and the HTML form coded in the single page. The PHP script embedded with the HTML page.

index.php

  





Fill the Form


  Full Name : 
  

  Age : 
  

  

Write PHP code as a separate file

Step 1: Creating HTML Form

First of all creating HTML form which is index.php file. This form has two text boxes and a submit button for inserting data.

This form also has an action attribute which contains insert.php. This will perform when clicking on submit button.

index.php

  




  Full Name : 
  

  Age : 
  

  

Step 2: Connection with Database

This is dbConn.php file which connects the database.

dbConn.php

Step 3: Write PHP code for insert data

This is insert.php file. Here is written PHP code for inserting data when clicking on submit button.

insert.php

Hope it helps!!
Thank you!

Moving information from an HTML form into a database is a two-step design process. First, create an entry HTML form capable of passing information to a secondary file. Next, create a Hypertext Preprocessor (PHP) file to accept the data and insert it into the database.

HTML is only capable of instructing a browser on the method of presenting information. The transactions needed to store information in the database require Structured Query Language (SQL) commands placed inside a PHP script.

HTML

1. Create a Form on the Appropriate Page

2. Create a form on the appropriate page including the “action” and “method” attributes in the form definition tag as follows:

4. The “action” attribute tells the form to send the data to a script named “info.php,” and “method” describes the type of action to be performed once the information is passed to the script.

5. Define Input Fields

6. Define the input fields along with the data types to be passed to the database. For example:

7. Username: Email:

8. Together, these tags pass two text strings named “username” and “email” to the PHP script.

9. Create Submit Button

10. Provide the user with a way to initiate the transaction with the tag:

12. This displays a “submit” button at the bottom of the form that triggers the database transaction.

PHP

1. Create a File

2. Create a file named “info.php.” Any file name can be used as long as it matches the name specified by the form's “action” attribute and ends with the .php extension.

3. Connect to Database

4. Open the PHP script and connect to the database with the statements:

6. $connect = mysql_connect(“server_name”, “admin_name”, “password”); if (!connect) { die('Connection Failed: ' . mysql_error()); { mysql_select_db(“database_name”, $connect);

7. The first line assigns the value returned by the “mysql_connect” function, used to initialize and validate the database connection, to the “$connect” variable. The “if” statement terminates communication with the database if the connection is not accepted. The final line selects the database specified in “database_name” and signs in with the username and password specified in the first line.

8. Insert Information into the Database

9. Insert the information into the database with the commands:

10. $user_info = “INSERT INTO table_name (username, email) VALUES ('$_POST[username]', '$_POST[email]')”; if (!mysql_query($user_info, $connect)) { die('Error: ' . mysql_error()); }

11. echo “Your information was added to the database.”;

12. mysql_close($connect); ?>

13. In the first line, the SQL statement used to insert the information in the database table “table_name” is passed to the variable “$user_info.” The following “if” statement verifies the connection to the proper table, inserts the data contained in “$user_info into the table. If the transaction can't be completed, an error message is generated and the connection is closed. The “echo” statement appears only if the information is successfully saved. Finally, calling “mysql_close” closes the database connection.

Tip

You must create the database and tables before passing data to them. The table's field names must match the names of the variables passed by the “$_POST[xxxxx]” global variables.

Can I connect database to HTML?

How show data from database in HTML?

How fetch data from SQL to HTML?