Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function displayTable($table) {
- $server = "localhost";
- $user = "root";
- $pass = "";
- $table = $table;
- $BD = 'encuestas';
- $conexion = mysqli_connect($server, $user, $pass, $BD);
- if(!$result = mysqli_query($conexion, "SELECT * FROM $table;")) die();
- $rawdata = array();
- $i = 0;
- while($row = mysqli_fetch_array($result)) {
- $rawdata[$i] = $row;
- $i++;
- }
- $close = mysqli_close($conexion);
- echo '<table width="100%" border="1" style="text-align:center;">';
- $columnas = count($rawdata[0])/2;
- $filas = count($rawdata);
- for($i = 1 ; $i < count($rawdata[0]); $i += 2){
- next($rawdata[0]);
- echo "<th><b>".key($rawdata[0])."</b></th>";
- next($rawdata[0]);
- }
- for($i = 0; $i < $filas; $i++){
- echo "<tr>";
- for($j = 0; $j < $columnas; $j++){
- echo "<td>".$rawdata[$i][$j]."</td>";
- }
- echo "</tr>";
- }
- echo '</table>';
- }
- ?>
Add Comment
Please, Sign In to add comment