Write a PHP program named "display_163_staff.php" that retrieves all columns of staff who work in the branch at ‘163 Main Street’ and displays the result in HTML format. If sex='M', print 'M' in blue in the table. If sex='F', print 'F' in red in the table. |+-| B002B003B004|B005| B007branchNo| street| 56 Cover Drive| 163 Main Street| 32 Manse Road| 22 Deer Road| 16 Argyll Streetcity| postcode || London| NW10 6EUGlasgow | G11 9QX| Bristol | BS99 1NZ| London| SW1 4EH| Aberdeen | AB2 3SU-+-+

In this question we have towrite a PHP code that get all columns of staff who work in branch and display html format result.Let's code and hope this helps, If you have any queries please utilize threaded question feature.PHP program named display_163_staff.php1<?php 2$host = 'localhost'; // replace with your database host 3$username = 'root'; // replace with your database username 4$password = ''; // replace with your database password 5$dbname = 'your_db_name'; // replace with your database name 6 7// Create connection 8$conn = new mysqli($host, $username, $password, $dbname); 9 10// Check connection 11if ($conn->connect_error) { 12 die("Connection failed: " . $conn->connect_error); 13} 14 15$sql = "SELECT * FROM staff WHERE branchNo = (SELECT branchNo FROM branches WHERE street = '163 Main Street')"; 16 17$result = $conn->query($sql); 18 19echo "<table border='1'> 20<tr> 21<th>Staff ID</th> 22<th>First Name</th> 23<th>Last Name</th> 24<th>Sex</th> 25<th>...</th>  26</tr>"; 27 28if ($result->num_rows > 0) { 29 while($row = $result->fetch_assoc()) { 30 echo "<tr>"; 31 echo "<td>" . $row['staffID'] . "</td>"; 32 echo "<td>" . $row['fName'] . "</td>"; 33 echo "<td>" . $row['lName'] . "</td>"; 34 35 if ($row['sex'] == 'M') { 36 echo "<td style='color:blue'>" . $row['sex'] . "</td>"; 37 } elseif ($row['sex'] == 'F') { 38 echo "<td style='color:red'>" . $row['sex'] . "</td>"; 39 } else { 40 echo "<td>" . $row['sex'] . "</td>"; 41 } 42 43 // Add other columns as needed 44 echo "</tr>"; 45 } 46} else { 47 echo "<tr><td colspan='4'>No staff found</td></tr>"; 48} 49echo "</table>"; 50 51$conn->close(); 52?>The column names (staffID, fName, lName, sex, etc.) are placeholders. Replace them with the actual column names from your staff table.As this is based on db table, so you need to output based on the data.You will need to replace the placeholders (localhost, root, your_db_name, etc.) with your actual database details.