query($sqlQuery); // $tablesAndTheirData = array(); // array_push($tablesAndTheirData, array( // 'fields' => $data->fetch_fields(), // 'data' => $data // )); // $result = $conn->query("SELECT u.user_id AS 'ID', u.username AS 'Username', c.class_name AS 'Class', SUM(u.completed_surveys) AS 'Completed Surveys (Total)' FROM user_account u, school_class c WHERE u.class_id = c.class_id AND c.teacher_id = '".$_SESSION['userID']."' ORDER BY u.user_id ASC;"); // $result = $conn->query("SELECT user_id AS 'ID', username AS 'Username', SUM(completed_surveys) AS 'Completed Surveys (Total)' FROM user_account WHERE teacher_id = '".$_SESSION['userID']."' ORDER BY user_id ASC;"); $db_sid = 0; $result = $conn->query("SELECT school_id FROM user_account WHERE user_id = '".$_SESSION['userID']."'"); if($result) { while ( $row = $result->fetch_assoc() ){ $db_sid = $row['school_id']; } } if ($_SESSION['accountType'] == 2){ // Teacher $result = $conn->query("SELECT u.user_id AS 'ID', u.username AS 'Username', c.class_name AS 'Class', u.completed_demographic AS 'Completed Demographic', u.completed_surveys AS 'Completed Surveys (Total)' FROM school_class c, user_account u WHERE c.class_id = u.class_id AND c.teacher_id = '".$_SESSION['userID']."' GROUP BY u.user_id "); } else if ($_SESSION['accountType'] == 3){ // School-Admin $result = $conn->query("SELECT u.user_id AS 'ID', u.username AS 'Username', c.class_name AS 'Class', u.completed_demographic AS 'Completed Demographic', u.completed_surveys AS 'Completed Surveys (Total)' FROM school_class c, user_account u WHERE (u.class_id = c.class_id OR u.class_id = 0) AND u.school_id = '".$db_sid."' GROUP BY u.user_id "); } else{ $result = $conn->query("SELECT user_id AS 'ID', username AS 'Username', class_id AS 'Class', completed_demographic AS 'Completed Demographic', completed_surveys AS 'Completed Surveys (Total)' FROM user_account u GROUP BY user_id "); } $tablesAndTheirData = array(); array_push($tablesAndTheirData, array( 'fields' => $result->fetch_fields(), 'data' => $result )); ?> Survey Completion

Greenscape Environmental Experience & Learning Survey Experiments

Survey Completion

num_rows):?> fetch_assoc()): ?> $value):?>
name;?>
query("SELECT class_name FROM school_class WHERE class_id = ".$value); if($result) { $row = $result->fetch_assoc(); echo $row['class_name']; } } } else echo $value; ?>

Table does not have any data