PHP检查while循环中是否存在值，然后输入value然后中断

Question

I am using PHPspreadsheet and all works well. However I have an issue when generating a sign-in sheet when no one is working on a particular day THis then puts all entries on my excel template out of sync. Question: How do i check the first value(StaffName) in the loop - If empty then substitute with 'No one Working' and then break the loop and allow it to move on to the next loop Tuesday. Thanks The code is as follows:

$sql="SELECT StaffName, MonStart, MonFInish, MonA FROM print_signin_mon 
where AreaID= '$AreaID'";
$rsSql=db_query($sql,$conn);

$baseRow = 6;
$r=0;

while ($data2 = db_fetch_array($rsSql)){
$row = $baseRow + $r;
$spreadsheet->getActiveSheet()->insertNewRowBefore($row, 1);

$spreadsheet->getActiveSheet()->setCellValue('A' . $row, $r + 1)
    ->setCellValue('B' . $row, $data2['StaffName'])
    ->setCellValue('E' . $row, $data2['MonStart']) 
    ->setCellValue('G' . $row, $data2['MonFInish'])
    ->setCellValue('M' . $row, $data2['MonA']);

    $r= $r+1;
}
$spreadsheet->getActiveSheet()->removeRow($baseRow - 1, 1);

Answer 1

Don't know if I understood you correctly, but I'll give it a try.

If StaffName is empty, set a different cell value and skip to next iteration:

$sql="SELECT StaffName, MonStart, MonFInish, MonA FROM print_signin_mon where AreaID= '$AreaID'";
$rsSql=db_query($sql,$conn);

$baseRow = 6;
$r=0;

while ($data2 = db_fetch_array($rsSql)){
    $row = $baseRow + $r;
    $spreadsheet->getActiveSheet()->insertNewRowBefore($row, 1);

    if (empty($data2['StaffName'])) {
        $spreadsheet->getActiveSheet()->setCellValue('A' . $row, $r + 1)
            ->setCellValue('B' . $row, 'No one Working');

        $r++;
        continue;
    }

    $spreadsheet->getActiveSheet()->setCellValue('A' . $row, $r + 1)
        ->setCellValue('B' . $row, $data2['StaffName'])
        ->setCellValue('E' . $row, $data2['MonStart']) 
        ->setCellValue('G' . $row, $data2['MonFInish'])
        ->setCellValue('M' . $row, $data2['MonA']);

    $r++;
}

$spreadsheet->getActiveSheet()->removeRow($baseRow - 1, 1);