Advertisement
GWibisono

isenk.. test aja

Jan 27th, 2014
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.58 KB | None | 0 0
  1. <?php
  2. $table='test';
  3. $sql='select * from $table limit 30';
  4. include "koneksi.php";
  5. $q=$mysqli->query($sql);
  6. if(!$q)
  7.     {  
  8.         if($pass==0)
  9.             die($mysqli->error."<br>$sql");
  10.     }else{
  11. }
  12. $n=0;
  13. $s="<table>";
  14. while($r = $q->fetch_assoc())
  15. {
  16.    if($n==0){ $s.="<tr>";
  17.     foreach($r as $nm=>$val){
  18.        $s.="<th>$nm</th>";
  19.        $s2.="<td>".$val."</td>";
  20.     }
  21.     $s.="</tr>";
  22.      $s.="<tr>$s2</tr>";
  23.      $s2-'';
  24.   }else{
  25. //ngak ada header
  26.     $s.="<tr>";
  27.      foreach($r as $nm=>$val){
  28.        
  29.        $s.="<td>".$val."</td>";
  30.     }
  31.       $s.="</tr>";
  32.    }
  33. echo $s;$s='';
  34. }
  35. echo '</table>';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement