mysqli_fetch_result-2.php : mysqli « MySQL Database « PHP






  1. PHP
  2. MySQL Database
  3. mysqli

mysqli_fetch_result-2.php

 
<?php

$query = "SELECT productid, name, price FROM product ORDER BY name";
$result = $mysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_NUM))
{
   $productid = $row[0];
   $name = $row[1];
   $price = $row[2];
   echo "($productid) $name: $price <br />";
}

?>








Related examples in the same category

1.Multiple Queries Using MySQLi
2.Parameter Binding in MySQLi
3.Use mysqli to fetch data from mysql
4.Using the mysqli Object-Oriented API
5.Using the Object-Oriented Syntax in MySQLi
6.mysqli_fetch_object.php
7.mysqli_fetch_result.php
8.mysqli_fetch_row.php
9.mysqli_free_result.php
10.mysqli_multi_query.php
11.mysqli_stmt_prepare.php
12.mysqli_store_result.php
13.retrieving_multiple_rows.php