???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................home/alphpwcp/previewstream.online/company_details.php000064400000032636151766472230017405 0ustar00prepare(" SELECT c.*, cat.name AS category_name FROM companies c LEFT JOIN categories cat ON c.category_id = cat.id WHERE c.id = ? "); $stmt->execute([$id]); $company = $stmt->fetch(); if (!$company) { die("Company not found. Back to home"); } // Get total reviews + average rating $stmt = $pdo->prepare("SELECT COUNT(*) AS total_reviews, AVG(rating) AS avg_rating FROM reviews WHERE company_id = ?"); $stmt->execute([$id]); $reviewStats = $stmt->fetch(); // Get top-rated review $stmt = $pdo->prepare(" SELECT r.*, u.username FROM reviews r JOIN users u ON r.user_id = u.id WHERE company_id = ? ORDER BY rating DESC, created_at DESC LIMIT 1 "); $stmt->execute([$id]); $topReview = $stmt->fetch(); // Latest reviews $latestReviews = $pdo->query(" SELECT 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 5 ")->fetchAll(); // Top rated companies $topCompanies = $pdo->query(" SELECT c.id, c.name, c.image, ROUND(AVG(r.rating),1) AS avg_rating FROM companies c JOIN reviews r ON c.id = r.company_id GROUP BY c.id HAVING COUNT(r.id) >= 1 ORDER BY avg_rating DESC LIMIT 5 ")->fetchAll(); // Generate dynamic meta content $pageTitle = $company['name'] . ' | Reviews, Ratings, and Company Details – Review Stream'; $metaDescription = 'See reviews and insights for ' . $company['name'] . ', a top company in the ' . $company['category'] . ' category. Find ratings, performance, and user feedback on Review Stream.'; $canonicalUrl = 'https://previewstream.online/company_details.php?id=' . $company['id']; ?> <?= htmlspecialchars($pageTitle) ?>
Home Companies Newsroom Logout Login

<?= $company['name'] ?>

Category:

Region:

Website:

About

Review Summary

Total Reviews:

Average Rating: '; } echo " {$avg}/5"; ?>

Top Review by

(/5)

Read All Reviews

Latest Reviews

on :

★ (/5)

...

Top Rated Companies

<?= htmlspecialchars($top['name']) ?> (/5)
home/alphpwcp/previewstream.online/old/company_details.php000064400000024214151766576460020166 0ustar00prepare(" SELECT c.*, cat.name AS category_name FROM companies c LEFT JOIN categories cat ON c.category_id = cat.id WHERE c.id = ? "); $stmt->execute([$id]); $company = $stmt->fetch(); if (!$company) { die("Company not found. Back to home"); } // Get total reviews + average rating $stmt = $pdo->prepare("SELECT COUNT(*) AS total_reviews, AVG(rating) AS avg_rating FROM reviews WHERE company_id = ?"); $stmt->execute([$id]); $reviewStats = $stmt->fetch(); // Get top-rated review $stmt = $pdo->prepare(" SELECT r.*, u.username FROM reviews r JOIN users u ON r.user_id = u.id WHERE company_id = ? ORDER BY rating DESC, created_at DESC LIMIT 1 "); $stmt->execute([$id]); $topReview = $stmt->fetch(); // Latest reviews $latestReviews = $pdo->query(" SELECT 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 5 ")->fetchAll(); // Top rated companies $topCompanies = $pdo->query(" SELECT c.id, c.name, c.image, ROUND(AVG(r.rating),1) AS avg_rating FROM companies c JOIN reviews r ON c.id = r.company_id GROUP BY c.id HAVING COUNT(r.id) >= 1 ORDER BY avg_rating DESC LIMIT 5 ")->fetchAll(); ?> <?= htmlspecialchars($company['name']) ?> - Review Stream
Home Companies Newsroom Logout Login

<?= $company['name'] ?>

Category:

Region:

Website:

About

Review Summary

Total Reviews:

Average Rating: '; } echo " {$avg}/5"; ?>

Top Review by

(/5)

Read All Reviews

Latest Reviews

on :

★ (/5)

...

Top Rated Companies

<?= htmlspecialchars($top['name']) ?> (/5)