SQL员工总数

Sample table: employees

    +-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+
    | EMPLOYEE_ID | FIRST_NAME  | LAST_NAME   | EMAIL    | PHONE_NUMBER       | title  |companyID
    +-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+
    |         100 | Steven      | King        | SKING    | 515.123.4567       | IT_PROG | 1241
    |         101 | Neena       | Kochhar     | NKOCHHAR | 515.123.4568       | IT_PROG | 1241
    |         102 | Lex         | De Haan     | LDEHAAN  | 515.123.4569       | IT_PROG | 1241
    |         103 | Alexander   | Hunold      | AHUNOLD  | 590.423.4567       | IT_PROG | 1241
    |         104 | Bruce       | Ernst       | BERNST   | 590.423.4568       | FI_MGR  | 1242
    |         105 | David       | Austin      | DAUSTIN  | 590.423.4569       | FI_MGR  | 1242
    |         106 | Valli       | Pataballa   | VPATABAL | 590.423.4560       | FI_MGR  | 1242      
    |         107 | Diana       | Lorentz     | DLORENTZ | 590.423.5567       | IT_PROG | 1242     
    |         108 | Nancy       | Greenberg   | NGREENBE | 515.124.4569       | FI_ACCOUNT |1300     
    |         109 | Daniel      | Faviet      | DFAVIET  | 515.124.4169       | FI_ACCOUNT |1300    
    |         110 | John        | Chen        | JCHEN    | 515.124.4269       | FI_ACCOUNT |1300    
    |         
    |         +-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+--

现在,当我单击“员工的名字”表时,将打开一个单独的页面,profile.php 我使用以下代码提取标题

                      <?php
                            require_once 'tabconnect.php';
                                if (isset($_GET['id'])) {
                                    $id = $_GET['id'];
                                        $query1 = mysqli_query($connection,"SELECT employees.EMPLOYEE_ID,employees.companyID,cemployees.title FROM employees  where employees.EMPLOYEE_ID=$id");
                                            while ($row2 = mysqli_fetch_array($query1)) {
                        ?>
                                            <!-- Displaying Data Read From Database -->                                     
                                                <?php echo $row2['title']; ?>                                       

                        <?php
                                }
                                }
                        ?>

但我不会在profile.php页面中计算特定公司的总员工数 示例1241(companyID)有4名员工。 我该怎么做?

评论