$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>";
}
