1 $q = "SELECT Pro_ID, Pro_Name FROM products";
 2 $result = mysqli_query($dbcon, $q);
 3 
 4 echo "<table>";
 5 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 6  echo "<tr>
 7  <td>" . $row['Pro_ID'] . "</td>
 8  <td>" . $row['Pro_Name'] . "</td>
 9  </tr>";
10  }
11 echo "</table>";

 1 <?php
 2 $link = mysqli_connect("localhost", "root", "", "ickshop");
 3 
 4 if (!$link) {
 5 $error = mysqli_connect_error();
 6 $errno = mysqli_connect_errno();
 7 print "$errno: $error\n";
 8 exit();
 9 }
10 
11 $query = "SELECT * FROM products WHERE Pro_Cat_ID=?";
12 
13 $stmt = mysqli_stmt_init($link);
14 if (!mysqli_stmt_prepare($stmt, $query)) {
15 print "Failed to prepare statement\n";
16 } else {
17 $category = "1";
18 mysqli_stmt_bind_param($stmt, "i", $category);
19 // i - integer
20 // d - double
21 // s - string
22 // b - blob
23 
24 
25 mysqli_stmt_execute($stmt);
26 $result = mysqli_stmt_get_result($stmt);
27 
28 echo "<table>";
29 while ($row = mysqli_fetch_assoc($result)) {
30 
31 echo "<tr>
32 <td>" . $row['Pro_ID'] . "</td>
33 <td>" . $row['Pro_Name'] . "</td></tr>";
34 
35 }
36 echo "</table>";
37 }
38 
39 mysqli_stmt_close($stmt);
40 mysqli_close($link);
41 ?>