PHP MySQLi prepared statement select multiple rows

<?php
function getData()
{
   $parameters = array();
   $arr_results = array();
 
   $db = new mysqli('localhost', 'root', '', 'database') or die('Database connection failed');
   $stmt = $db->prepare('SELECT name,details FROM products') or die('Something wrong with prepare query');
   $stmt->execute();
 
   $meta = $stmt->result_metadata();
 
   while ( $rows = $meta->fetch_field() ) {
 
     $parameters[] = &$row[$rows->name]; 
   }
 
   call_user_func_array(array($stmt, 'bind_result'), $parameters);
 
   while ( $stmt->fetch() ) {
      $x = array();
      foreach( $row as $key => $val ) {
         $x[$key] = $val;
      }
      $arr_results[] = $x;
   }
 
   return $arr_results; 
}
 
$arr_results = getData();
?>
<table>
<tr>
<th>Name</th>
<th>Details</th>
</tr>
<?php foreach ($arr_results as $row) : ?>
 <tr>
 <td><?php echo $row['name']; ?></td>
 <td><?php echo $row['details']; ?></td>
 </tr>
<?php endforeach; ?>
</table>

<?php
function getData()
{
   $parameters = array();
   $arr_results = array();
 
   $db = new mysqli('localhost', 'root', '', 'database') or die('Database connection failed');
   $stmt = $db->prepare('SELECT name,details FROM products') or die('Something wrong with prepare query');
   $stmt->execute();
 
   $meta = $stmt->result_metadata();
 
   while ( $rows = $meta->fetch_field() ) {
 
     $parameters[] = &$row[$rows->name]; 
   }
 
   call_user_func_array(array($stmt, 'bind_result'), $parameters);
 
   while ( $stmt->fetch() ) {
      $x = array();
      foreach( $row as $key => $val ) {
         $x[$key] = $val;
      }
      $arr_results[] = $x;
   }
 
   return $arr_results; 
}
 
$arr_results = getData();
?>
<table>
<tr>
<th>Name</th>
<th>Details</th>
</tr>
<?php foreach ($arr_results as $row) : ?>
 <tr>
 <td><?php echo $row['name']; ?></td>
 <td><?php echo $row['details']; ?></td>
 </tr>
<?php endforeach; ?>
</table>

<?php
$db = new mysqli('localhost','root','','database_name');
if ($db->connect_error) {
    die('Error : ('. $db->connect_errno .') '. $db->connect_error);
}
$results = $db->query("SELECT COUNT(*) FROM products");
$total_records = $results->fetch_row();
$db->close();
?>

<?php

$db = new mysqli('localhost','root','','database_name');
if ($db->connect_error) {
    die('Error : ('. $db->connect_errno .') '. $db->connect_error);
}
$results = $db->query("SELECT COUNT(*) FROM products");
$total_records = $results->fetch_row();
$db->close();
?>

<?php
$db = new mysqli('host','username','password','database');
// if connection failed
if ($db->connect_error) {
    die('Error : ('. $db->connect_errno .') '. $db->connect_error);
}
//Select Query
$results = $db->query("SELECT id, name, details FROM products");
echo '<table border="1">';
while($row = $results->fetch_array()) {
    echo '<tr>';
    echo '<td>'.$row["id"].'</td>';
    echo '<td>'.$row["name"].'</td>';
    echo '<td>'.$row["details"].'</td>';
    echo '</tr>';
}   
echo '</table>';
// close connection 
$db->close();
?>

<?php
$db = new mysqli('host','username','password','database');

// if connection failed
if ($db->connect_error) {
    die('Error : ('. $db->connect_errno .') '. $db->connect_error);
}
//Select Query
$results = $db->query("SELECT id, name, details FROM products");
echo '<table border="1">';
while($row = $results->fetch_array()) {
    echo '<tr>';
    echo '<td>'.$row["id"].'</td>';
    echo '<td>'.$row["name"].'</td>';
    echo '<td>'.$row["details"].'</td>';
    echo '</tr>';
}   
echo '</table>';
// close connection 
$db->close();
?>