我已经建立了一个新闻页面,该页面从MYSQL新闻表中检索新闻。

我试图确定news列是奇数还是偶数,因此,如果news列是奇数或偶数,它将为div元素添加一个类。

我的代码如下:

<?php
$cat = $_GET['cat'];
$date = $_GET['date'];

if ($date !="") {
    $date = explode('-', $date);
    $year = $date[1];
    $month = $date[0];
    $month = date("m", strtotime($month));
    $sql = "SELECT * FROM news WHERE year(newsDate) = '$year' AND month(newsDate) = '$month' AND newsState = 1 ORDER BY newsDate DESC";
} else {
    $sql = "SELECT * FROM news WHERE newsState = 1 ORDER BY newsDate DESC";
}

$result = $conn->query($sql);
$rows = $result->num_rows;

$pager = new PS_Pagination($conn, $sql, 5, 10, null);

$rs = $pager->paginate();

$num = $rs->num_rows;

if($num >= 1 ){
while($row = $rs->fetch_assoc()){
?>
 <div class="news <?php echo $num; ?>">
        <div class="four columns">
            <p><img src="/news-images/thumbs/thumb_<?php echo $row['newsImage1']; ?>" alt=""/></p>
        </div>
        <div class="eight columns">
            <h3><?php echo $row['newsTitle']; ?></h3>
            <p><?php echo stripslashes(strip_tags($row['newsDescription'])); ?></p>
        </div>
    </div>
<?php } } else {
echo "No records found!";

}

if ($rows >= 5) {
echo "<div class='page-nav blog-nav'>";
    echo $pager->renderFullNav();
echo "</div>";
}
?>

最佳答案

拿任何保持奇偶位置的标志...

$f = 0; //ADDED THIS LINE
if($num >= 1 ){
while($row = $rs->fetch_assoc()){
 if($f%2==0) //ADDED THIS LINE
    $class_name = "even"; //ADDED THIS LINE
 else     //ADDED THIS LINE
    $class_name = "odd";  //ADDED THIS LINE
?>
 <div class="news <?php echo $class_name; ?>">
        <div class="four columns">
            <p><img src="/news-images/thumbs/thumb_<?php echo $row['newsImage1']; ?>" alt=""/></p>
        </div>
        <div class="eight columns">
            <h3><?php echo $row['newsTitle']; ?></h3>
            <p><?php echo stripslashes(strip_tags($row['newsDescription'])); ?></p>
        </div>
    </div>
<?php $f++; } } else {
echo "No records found!";

}

关于php - 如何确定它是奇数还是偶数并添加类?,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/28452578/

10-11 04:46