setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { die("Database connection failed: " . $e->getMessage()); } // Get deals data $dealsQuery = "SELECT * FROM deals WHERE is_active = 1 ORDER BY priority DESC, display_order ASC, created_at DESC"; $dealsStmt = $pdo->prepare($dealsQuery); $dealsStmt->execute(); $deals = $dealsStmt->fetchAll(PDO::FETCH_ASSOC); // Get analytics data $analyticsQuery = "SELECT COUNT(*) as active_deals, SUM(revenue_generated) as total_revenue, AVG(conversion_rate) as avg_conversion_rate, AVG(discount_value) as avg_discount, MIN(discount_value) as min_discount, MAX(discount_value) as max_discount FROM deals WHERE is_active = 1 AND start_date <= NOW() AND end_date >= NOW()"; $analyticsStmt = $pdo->prepare($analyticsQuery); $analyticsStmt->execute(); $analytics = $analyticsStmt->fetch(PDO::FETCH_ASSOC); // Categorize deals $featuredDeals = array_filter($deals, function($deal) { return $deal['is_featured'] == 1; }); $flashSales = array_filter($deals, function($deal) { $now = new DateTime(); $endDate = new DateTime($deal['end_date']); $timeLeft = $endDate->getTimestamp() - $now->getTimestamp(); return $timeLeft > 0 && $timeLeft <= 24 * 60 * 60; // 24 hours or less }); $dailyDeals = array_filter($deals, function($deal) { $now = new DateTime(); $startDate = new DateTime($deal['start_date']); $endDate = new DateTime($deal['end_date']); return $now >= $startDate && $now <= $endDate && $deal['deal_type'] != 'free_shipping'; }); // Helper functions function getDealStatus($deal) { $now = new DateTime(); $startDate = new DateTime($deal['start_date']); $endDate = new DateTime($deal['end_date']); if (!$deal['is_active']) return 'inactive'; if ($now < $startDate) return 'upcoming'; if ($now > $endDate) return 'expired'; return 'active'; } function getTimeRemaining($deal) { $now = new DateTime(); $endDate = new DateTime($deal['end_date']); if ($now > $endDate) return null; $interval = $now->diff($endDate); return [ 'days' => $interval->days, 'hours' => $interval->h, 'minutes' => $interval->i, 'seconds' => $interval->s ]; } function getDealTypeColorClass($dealType) { $classes = [ 'percentage' => 'bg-blue-100 text-blue-800', 'fixed_amount' => 'bg-green-100 text-green-800', 'buy_one_get_one' => 'bg-purple-100 text-purple-800', 'free_shipping' => 'bg-yellow-100 text-yellow-800', 'bundle_offer' => 'bg-pink-100 text-pink-800' ]; return $classes[$dealType] ?? 'bg-gray-100 text-gray-800'; } function getStatusColorClass($status) { $classes = [ 'active' => 'bg-green-100 text-green-800', 'upcoming' => 'bg-blue-100 text-blue-800', 'expired' => 'bg-gray-100 text-gray-800', 'inactive' => 'bg-red-100 text-red-800' ]; return $classes[$status] ?? 'bg-gray-100 text-gray-800'; } ?> Deals & Offers - USA Bazaar

+12023219344 info@usabazaar.net

Electronics Fashion Home & Garden Sports & Fitness

Deals About Contact

Press Enter to search Press Esc to close

3 5

Tap to search Tap outside to close

Hot Deals

Deals & Offers

Discover amazing deals, flash sales, and limited-time offers on premium products.

Home Deals

FLASH SALE

Up to 70% Off Electronics

Limited time offer - Don't miss out on these incredible deals!

24

Hours

:

00

Minutes

:

00

Seconds

Shop by Deal Type

Find the perfect deal for you

Flash Sales

Limited time offers with countdown timers

12 Active

Daily Deals

New deals every day at midnight

5 Today

Clearance

Deep discounts on overstock items

28 Items

Bundle Deals

Save more when you buy together

8 Bundles

Featured Deals

Handpicked deals you won't want to miss

<?php echo htmlspecialchars($deal['title']); ?>

-

d h m

$ 0): ?> Min: $

Used: /

Today's Deals

Fresh deals updated daily

Next update in: 23:45:12

Wireless Earbuds

DAILY

-25%

True Wireless Earbuds

(94)

$59.99 $79.99

Save $20

Gaming Headset

GAMING

-35%

RGB Gaming Headset

(73)

$84.99 $129.99

Save $45

Studio Headphones

PRO

-20%

Studio Monitor Headphones

(112)

$159.99 $199.99

Save $40

Bluetooth Speaker

WATERPROOF

-15%

Waterproof Bluetooth Speaker

(88)

$84.99 $99.99

Save $15

Flash Sales

Limited time offers - Act fast!

Noise Cancelling Headphones

FLASH

-60%

Noise Cancelling Headphones

(203)

$119.99 $299.99

Save $180

Ends in 2:45:30

Smartphone Bundle

FLASH

-45%

Smartphone + Accessories Bundle

(156)

$549.99 $999.99

Save $450

Ends in 1:23:45

Smartwatch Pro

FLASH

-55%

Premium Smartwatch Pro

(134)

$134.99 $299.99

Save $165

Ends in 3:12:18

Deal Analytics & Management

Track performance and manage your deals effectively

Active Deals

+12%

Total Revenue

$

+8.2%

Conversion Rate

%

+2.1%

Avg. Discount

%

-%

Filter Deals

Deal Type

Status

Discount Range

Deal Management

Deal	Type	Discount	Status	Usage	End Date	Actions
				/

Never Miss a Deal!

Get notified about new deals, flash sales, and exclusive offers

Instant notifications
Early access to sales
Exclusive member deals