File HF

//The file I make the function call from.
ini_set('memory_limit', '-1');
$query = "SELECT * FROM products WHERE api=1";

if ($stmt = mysqli_prepare($link, $query)) {

    $stmt->execute();

    $row = array();
    stmt_bind_assoc($stmt, $row);
    $i = 0;
    // loop through all result rows
    while ($stmt->fetch()) {
          $i++;
          echo("RESULTS");
    }
}