query("UPDATE articles SET views_count = views_count + 1 WHERE id = $article_id");
// YouTube-Like Earning Formula (CPM Rate / 1000 views per view reward)
$earning_per_view = CPM_RATE / 1000;
$conn->query("UPDATE earnings SET total_views = total_views + 1, estimated_earnings = estimated_earnings + $earning_per_view WHERE user_id = $reporter_id");
}
// Fetch All Articles
$articles = $conn->query("SELECT articles.*, users.name as reporter_name FROM articles JOIN users ON articles.user_id = users.id ORDER BY articles.id DESC");
// Fetch Ads Code
$ad_res = $conn->query("SELECT ad_code FROM ads WHERE slot_name='sidebar' AND status='active'");
$ad = $ad_res->fetch_assoc();
?>
Global Express | News & Video Platform
Latest Feed
fetch_assoc()): ?>