Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <br><h1>JOB DESCRIPTION OF THE STAFF</h1><br>
- <div class="table-responsive">
- <?php
- $con= mysqli_connect('localhost','root','');
- mysqli_select_db($con,'projectanotherdb');
- $sql="SELECT staff.name,staff.job_id,job.job_description FROM staff JOIN job ON staff.job_id=job.job_id";
- $records=mysqli_query($con,$sql);
- ?>
- <table class="table table-hover table-dark">
- <tr class="header">
- <th>NAME</th>
- <th>JOB ID</th>
- <th>JOB DESCRIPTION</th>
- </tr>
- <?php
- while($ques=mysqli_fetch_assoc($records))
- {
- echo "<tr>";
- echo "<td>".$ques['name']."</td>";
- echo "<td>".$ques['job_id']."</td>";
- echo "<td>".$ques['job_description']."</td>";
- echo "</tr>";
- }
- ?>
- </table>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement