mysql_query.php : mysql_query « MySQL Database « PHP

1. PHP
2. MySQL Database
3. mysql_query

mysql_query.php

 
<?php

   $mysqli = new mysqli("127.0.0.1", "root","", "mydatabase");

   $query = "SELECT productid, name, price FROM product ORDER by name";
   $result = $mysqli->query($query, MYSQLI_STORE_RESULT);

   while(list($productid, $name, $price) = $result->fetch_row())
      echo "($productid) $name: $price <br />";

   $result->free();

?>
  
  

Related examples in the same category