Breaking News: Grepper is joining You.com. Read the official announcement!

display data from sql database with php

Add Answer

Asim Nizam answered on February 6, 2021 Popularity 9/10 Helpfulness 5/10

answer display data from sql database with php

related how to display data from mysql database into html table using php

related how to display sql database data in php

related display data from database in a table in php

display data from sql database with php

Comment

<?php
$host = "127.0.0.1"; //IP of your database
$userName = "root"; //Username for database login
$userPass = ""; //Password associated with the username
$database = "example-database"; //Your database name

$connectQuery = mysqli_connect($host,$userName,$userPass,$database);

if(mysqli_connect_errno()){
    echo mysqli_connect_error();
    exit();
}else{
    $selectQuery = "SELECT * FROM `tbl_users` ORDER BY `user_id` ASC";
    $result = mysqli_query($connectQuery,$selectQuery);
    if(mysqli_num_rows($result) > 0){
    }else{
        $msg = "No Record found";
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>HTML and PHP code</title>
</head>
<body>
    <h1>Display user list using HTML and PHP</h1>
    <?=$msg;?>
    <table border="1px" style="width:600px; line-height:40px;">
        <thead>
            <tr>
                <th>Name</th>
                <th>Email</th>
                <th>Status</th>
                <th>Registrating Date</th>
            </tr>
        </thead>
        <tbody>
            <?php
                while($row = mysqli_fetch_assoc($result)){?>
                <tr>
                    <td><?php echo $row['user_firstName'].$row['user_lastName']; ?></td>
                    <td><?php echo $row['user_email']; ?></td>
                    <td><?php if($row['user_status'] == 1){
                        echo "Active";
                    }else{
                        echo "Deactive";
                    } ?></td>
                    <td><?php echo $row['user_registrationDate']; ?></td>
                <tr>
            <?}?>
        </tbody>
    </table>
</body>
</html>

Popularity 9/10 Helpfulness 5/10 Language php

Source: www.stechies.com

Tags: database display php sql

Link to this answer
Share Copy Link

Contributed on Nov 09 2022

Asim Nizam

0 Answers Avg Quality 2/10

Closely Related Answers

how to display data from mysql database into html table using php

Comment

<?php
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM Persons");

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['FirstName'] . "</td>";
echo "<td>" . $row['LastName'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysqli_close($con);
?>

Popularity 10/10 Helpfulness 7/10 Language php

Source: stackoverflow.com

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Feb 06 2021

Tamer Jarrar

0 Answers Avg Quality 2/10

how to display sql database data in php

Comment

<?php
    $dbServername = "localhost";
    $dbUsername = "root";
    $dbPassword = "";
    $dbName = "dbname";
    
    $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
	
    $sql = "SELECT * FROM dbname;";
    $result = mysqli_query($conn, $sql);
    $resultCheck = mysqli_num_rows($result);

    if ($resultCheck > 0) {
      while ($row = mysqli_fetch_assoc($result)) {
        echo $row['sql_row_name'] . "<br>";
      }
    }
?>

Popularity 10/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: connect

Link to this answer
Share Copy Link

Contributed on Aug 10 2022

Beautiful Batfish

0 Answers Avg Quality 2/10

display data from database in a table in php

Comment

<?php if ( ! empty($products)) : ?>
    <table>
    <thead>
        <tr>
            <th>Name</th>
            <th>Description</th>
            <th>Price</th>
            <th>CategoryID</th>
            <th>Created</th>
        </tr>
    </thead>

    <?php foreach ($products as $product) : ?>
        <tr>
            <td><?php $product['name'] ?></td>
            <td><?php $product['description'] ?></td>
            <td><?php $product['price'] ?></td>
            <td><?php $product['CategoryID'] ?></td>
            <td><?php $product['created'] ?></td>
        </tr>
    <?php endforeach; ?>
    </table>
<?php endif; ?>

Popularity 9/10 Helpfulness 3/10 Language php

Source: stackoverflow.com

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Nov 29 2022

Dream's Hadling

0 Answers Avg Quality 2/10

display data from sql database with php

Contents

More Related Answers

display data from sql database with php

Closely Related Answers

how to display data from mysql database into html table using php

how to display sql database data in php

display data from database in a table in php

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.