Guest User

Untitled

a guest
Sep 25th, 2018
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. <?php
  2.  
  3. function displayTable($table) {
  4.  
  5. $server = "localhost";
  6. $user = "root";
  7. $pass = "";
  8. $table = $table;
  9. $BD = 'encuestas';
  10.  
  11. $conexion = mysqli_connect($server, $user, $pass, $BD);
  12.  
  13. if(!$result = mysqli_query($conexion, "SELECT * FROM $table;")) die();
  14.  
  15. $rawdata = array();
  16. $i = 0;
  17.  
  18. while($row = mysqli_fetch_array($result)) {
  19.  
  20. $rawdata[$i] = $row;
  21.  
  22. $i++;
  23.  
  24. }
  25.  
  26. $close = mysqli_close($conexion);
  27.  
  28. echo '<table width="100%" border="1" style="text-align:center;">';
  29.  
  30. $columnas = count($rawdata[0])/2;
  31.  
  32. $filas = count($rawdata);
  33.  
  34. for($i = 1 ; $i < count($rawdata[0]); $i += 2){
  35.  
  36. next($rawdata[0]);
  37.  
  38. echo "<th><b>".key($rawdata[0])."</b></th>";
  39.  
  40. next($rawdata[0]);
  41.  
  42. }
  43.  
  44. for($i = 0; $i < $filas; $i++){
  45.  
  46. echo "<tr>";
  47.  
  48. for($j = 0; $j < $columnas; $j++){
  49.  
  50. echo "<td>".$rawdata[$i][$j]."</td>";
  51.  
  52. }
  53.  
  54. echo "</tr>";
  55. }
  56.  
  57. echo '</table>';
  58.  
  59. }
  60.  
  61. ?>
Add Comment
Please, Sign In to add comment