다차원 데이터 분석 및 PHP의 최적화 팁에 Oracle 데이터베이스 사용

<?php
// 연결하십시오Oracle데이터 베이스
$conn = oci_connect('username', 'password', 'localhost/XE');

if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

// 구현하다SQL질문
$stid = oci_parse($conn, 'SELECT * FROM employees');
oci_execute($stid);
?>

<?php
// 질문多维数据
$stid = oci_parse($conn, 'SELECT department, job, AVG(salary) AS avg_salary FROM employees GROUP BY CUBE (department, job)');
oci_execute($stid);

while ($row = oci_fetch_array($stid, OCI_ASSOC)) {
    echo 'Department: ' . $row['DEPARTMENT'] . ', Job: ' . $row['JOB'] . ', Average Salary: ' . $row['AVG_SALARY'] . '<br/> &#39;;;
}
?>

<?php
// 다차원 분석
$stid = oci_parse($conn, 'SELECT department, job, SUM(salary) AS total_salary FROM employees GROUP BY department, job WITH ROLLUP');
oci_execute($stid);

while ($row = oci_fetch_array($stid, OCI_ASSOC)) {
    echo 'Department: ' . $row['DEPARTMENT'] . ', Job: ' . $row['JOB'] . ', Total Salary: ' . $row['TOTAL_SALARY'] . '<br/> &#39;;;
}
?>

<?php
// 질문员工销售数据
$stid = oci_parse($conn, 'SELECT department, job, SUM(sales) AS total_sales FROM sales GROUP BY department, job');
oci_execute($stid);

echo '<table> &#39;;;
    에코 &#39;<tr><th> 부서</th><th> 직업</th><th> 총 판매</th></tr> &#39;;;

while ($ row = oci_fetch_array ($ stid, oci_assoc)) {
    에코 &#39;<tr><td> &#39;. $ 행 [ &#39;부서&#39;]. &#39;</td><td> &#39;. $ 행 [ &#39;job&#39;]. &#39;</td><td> &#39;. $ 행 [ &#39;Total_Sales&#39;]. &#39;</td></tr> &#39;;;
}

에코 &#39;</table> &#39;;;
?>