Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Answered
Why is there no admin access to this Scoold Demo?

in the Scoold Pro Demo I can see the admin interface with some admin options but in this Demo I can't see it. Is the non-Pro version admin interface similar to the Pro version?

4
4
Posted 3 years ago
Edited 3 years ago
Votes Newest

Answers 4


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);
2
2
Posted 3 years ago

I think, I do not know the answer yet

  
  
Posted one year ago

Test answer

  
  
Posted one year ago

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

2
2
Posted 3 years ago