I am using Mysql and PDO. How can I use PHP variable in this query
Like this:

$startFrom = 0;
$perPage = 12;
$query = $db->prepare("SELECT * FROM products LIMIT $startFrom, $perPage");
$query->execute();
$products = $query->fetchAll();
var_dump($products);

It works and fetches data when I use normal integers.

$query = $db->prepare("SELECT * FROM products LIMIT 0, 10");
$query->execute();
$products = $query->fetchAll();
var_dump($products);

I tried these but they didn't work

$startFrom = 0;
$perPage = 12;
$query = $db->prepare("SELECT * FROM products LIMIT ?,?");
$query->execute(array($startFrom, $perPage));
$products = $query->fetchAll();
var_dump($products);

$startFrom = 0;
$perPage = 12;
$query = $db->prepare("SELECT * FROM products LIMIT :startFrom, :perPage");
$query->execute(array("startFrom" => $startFrom, "perPage" => $perPage));
$products = $query->fetchAll();
var_dump($products);

I think, I do not know the answer yet

Test answer

I've just tested Scoold (non-Pro) and the admin looks very similar to Pro, but of course the Pro features are missing.