如何在html表格中添加css类的新记录,数据存储在Mysql中


How to add css class of new records in the table html, data is stored in Mysql?

标题并不完全清楚,如果更详细的是:在mysql db表中有,从它到页面的数据显示在html表中以下代码:

<?php            
   $db_host = 'localhost';         
   $db_name = 'DB';         
   $db_username = 'NAME';         
   $db_password = 'PASS';       
   $db_table_to_show = 'TABLE';         
   $connect_to_db = mysql_connect($db_host, $db_username, $db_password) 
   or die("Could not connect: " . mysql_error());           
   mysql_select_db($db_name, $connect_to_db)      
   or die("Could not select DB: " . mysql_error());   
   mysql_set_charset("utf8");          
   $qr_result = mysql_query("select * from " . $db_table_to_show)      
   or die(mysql_error());            
   echo '<table id="table">';       
   echo '<thead>';         
   echo '<tr>';
   echo '<th class="table-fandom">fandom</th>';        
   echo '<th>author</th>';     
   echo '<th class="table-name">name</th>';
   echo '<th>size</th>';    
   echo '<th class="table-status">status</th>';             
   echo '<th>date</th>';       
   echo '<th>tags</th>';
   echo '</tr>';       
   echo '</thead>';        
   echo '<tbody>';         
   while($data = mysql_fetch_array($qr_result)){       
       echo '<tr>';
       echo '<td>' . $data['fandom'] . '</td>';    
       echo '<td>' . $data['author'] . '</td>';         
       echo '<td><a href="/goto/' . $data['url'] . '" target="_blank">' . $data['name'] . '</a><div class="menu" style="display: none;"><br> '                                             . $data['annotation'] .  '  </div></td>';       
       echo '<td>' . $data['size'] . '</td>';  
       echo '<td>' . $data['status'] . '</td>';        
       echo '<td>' . $data['date'] . '</td>';  
       echo '<td>' . $data['tags'] . '</td>';                  
       echo '</tr>';       
   }       
   echo '</tbody>';        
   echo '</table>';         
   mysql_close($connect_to_db);        
  ?>

要求在 72 小时内为今天添加的新记录分配特殊的 css 类。PS对不起我的英语,这不是我的母语。

你可以这样做:

...
 while($data = mysql_fetch_array($qr_result)){     
      if($data['date'] > date('Y-m-d', strtotime('-3 days'))  
          echo '<tr class="new">';
      else
          echo '<tr>';
      echo '<td>' . $data['fandom'] . '</td>';    
      echo '<td>' . $data['author'] . '</td>';         
      echo '<td><a href="/goto/' . $data['url'] . '" target="_blank">' .         $data['name'] . '</a><div class="menu" style="display: none;"><br> '         . $data['annotation'] .  '  </div></td>';       
      echo '<td>' . $data['size'] . '</td>';  
      echo '<td>' . $data['status'] . '</td>';        
      echo '<td>' . $data['date'] . '</td>';  
      echo '<td>' . $data['tags'] . '</td>';                  
      echo '</tr>';       
    } 

首先,您需要在表格中添加注册时间。例如,您将注册时间保存在 unix 时间戳中。然后你需要在 while 循环之后使用条件。

 while($data = mysql_fetch_array($qr_result))
 { 
    if($data['registration_time'] > strtotime("-3 days") ) 
    {
      echo '<tr class="change_color_class">';
    }
    else
    {
          echo '<tr class="normal_class">';
    }        
 }