open();
try{
$stmt = $conn->prepare("select products.id,category.name as catname,products.name,products.photo,products.class,products.description,products.price,products.location,products.area,products.label,products.value FROM products,category WHERE products.category_id=category.id AND products.class='RENTAL' AND category.id = :catid");
$stmt->execute(['catid' => 14]);
foreach ($stmt as $key1 => $row) {
?>