h5p results table


how can I make a h5p result table responsive? It's ok when I view it on my tablet, but it's a mess on my mobile.


Thank you



BV52's picture

Hi aib.treger,

I opened the URL that you provided but I do not see an H5P content in it.



Thank you for your reply. I'm sorry, I forgot that only logged in user can view the H5P results. I'm using Tristan Mackay's plugin. Here's the code:

 * Plugin Name: H5P Results
 * Description: Adds custom shortcodes for H5P results.
 * Author: Tristan Mackay
 * Version: 1.0
 * Text Domain: h5p-results
 * License: GNU General Public License v3.0
 * License URI: http://www.gnu.org/licenses/gpl-3.0.html
 * @author    Tristan Mackay
 * @copyright Copyright (c) 2017

defined( 'ABSPATH' ) or exit;

function h5p_results_func($atts){
    global $wpdb;

     $atts = shortcode_atts( array(
            'display' => 'list',
        'tablename' => 'H5P Results',
        'userid' => 'none',
        ), $atts );

    $current_user = wp_get_current_user();
           if($atts['userid'] !== 'none')
          $current_user->ID = $atts['userid'];

    $results = $wpdb->get_results( "SELECT id, slug FROM `wp_h5p_contents`;" );

    $sql_string = 'SELECT ';

       if($atts['userid'] == 'all'){
        $sql_string = "SELECT u.display_name, ";
        $atts['display'] = 'row';

    foreach ($results as $result){
        $sql_string .=  "IFNULL(CONCAT(r".$result->id.".score , '/', r".$result->id.".max_score),'N/A') as '".$result->slug."', ";

    $sql_string = substr($sql_string, 0, -2);

    $sql_string .= " FROM `wp_users` as u ";

    foreach ($results as $result){

        $sql_string .= "left join `wp_h5p_results` as r".$result->id." on r".$result->id.".user_id = u.id and r".$result->id.".content_id = ".$result->id." ";

    if($atts['userid'] !== 'all')
       $sql_string .= "WHERE u.id =".$current_user->ID ;
    $results = $wpdb->get_results($sql_string);

    if($atts['display'] == 'row'){

        $html = "<table border='1'>".
                '<table class="h5p-results">

        foreach ($results as $result){
            $result = (array)$result;
                $result_keys = array_keys($result); // get keys

        foreach ($result_keys as $result_key){
            $html .= '<th>'.$result_key.'</th>';

        $html .= '</tr></thead>';

        foreach ($results as $row){
            $html .= "<tr>";
            foreach ($row as $r){
                $html .= "<td>" . $r . "</td>";
        $html .= "</tr>";
    //close off table mn
    $html .= "</tbody></table>";


    if($atts['display'] == 'list'){

        $sql = "SELECT c.title, c.slug, r.score, r.max_score, ".
        "r.opened, r.finished FROM `wp_h5p_results` r LEFT JOIN ".
        "`wp_h5p_contents` AS c ON c.id = r.content_id WHERE r.user_id = "

        $results = $wpdb->get_results($sql);

        $html = '<table>
                <th scope="col">Title</th>
                <th scope="col">Result</th>
                <th scope="col">Result %</th>
                <th scope="col">Completion date</th>
                <th scope="col">Time taken</th>

        if(count($results) >= 1){

            foreach($results as $result){
                // work out time taken
                $duration = (string)$result->finished - (string)$result->opened;       
                $minutes = floor($duration / 60);
                $seconds = $duration % 60;
                // convert score to %
                $score_percent = (string)$result->score / (string)$result->max_score * 100;

                $result->finished = date('m/d/Y', $result->finished);

                $html .= '<tr><td>'.$result->title.'</td><td>'.
        $html .= '<tr><td colspan="5">No results</td></tr>';
    $html .= '</tbody></table>';


add_shortcode('h5p_results', 'h5p_results_func');


BV52's picture

Hi aib.treger,

Thank you for the information. The plugin was created by someone from the community and it is best that you contact him directly through his Github repo. I'm not sure though if he is still actively developing this plugin since the last entry was 4 years ago.


Thanks, BV. In case I don't contact him, would you be able to suggest how to modify the code so that the result table is responsive?

BV52's picture

Hi aib.treger,

I think it is best that you find a developer for this.


Ok, thanks BV.