<?php

/*    Function Name: Mysqli_Query_To_Table
 *  Function Author: FaalFaazDov (Raistlin Thoreson)
 * Function Version: V1.0
 *     Date Created: 06/10/2016 13:54
 *    Date Modified: Never
 */

function mysqli_query_to_table($mysqli, $query, $class) {

    $result = mysqli_query($mysqli, $query);
    $result2 = mysqli_query($mysqli, $query);
    
    $titles = $result->fetch_assoc();
    
    $t = "<table class=\"$class\">
 <thead>
  <tr>\n";
    
    foreach($titles as $name => $value) {
        
        $title[] = $name;
        
        $t .= "   <th>
    $name
   </th>\n";
    }
    
    $t .= "  </tr>
 </thead>
 <tbody>\n";
    
    while($row = $result2->fetch_assoc()) {
        
        $t .= "  <tr>\n";
        
        foreach($title as $name) {
            
            $t .= "   <td>$row[$name]</td>\n";
            
        }
        
        $t .= "  </tr>\n";
        
    }
    
    $t .= " </tbody>
</table>\n";

    return $t;
    
}

?>