Menu
Community /Pin to ProfileBookmark
@NogDogJun 15.2011 — #
dynamic table
Hi!
I have a problem with my php code.
I have a query that return me some records (the number of records can change).
I need a page html that show me that record and put result in a table.
How can create this table with my php?
I need 7 record for each row. Can you help me to build my table with php?
An if number of record for each line become 5? Is possible modify easily my html table?
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogJun 15.2011 — #[code=php]
$numColumns = 7; // number of columns in table
$sql = "SELECT * FROM table_name";
$result = mysql_query($sql);
$data = array();
while($row = mysql_fetch_assoc($result)) {
$data[] = $row;
}
$chunks = array_chunk($data, $numColumns);
echo "<table>n";
foreach($chunks as $chunk) {
echo "<tr>n";
foreach($chunk as $col) {
echo "<td>".$col['some_field']."</td>n";
}
// this for() loop only needed if you want to fill out last row with
// empty cells:
for($ix = 0, $max = $numColumns - count($chunk); $ix < $max; $ix++) {
echo "<td> </td>";
}
echo "</tr>n";
}
echo "</table>";
[/code]