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名员工。我要怎么做?
1条答案
按热度按时间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”);