Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <h2>Staff Register</h2>
- <table align="justify" border="1" cellspacing="0" cellpadding="0" hspace="5px" vspace="5px">
- <tr>
- <th nowrap="nowrap"><div align="justify">Reg Date</div></th>
- <th nowrap="nowrap"><div align="justify">Staff No</div></th>
- <th nowrap="nowrap"><div align="justify">Surname</div></th>
- <th nowrap="nowrap"><div align="justify">Firstname </div></th>
- <th nowrap="nowrap"><div align="justify">Othername </div></th>
- <th nowrap="nowrap"><div align="justify">Phone No</div></th>
- <th nowrap="nowrap"><div align="justify">Sex</div></th>
- <th nowrap="nowrap"><div align="justify">Age </div></th>
- <th nowrap="nowrap"><div align="justify">Home Address </div></th>
- <th nowrap="nowrap"><div align="justify">E Mail </div></th>
- <th nowrap="nowrap"><div align="justify">Kin Name </div></th>
- <th nowrap="nowrap"><div align="justify">Kin Add </div></th>
- <th nowrap="nowrap"><div align="justify">Kin Phone </div></th>
- <th nowrap="nowrap"><div align="justify">Marital Status </div></th>
- </tr>
- <?php
- // Perform Inspection
- $confirm_select = "SELECT * FROM staff_tab WHERE (status=1) ORDER BY staffno ASC";
- $query=$connection->query($confirm_select);
- while($result=mysqli_fetch_array($query)){
- echo "<tr>";
- echo "<td align='justify' nowrap='nowrap'>".$result['reg_date']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['staffno']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['surname']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['firstname']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['othername']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['mobile']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['sex']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['age']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['homeadd']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['emailadd']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['nextkin']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['kinadd']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['kinphone']."</td>";
- echo "<td align='justify' nowrap='nowrap'>".$result['marital_status']."</td>";
- }
- //to get total row count
- $res =$connection->query("SELECT staffno FROM staff_tab WHERE status=1");
- $pat= ($connection->affected_rows);
- ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement