Greenscape Environmental Experience & Learning Survey Experiments

Profile

query("SELECT * FROM user_account WHERE user_id = '$userID'"); $row = $data->fetch_assoc(); // echo ''; $db_username = $row['username']; $db_email = $row['email']; if ( $row['class_id'] != 0 ){ $db_cid = $row['class_id']; } if ( $row['school_id'] != 0 ){ $db_sid = $row['school_id']; } $role_data = $conn->query("SELECT * FROM user_role WHERE role_id = ".$row['accountType']); $role_row = $role_data->fetch_assoc(); $class_data = $conn->query("SELECT * FROM school_class WHERE class_id = ".$row['class_id']); if ($class_data->num_rows > 0){ $class_row = $class_data->fetch_assoc(); $db_cName = $class_row['class_name']; $db_code = $class_row['specific_classCode']; } $school_data = $conn->query("SELECT * FROM school WHERE school_id = ".$row['school_id']); if ($school_data->num_rows > 0){ $school_row = $school_data->fetch_assoc(); $db_sName = $school_row['school_name']; } ?>