Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $table='test';
- $sql='select * from $table limit 30';
- include "koneksi.php";
- $q=$mysqli->query($sql);
- if(!$q)
- {
- if($pass==0)
- die($mysqli->error."<br>$sql");
- }else{
- }
- $n=0;
- $s="<table>";
- while($r = $q->fetch_assoc())
- {
- if($n==0){ $s.="<tr>";
- foreach($r as $nm=>$val){
- $s.="<th>$nm</th>";
- $s2.="<td>".$val."</td>";
- }
- $s.="</tr>";
- $s.="<tr>$s2</tr>";
- $s2-'';
- }else{
- //ngak ada header
- $s.="<tr>";
- foreach($r as $nm=>$val){
- $s.="<td>".$val."</td>";
- }
- $s.="</tr>";
- }
- echo $s;$s='';
- }
- echo '</table>';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement