prepare('SELECT * FROM products ORDER BY ID ASC LIMIT ?,?'); // bindValue will allow us to use integer in the SQL statement, we need to use for LIMIT $stmt->bindValue(1, ($current_page - 1) * $num_products_on_each_page, PDO::PARAM_INT); $stmt->bindValue(2, $num_products_on_each_page, PDO::PARAM_INT); $stmt->execute(); // Fetch the products from the database and return the result as an Array $products = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get the total number of products $total_products = $pdo->query('SELECT * FROM products')->rowCount(); ?> Assortiment

DORDTSE WOL- EN HANDWERKWINKEL

Artikelen