$db = new DB();
$result=$db->query("SELECT * FROM `products`");
$numrows=$db->get_num_rows($result);
$rows=$db->fetch_assoc_row($result);

foreach($rows as $row=>$values) {
    $product_id=$values['product_id'];
    $p = new Product($product_id); 
    echo $p->getTitle();
    echo "<br />";
}

$db->sql_close();