PHP循环每3条视频数据后输出广告的实现方法

Here's a straightforward, practical approach to loop through your video data and insert an ad after every 3 videos. I'll break down the logic and provide working code examples tailored to your scenario.

Basic Implementation #

First, let's assume you've already fetched your 100 video entries from the database into an array (e.g., $videos). We'll use a counter to track how many videos we've output, and insert the ad whenever the counter hits a multiple of 3.

<?php
// 模拟从数据库获取的100条视频数据（实际中替换为你的数据库查询）
$videos = range(1, 100); // 用数字ID模拟，实际会是包含视频标题、缩略图等的关联数组
$totalVideos = count($videos);
$videoCount = 0;

foreach ($videos as $video) {
    $videoCount++;
    
    // 输出单个视频的HTML结构（替换为你的实际视频模板）
    echo "<div class='video'>{$video}</div> ";
    
    // 每3条视频后插入广告，且避免在最后一条视频后加广告（可选）
    if ($videoCount % 3 === 0 && $videoCount !== $totalVideos) {
        // 输出广告图片（替换为你的广告URL和样式）
        echo "<div class='ad'>
                <img src='your-ad-image-path.jpg' alt='推广广告' />
              </div> ";
    }
}
?>

Key Logic Explained #

1. Counter Tracking: The $videoCount variable increments with each video we output, letting us know exactly when we've hit the 3-video mark.
2. Ad Insertion Check:
   • $videoCount % 3 === 0 checks if we've just output the 3rd, 6th, 9th, etc., video.
   • The extra $videoCount !== $totalVideos condition ensures we don't add an ad after the very last video (useful if your total number of videos is a multiple of 3, like 99). If you want an ad even after the final set of 3, simply remove this part.
3. Database Integration: In a real scenario, replace the $videos = range(1,100) line with your actual database query. For example, using PDO:

   $pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');
   $stmt = $pdo->query("SELECT id, title, thumbnail FROM videos LIMIT 100");
   $videos = $stmt->fetchAll(PDO::FETCH_ASSOC);
   

   Then update the video output line to use your actual video data:

   echo "<div class='video'>
           <h3>{$video['title']}</h3>
           <img src='{$video['thumbnail']}' alt='{$video['title']}' />
         </div> ";
   

Alternative: For Loop Approach #

If you prefer using a for loop instead of foreach, here's an equivalent version:

<?php
$videos = range(1, 100);
$total = count($videos);

for ($i = 0; $i < $total; $i++) {
    $video = $videos[$i];
    echo "<div class='video'>{$video}</div> ";
    
    // Since we start counting from 0, we check if (i+1) is a multiple of 3
    if (($i + 1) % 3 === 0 && ($i + 1) !== $total) {
        echo "<div class='ad'><img src='your-ad-image.jpg' alt='广告'></div> ";
    }
}
?>

Styling Tip #

Adding CSS classes like .video and .ad lets you control spacing and appearance, ensuring ads stand out without breaking your layout:

.video {
    margin-bottom: 1rem;
    /* Your video styling here */
}

.ad {
    margin: 2rem 0;
    padding: 1rem;
    background: #f5f5f5;
    /* Your ad styling here */
}

内容的提问来源于stack exchange，提问作者Ademaintain