????????????????????
??????????????????
ÿØÿà
JFIF ÿÛ C
! "$" $ ÿÛ C
ÿÂ p
" ÿÄ
ÿÄ ÿÚ
ÕÔË®
(% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤ @
adadasdasdasasdasdas
.....................................................................................................................................query("SELECT COUNT(*) FROM reviews");
$total_reviews = $total_stmt->fetchColumn();
$total_pages = ceil($total_reviews / $limit);
// Fetch reviews for current page with related user and company info
$stmt = $pdo->prepare("
SELECT r.id, r.comment, r.rating, u.username, c.name AS company_name
FROM reviews r
JOIN users u ON r.user_id = u.id
JOIN companies c ON r.company_id = c.id
ORDER BY r.id DESC
LIMIT :limit OFFSET :offset
");
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$reviews = $stmt->fetchAll();
?>
Manage Reviews