以 HTML 表格格式打印出勤报告

Question

我想水平打印班次，垂直打印名称/ID。我有一个这样的出勤表=>>。出席表：

我想shift以此表格式 html 表结构打印值：

  <?php

    $d=cal_days_in_month(CAL_GREGORIAN,date("n"),date("Y"));

    $totdate = $d;

    $month = date("F");

    echo '<table class="table table-striped table-bordered" id="table_content">';

    echo "<thead>";

    

        echo "<tr>";

            echo "<th>Sl/No</th>";

            echo "<th>Emp.ID</th>";

            echo "<th>Name</th>";

            for ($i=1; $i <= $totdate; $i++) { 

                

                echo "<th>".$i."</th>";

                

            }

        echo "</tr>";

    echo "</thead>";

$qry = "SELECT * FROM attendance WHERE `month` = '$month'";

$cnt=1;

$query = mysqli_query($conn, $qry);

foreach ($query as $q) {

    $sid = $q['empid'];

        echo "<tr>";

        echo "<td>".$cnt++ ."</td>";

        $st_name_id = "SELECT `emp_id`, `name` FROM `emp` WHERE `id`='$sid'";

        $re = mysqli_query($conn, $st_name_id);

        while ($result = mysqli_fetch_array($re)) {

            echo "<td>".$result['emp_id']."</td>";

            echo "<td>".$result['name']."</td>";

        }

            for ($i=1; $i <= $totdate ; $i++) { 

                $qry2 = "SELECT * FROM `attendance` WHERE `empid`='$sid' AND `month`='$month' AND `date`='$i'";

                $re2 = mysqli_query($conn, $qry2);

                echo "<td>";

                foreach ($re2 as $value => $q) {

                    $dt = $q['date'];

                    $s = $q['shift'];

                    if ($i == $dt) {

                        echo $s;

                        echo "</td>";

                    }else{

                        echo "<td>x</td>";

                    }

                }

            }

            echo "</tr>";

}

echo "</table>";

?>

Answer 1

$qry ="SELECT * FROM emp";

Answer 2

大家好，这里就是答案。谢谢你的支持&nbsp; &nbsp; <?php&nbsp; &nbsp; $d=cal_days_in_month(CAL_GREGORIAN,date("n"),date("Y"));&nbsp; &nbsp; $totdate = $d;&nbsp; &nbsp; $month = date("F");&nbsp; &nbsp; echo '<table class="table table-striped table-bordered" id="table_content">';&nbsp; &nbsp; echo "<thead>";&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; echo "<tr>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "<th>Sl/No</th>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "<th>Emp.ID</th>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "<th>Name</th>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for ($i=1; $i <= $totdate; $i++) {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "<th>".$i."</th>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; echo "</tr>";&nbsp; &nbsp; echo "</thead>";// $qry = "SELECT * FROM attendance WHERE `month` = '$month'";$qry ="SELECT * FROM `emp`";$cnt=1;$query = mysqli_query($conn, $qry);foreach ($query as $q) {&nbsp; &nbsp; $sid = $q['id'];&nbsp; &nbsp; &nbsp; &nbsp; echo "<tr>";&nbsp; &nbsp; &nbsp; &nbsp; echo "<td>".$cnt++ ."</td>";&nbsp; &nbsp; &nbsp; &nbsp; $st_name_id = "SELECT `emp_id`, `name` FROM `emp` WHERE `id`='$sid'";&nbsp; &nbsp; &nbsp; &nbsp; $re = mysqli_query($conn, $st_name_id);&nbsp; &nbsp; &nbsp; &nbsp; while ($result = mysqli_fetch_array($re)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "<td>".$result['emp_id']."</td>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "<td>".$result['name']."</td>";&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for ($i=1; $i <= $totdate ; $i++) {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $ii = sprintf("%02d", $i);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $qry2 = "SELECT * FROM `attendance` WHERE `empid`='$sid' AND `month`='$month' AND `date`='$ii'";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $re2 = mysqli_query($conn, $qry2);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "<td>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach ($re2 as $q) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dt = $q['date'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $s = $q['shift'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($dt == $ii) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo $s;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "</td>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "x</td>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // echo sprintf("%02d", $i) ."</td>";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo "</tr>";}echo "</table>";作为接受的结果