3 回答
TA贡献1796条经验 获得超4个赞
由于您的列位于数组中,因此您可以foreach()在行上方。列的显示要么需要足够好,要么只保留默认值,以使显示看起来合理......
while($row=pg_fetch_assoc($result)){
echo "<tr>";
foreach ( $row as $key => $value ) {
echo "<td align='center' width='200'>" . $value . "</td>";
}
echo "</tr>";
}
TA贡献1943条经验 获得超7个赞
尝试 :
while($row=pg_fetch_assoc($result)){
echo "<tr>";
$maxColumnDisplay = 100;
foreach($row as $col){
if(!$maxColumnDisplay--) break;
echo "<td align='center' width='200'>" . $col . "</td>";
}
echo "</tr>";
}
TA贡献2019条经验 获得超9个赞
尝试这个:
function printTable(&$result) //result set
{
/** Set up Table and Headers **/
$fieldinfo = $result->fetch_fields();
echo '<table class="sqldump">' . "\n";
echo '<tr class="header">' . "\n";
foreach ($fieldinfo as $fieldval) {
echo "<td>".$fieldval->name."</td>\n";
}
echo "</tr>\n";
/** dump rows **/
while($row = $result->fetch_assoc()) {
echo "<tr>";
foreach ($row as $column) {
echo "<td>".$column."</td>\n";
}
echo "</tr>";
}
echo "</table>\n";
/** gc **/
$result->free();
}
- 3 回答
- 0 关注
- 69 浏览
添加回答
举报