@($current_user = $_SESSION['username']); $dt = $_POST['date']; $pdf = new PDF_TOC('L', 'mm', 'A4'); $pdf->startPageNums(); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->Ln(70); $pdf->SetFont('Times', '', 32); $pdf->Cell(0, 1, 'CPU Utilization Report', 0, 1, 'C'); include 'sqlconnectver2.php'; if ($query = mysql_query("SELECT distinct server,environ FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******' group by server")) { $pdf->AddPage(); $pdf->Ln(3); $pdf->SetFont('Arial', '', 20); $pdf->setFillColor(63, 139, 202); $pdf->SetTextColor(253, 253, 253); $pdf->Cell(0, 10, 'List of Servers', 1, 1, 'C', 1); $pdf->TOC_Entry('List of Servers', 0); $pdf->SetFont('Times', '', 14); $pdf->SetTextColor(0, 0, 0); while ($query_row = mysql_fetch_assoc($query)) { $hostname = $query_row['server']; $environ = $query_row['environ']; $pdf->Cell(0, 10, 'Server: ' . $hostname . ' [' . $environ . ']', 0, 1, 'L'); } $cpuquerytot = mysql_query("SELECT date(date)as date,time(date) as time,user,nice,system,iowait,steal,idle from cpurep where date(date) = '{$dt}'"); if (mysql_num_rows($cpuquerytot)) { $pdf->SetFont('Arial', '', 20); $pdf->Ln(10); $pdf->setFillColor(63, 139, 202); $pdf->SetTextColor(253, 253, 253);