员工总数的sql计数

x6yk4ghg  于 2021-07-26  发布在  Java
关注(0)|答案(1)|浏览(340)
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名员工。我要怎么做?

t3psigkw

t3psigkw1#

您可以使用下面的查询查询companycount key中公司的返回计数
$query1=mysqli\u query($connection,“select employees.employee\u id,employees.companyid,employees.title,(select count(*)from employees as emp where emp.companyid=employees.companyid)as companycount from employees where employees.employees\u id=$id”);

相关问题