TechieClues TechieClues
Updated date Aug 10, 2023
In this article, we will explore how to display data in an HTML table using PHP. This step-by-step tutorial covers creating a MySQL query, writing PHP code to generate an HTML table, and populating it with data from a database.
  • 4.2k
  • 0
  • 0

Download File(s):

PHPHtmlTable.zip

Introduction:

HTML tables are a powerful tool for organizing and presenting data on web pages. When combined with PHP, you can dynamically generate tables and populate them with data from a MySQL database. In this article, we will walk through the process of creating an HTML table using PHP and MySQL, step by step.

Step 1: MySQL Query Creation

Before we start displaying data in an HTML table, we need to establish a connection to the MySQL database and retrieve the necessary data using SQL queries. 

We have a table named "users" with columns such as "id", "name," and "email."

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL
);

Insert some sample records into the table for testing.

Step 2: Create PHP files

 Create a file "index.php" and insert the below code,

<!DOCTYPE html>
<html>
<head>
    <title>Users Table</title>
    <style>
        table {
            border-collapse: collapse;
            width: 100%;
        }

        th, td {
            padding: 8px;
            text-align: left;
            border-bottom: 1px solid #ddd;
        }
    </style>
</head>
<body>
    <h2>Users Table</h2>
    <?php include 'display_data.php'; ?>
</body>
</html>

Create a file called "display_data.php" and insert the code as shown below,

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "phpsamples";

// Create a connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check the connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// SQL query to retrieve users data
$sql = "SELECT * FROM users";

// Execute the query
$result = $conn->query($sql);

// Close the connection
$conn->close();
?>

<?php if ($result->num_rows > 0): ?>
    <table>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Email</th>
        </tr>
        <?php while ($row = $result->fetch_assoc()): ?>
            <tr>
                <td><?php echo $row["id"]; ?></td>
                <td><?php echo $row["name"]; ?></td>
                <td><?php echo $row["email"]; ?></td>
            </tr>
        <?php endwhile; ?>
    </table>
<?php else: ?>
    <p>No users found.</p>
<?php endif; ?>

In this example, we assume there is a MySQL database with a table named users that contains columns for id, name, and email. Make sure to replace your_username, your_password, your_database, and users with your actual database credentials and table name in the PHP code.

When you run the PHP file (index.php) in a web browser, the PHP code will execute, establish a connection to the database, retrieve the user data, and generate an HTML table dynamically. If no users are found, it will display a "No users found" message.

Step 3: Test the Application

To test the application and see the output, follow these steps:

Start your local development server (e.g., Apache in XAMPP). Open a web browser and navigate to the project e.g. http://localhost:8080/PHPHtmlTable/index.php.

If everything is set up correctly, when you access the "index.php" file through a web browser, you will see an HTML table displaying the user data retrieved from the database. The table will have columns for ID, name, and email, and each row will represent a user record.

Conclusion:

In this article, we have learned how to display data with an HTML table in PHP. By connecting to a MySQL database, executing SQL queries, and using PHP to generate HTML code, we can dynamically present data in a tabular format. This approach allows for flexibility in displaying data from various database tables and is widely used in web development.

ABOUT THE AUTHOR

TechieClues
TechieClues

I specialize in creating and sharing insightful content encompassing various programming languages and technologies. My expertise extends to Python, PHP, Java, ... For more detailed information, please check out the user profile

https://www.techieclues.com/profile/techieclues

Comments (0)

There are no comments. Be the first to comment!!!