/PHP/How to fetch data from database in php

How to fetch data from database in php

Query sql in php

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close();

How to fetch data from database in php

  <?php
   //////neha jaiswal////
       include 'config.php';////incluude data base connection file
        $stmt = $conn->prepare('SELECT * FROM `product`');///select all data from database
        $stmt->execute();////query execute ($stmt)
        $result = $stmt->get_result();
        while ($row = $result->fetch_assoc()):
      ?>
         <div class="card p-2 border-secondary mb-2">
            <img src="<?= $row['product_image'] ?>" class="card-img-top" height="250">
            <div class="card-body p-1">
              <h4 class="card-title text-center text-info"><?= $row['product_name'] ?></h4>
              <h5 class="card-text text-center text-danger"><i class="fas fa-rupee-sign"></i><?= number_format($row['product_price'],2) ?>/-</h5>

-2

Similar codes

0 vote227 views1 answer
Blocked token vs expired token
PHP
0 vote215 views1 answer
Print prety php
PHP
11 votes225 views6 answers
How to print on python
PHP
0 vote264 views1 answer
Debugbar:clear in laravel
PHP Laravel
2 votes236 views1 answer
Redirect on validation error laravel to specific section laravel
PHP
13 votes225 views5 answers
Laravel validation custom message example
PHP
17 votes290 views3 answers
Debug wordpress
PHP Wordpress
0 vote241 views2 answers
Array collapse laravel
PHP Laravel
2 votes245 views3 answers
Laravel auth check login
PHP Laravel
0 vote173 views3 answers
Laravel collection sort
PHP