$sqliteProvider->addColumn("a4", "Country", "Country"); $sqliteProvider->addColumn("a5", "Email", "Email"); $sqliteProvider->setSummaryColumns(array("a1", "a2")); $sqliteProvider->manyToOne("a6", "SupportRepId", "Employee", "EmployeeId", "FirstName", "Support Rep"); $page4->setDataProvider($sqliteProvider); $crud->addPage($page4); $page5 = new BasicDataPage('dummy5'); $page5->setName("Employees"); $empProvider = new SQLiteDataProvider("fixtures/chinook.sqlite"); $empProvider->setTable("Employee"); $empProvider->setPrimaryColumn("b0", "EmployeeId"); $empProvider->addColumn("b1", "FirstName", "First Name"); $empProvider->addColumn("b2", "LastName", "Last Name"); $empProvider->manyToOne("b3", "ReportsTo", "Employee", "EmployeeId", "FirstName", "Reports To"); $empProvider->oneToMany("b4", $sqliteProvider, "SupportRepId", "b0", "Customers"); $empProvider->setSummaryColumns(array("b1", "b2")); $page5->setDataProvider($empProvider); $crud->addPage($page5); $invProvider = new SQLiteDataProvider("fixtures/chinook.sqlite"); $invProvider->setTable("Invoice"); $invProvider->setPrimaryColumn("b0", "InvoiceId"); $invProvider->addColumn("b1", "BillingCountry", "Country123"); $invProvider->addColumn("b2", "Total", "Total123"); $invProvider->addColumn("b3", "InvoiceDate", "InvoiceDate123"); $invProvider->setSummaryColumns(array("b1", "b2", "b3")); $page6 = new BasicDataPage('dummy6'); $page6->setName("Custom Data Types"); $page6->setDataProvider($invProvider); $crud->addPage($page6); $crud->render();
<?php // Require CrudKit application require "crudkit/crudkit.php"; use CrudKit\CrudKitApp; use CrudKit\Pages\HtmlPage; // Create a new CrudKitApp object $app = new CrudKitApp(); // Create a new Page, of type "HtmlPage" which allows you to display arbitrary HTML inside $page = new HtmlPage("mypage1"); // Every page needs to have a unique ID $page->setName("My First Page"); // setName is available for all pages. $page->setInnerHtml("This is page # <b>1</b>"); // You can set the HTML of this page, a feature supported by HtmlPage $app->addPage($page); $page2 = new HtmlPage("mypage2"); $page2->setName("My Second Page"); $page2->setInnerHtml("This is page # <b>2</b>"); $app->addPage($page2); // Render the app. This will display the HTML $app->render();