// $data is an array. if (count($data) > 0) { constructTable($data); echo "<br>"; } else { print "<h3>(No match.)</h3>\n"; } print "<h1>After Dice</h1>\n"; //echo "<h4>Query : $query</h4><br>"; $ps1 = $con->prepare($query2); // Fetch the matching row. $ps1->execute(array(':id' => $id)); $data1 = $ps1->fetchAll(PDO::FETCH_ASSOC); // $data is an array. if (count($data1) > 0) { constructTable($data1); } else { print "<h3>(No match.)</h3>\n"; } } catch (PDOException $ex) { echo 'ERROR: ' . $ex->getMessage(); } catch (Exception $ex) { echo 'ERROR: ' . $ex->getMessage(); } ?> <br><button onclick="location.href='Analytical.php'">Go Back</button> </div> </div> </div> </div> </body>
print "<h3>Drill Up and Drill Down Operations</h3>\n"; print "<h1>Drill Operations</h1>\n"; try { if ($second == "month") { //echo "harsha"; $query = "Select employee.Name, calender.month, sum(sales_fact_table.DollarsSold) as Revenue_Generated FROM calender, sales_fact_table, employee where calender.calenderKey = sales_fact_table.CalenderKey and sales_fact_table.EmployeeKey = employee.EmployeeKey and calender.year= '{$first}' group by calender.month"; } else { $query = "Select employee.Name, calender.Quarter, sum(sales_fact_table.DollarsSold) as Revenue_Generated FROM calender, sales_fact_table, employee where calender.calenderKey = sales_fact_table.CalenderKey and sales_fact_table.EmployeeKey = employee.EmployeeKey and calender.year= '{$first}' group by calender.quarter"; } $ps = $con->prepare($query); // Fetch the matching row. $ps->execute(array(':id' => $id)); $data = $ps->fetchAll(PDO::FETCH_ASSOC); // $data is an array. if (count($data) > 0) { constructTable($data); echo "<br>"; } else { print "<h3>(No match.)</h3>\n"; } } catch (PDOException $ex) { echo 'ERROR: ' . $ex->getMessage(); } ?> <br><button onclick="location.href='drill.php'">Go Back</button> </div> </div> </div> </div> </body> </html>