$grid->AddCell("Date"); $grid->SetCellAttr("colspan", 2); $grid->AddHeadingRow(true); $grid->AddCell("Order"); $grid->AddCell("Customer"); $grid->AddCell("Name"); $grid->AddCell("City"); $grid->AddCell("Country"); $grid->AddCell("Order"); $grid->AddCell("Ship"); if (OpenDB()) { $sqltext = "select OrderID,CustomerID,ShipName,ShipCity,ShipCountry,OrderDate,ShippedDate from orders order by OrderID"; $rsMain = $oDB->RunQuery($sqltext); $colcnt = $oDB->db->NumFields($rsMain); while ($oDB->db->FetchRow($rsMain, $row)) { $grid->AddDataRow(); for ($i = 0; $i < $colcnt; $i++) { $v = utf8_encode($row[$i]); $v = htmlspecialchars($v, ENT_COMPAT, 'UTF-8'); $grid->AddCell($v); } } $oDB->rsClose($rsMain); } $grid->Render("ex3", 1); // output html ?> </body> </html>
$grid = new SimpleGrid(); $grid->AddHeadingRow(true); for ($c = 1; $c <= $numcol; $c++) { $grid->AddCell("Column {$c}"); } for ($r = 1; $r <= 100; $r++) { $grid->AddDataRow(); $grid->AddCell($r); for ($c = 2; $c <= $numcol; $c++) { $grid->AddCell("Cell {$r}:{$c}"); } } $fmt = isset($_GET["fmt"]) ? $_GET["fmt"] : ""; switch (strtolower($fmt)) { case "xl": $grid->RenderExcel("rico.xls"); break; case "csv": $grid->RenderDelimited("rico.csv", ",", ""); break; default: $grid->Render("ex1", 1); // output html break; } ?> </body> </html>
function DisplayForm() { $grid = new SimpleGrid(); // define heading $grid->AddHeadingRow(true); $grid->AddCell("A"); $grid->AddCell("B"); $grid->AddCell("A + B"); $grid->AddCell("A x B"); // define data for ($r = 3; $r <= 9; $r += 2) { $a = $r; $b = $r - 2; $grid->AddDataRow(); $grid->AddCell($a); $grid->AddCell($b); $grid->AddCell("<input type='text' size='3' name='p_" . $a . "_" . $b . "'>"); $grid->AddCell("<input type='text' size='3' name='t_" . $a . "_" . $b . "'>"); } echo "<div id='explanation'>This example shows how to use a SimpleGrid within a form.</div>"; echo "<p><strong>Try this simple math quiz:</strong>"; echo "<p><form method='post'>"; echo "<input type='hidden' name='action' value='calc_result'>"; echo "<input type='submit' value='Submit Answers'><p>"; $grid->Render("ex1", 2); echo "</form>"; }