หลับหูหลับตา query
posted on 14 Nov 2011 11:37 by reeree in memo<?
$SQL = "SELECT * FROM dbname.tablename ";
$result = $mysqli->query($SQL);
$result = $mysqli->query($SQL);
?>
<table border="1">
<?
if ($result->num_rows)
{// begin if query return some result
#creating table header , and first row
$row = $result->fetch_assoc();
?>
<tr alt="table header" title="table header" bgcolor="#CCCCFF">
<?
foreach ($row as $key => $value)
{
?>
<td> <?echo $key;?> </td>
<?
}
?>
</tr>
<tr>
<?
foreach ($row as $key => $value)
{
?>
<td> <?echo $value;?> </td>
<?
}
?>
</tr>
<?
while($row = $result->fetch_assoc())
{//begin while loop for 2nd row to the end
?>
<tr>
<?
foreach ($row as $key => $value)
{
?>
<td> <?echo $value;?> </td>
<?
}
?>
</tr>
<?
}//end while loop for 2nd row to the end
$result->close();
}// end if query return some result
?>
</table>
<?
?>
</table>
<?