在php中预定行数后插入一个空行

Question

Here's what i want, after a group of say 3 rows in table i insert a blank row Here's my code for creating the tables and populating with data

    $row_count =0;
    while($data = $result->fetch_assoc()){

        $row_count++;

            $tbl .=' <tr>                                   

                      <td>' .'&nbsp;' .$data['houseNumber'].'</td>
                      <td>' .'&nbsp;'.$data['tenantName'].'</td>
                      <td>' .'&nbsp;'.$data['status'].'</td>                      
                      <td>' .'&nbsp;'.$data['rentDue'].'</td>                      
                      <td>' .'&nbsp;'.$data['rentPaid'].'</td>
                      <td></td>
                      <td></td>
                      <td></td>
                      <td>'.'&nbsp;' .($data['rentPaid']).'</td>


                  </tr> ';      

                }//end while

How can i use this $row_count variable to do that. Thanks in advance

Answer 1

You can try:

$row_count =0;
while($data = $result->fetch_assoc()) {
    $row_count++;
    $tbl .=' <tr>                                   
        <td>' .'&nbsp;' .$data['houseNumber'].'</td>
        <td>' .'&nbsp;'.$data['tenantName'].'</td>
        <td>' .'&nbsp;'.$data['status'].'</td>                      
        <td>' .'&nbsp;'.$data['rentDue'].'</td>                      
        <td>' .'&nbsp;'.$data['rentPaid'].'</td>
        <td></td>
        <td></td>
        <td></td>
        <td>'.'&nbsp;' .($data['rentPaid']).'</td>
    </tr> ';     

    if ($row_count % 3 == 0) { 
        //if is divisible for 3, put the blanck row
        $tbl .=' <tr>                                   
            <td colspan="9">&nbsp;</td>
        </tr> ';        
    } 
}
//end while