Use mysqli to fetch data from mysql : mysqli « MySQL Database « PHP

1. PHP
2. MySQL Database
3. mysqli

Use mysqli to fetch data from mysql

 
<?php

   $mysqli = new mysqli("127.0.0.1", "root","", "mydatabase");
   $query = "SELECT productid, name, price, description FROM product ORDER BY productid";

   $stmt = $mysqli->prepare($query);

   $stmt->execute();

   $stmt->bind_result($productid, $name, $price, $description);

   while($stmt->fetch()) {
      echo "$productid, $name, $price, $description <br />";
   }
   $stmt->close();
   $mysqli->close();

?>
  
  

Related examples in the same category