PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- #Получаем количетво столбцов
- $sql="SHOW COLUMNS FROM ".$table."";
- $rows = $this->db->fetch_array($sql);
- $sHtml="<table width=\"100%\" border=\"1\" ><thead><tr>";
- foreach($rows as $record){
- $sHtml.= "<td>".$record['Field']."</td>";
- }
- $sHtml.="</tr></thead><tbody>";
- $sql="SELECT * FROM ".$table." ";
- $rows = $this->db->fetch_array($sql);
- foreach($rows as $record1){
- $sHtml.="<tr>";
- for($n=0; $n<$iCount; $n++)
- $sHtml.= "<td>".$record[$i]."</td>";
- ++$i;
- $sHtml.="</tr>";
- }
- $sHtml.="</tbody></table>";
- echo $sHtml;