Changing regular db connection to $wpdb

Use the global $wpdb object to query your tables. The get_results() method will return your results as you need: global $wpdb; $query = ‘SELECT * FROM students’; $query_results = $wpdb->get_results($query); foreach ($query_results as $student) { // … }