<?php
include 'database.php';
$sql="SELECT `j_company`,`j_salary`,`j_title` FROM `jobs`";
$query=mysqli_query($conn, $sql);
if(!$query)
{
echo "<h1>Unsuccessful</h1>";
echo("Error description: " . mysqli_error($conn));
}
$arr=array();
while ($fetch=mysqli_fetch_assoc($query))
{
$arr[]=$fetch;
}
?>
如上所述,我正在从"作业"表中检索j_company,j_title,j_salary。
之后,我需要搜索每个公司的数组 arr[],以找到所有职位 (j_title),如果有多个相同的j_title - 找到同一j_title下工资的平均数,并可能将j_company、j_title、j_salary(每个相同职位的平均值)存储在数组中。
ex-
company1 title1 $1000
company1 title1 $1500
company2 title2 $2000
company2 title3 $2500
company3 title3 $3000
company3 title3 $2500
output -
company1 title1 $1250
company2 title2 $2000
company2 title3 $2500
company3 title3 $2750
试试这个简单的 foreach
$reuslSetArray = array();
if (!is_null($arr)) {
foreach ($arr as $key => $mainArray) {
$reuslSetArray[$mainArray['j_company'] . '_' . $mainArray['j_title']][] = $mainArray['j_salary'];
}
}
if (!is_null($reuslSetArray)) {
foreach ($reuslSetArray as $key => $resultArray) {
$labels = explode("_", $key);
$value = array_sum($resultArray) / count($resultArray);
echo $labels[0] . ' ' . $labels[1] . ' ' . $value . " <br>";
}
}
如果您不需要使用每一行,那么您可以通过 SQL 完成所有操作:
SELECT j_company,j_title,COUNT(*) as c, SUM(j_salary) as s FROM table GROUP BY j_company, j_title
查询结果在 $row
中,
$avg = $row['s'] / $row['c'];