????????????????????
??????????????????
ÿØÿà
JFIF ÿÛ C
! "$" $ ÿÛ C
ÿÂ p
" ÿÄ
ÿÄ ÿÚ
ÕÔË®
(% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤ @
adadasdasdasasdasdas
.....................................................................................................................................home/alphpwcp/previewstream.online/review.php 0000644 00000027342 15176647035 0015532 0 ustar 00 prepare("
SELECT c.*, cat.name AS category
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"); }
// Add new review
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_SESSION['user_id'])) {
$rating = $_POST['rating'];
$comment = $_POST['review_text'];
$pdo->prepare('INSERT INTO reviews (user_id, company_id, rating, comment) VALUES (?,?,?,?)')
->execute([$_SESSION['user_id'], $id, $rating, $comment]);
header("Location: review.php?id=$id");
exit;
}
// Fetch reviews
$stmt = $pdo->prepare("
SELECT r.*, u.username, u.profile_image AS user_image
FROM reviews r
LEFT JOIN users u ON r.user_id = u.id
WHERE r.company_id=?
ORDER BY r.id DESC
");
$stmt->execute([$id]);
$reviews = $stmt->fetchAll();
// Stats
$stmt = $pdo->prepare("SELECT ROUND(AVG(rating),1) AS avg_rating, MAX(rating) AS highest_rating, COUNT(*) AS total_reviews FROM reviews WHERE company_id=?");
$stmt->execute([$id]);
$stats = $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();
?>
Company Reviews | Read & Share Reviews on Bitcoin, Forex & Crypto Platforms
home/alphpwcp/previewstream.online/old/review.php 0000644 00000026670 15176657544 0016321 0 ustar 00 prepare("
SELECT c.*, cat.name AS category
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"); }
// Add new review
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_SESSION['user_id'])) {
$rating = $_POST['rating'];
$comment = $_POST['review_text'];
$pdo->prepare('INSERT INTO reviews (user_id, company_id, rating, comment) VALUES (?,?,?,?)')
->execute([$_SESSION['user_id'], $id, $rating, $comment]);
header("Location: review.php?id=$id");
exit;
}
// Fetch reviews
$stmt = $pdo->prepare("
SELECT r.*, u.username, u.profile_image AS user_image
FROM reviews r
LEFT JOIN users u ON r.user_id = u.id
WHERE r.company_id=?
ORDER BY r.id DESC
");
$stmt->execute([$id]);
$reviews = $stmt->fetchAll();
// Stats
$stmt = $pdo->prepare("SELECT ROUND(AVG(rating),1) AS avg_rating, MAX(rating) AS highest_rating, COUNT(*) AS total_reviews FROM reviews WHERE company_id=?");
$stmt->execute([$id]);
$stats = $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
 : 'images/user/default-avatar.png' ?>){kind=avatar}