$query = new ConnectQuery(); //get data $dept_data = $query->all('call SELECT_DEPARTMENTS()'); $faculty_data = $query->all('call SELECT_FACULTY()'); $fellow_data = $query->all('call SELECT_FELLOWS()'); $staff_data = $query->all('call SELECT_STAFF()'); $research_data = $query->all('call SELECT_RESEARCH()'); $ghro_data = $query->all('call SELECT_GHRO()'); $lab_data = $query->all('call SELECT_LABORATORY()'); $vaccine_research_data = $query->all('call SELECT_VACCINE_REFUGEE()'); $hiv_data = $query->all('call SELECT_HIV()'); $kycare_data = $query->all('call SELECT_KYCARE()'); //create table object $pdf = new Table('P', 'mm', 'Letter'); $pdf->SetMargins(5, 5, 5); $pdf->AddPage(); //create individual tables in the pdf $pdf->CreateTable('Main Numbers', $dept_header, $dept_data); $pdf->CreateTable('ID Faculty', $team_header, $faculty_data); $pdf->CreateTable('ID Fellows', $team_header, $fellow_data); $pdf->CreateTable('Office Staff', $team_header, $staff_data); $pdf->CreateTable('Research Staff', $team_header, $research_data); $pdf->CreateTable('Global Health Research Organization', $team_header, $ghro_data); $pdf->CreateTable('ID Laboratory/Biorepository Laboratory', $team_header, $lab_data); $pdf->CreateTable('Vaccine and Refugee Program', $team_header, $vaccine_research_data); $pdf->CreateTable('HIV Clinic', $team_header, $hiv_data); $pdf->CreateTable('KY Care Coordination Program', $team_header, $kycare_data); ob_end_clean(); //cleans cache so the data is retrieved from the database after each browser refresh $pdf->Output(); //output the object