<title>Datagrid Export</title> </head> <body> <?php echo '<h2>PDF Export</h2>'; $dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders"); // change column titles $dg->set_col_title("orderNumber", "Order No."); $dg->set_col_title("orderDate", "Order Date"); $dg->set_col_title("shippedDate", "Shipped Date"); $dg->set_col_title("customerNumber", "Customer No."); // hide a column $dg->set_col_hidden("requiredDate"); // change default caption $dg->set_caption("Orders List"); // EXCEL export $dg->enable_export('PDF'); $dg->display(); echo '<h2>EXCEL Export</h2>'; $dg2 = new C_DataGrid("select * from customers", "customerNumber", "Customers"); // PDF export $dg2->enable_export('EXCEL'); $dg2->display(); echo '<h2>Export Dropdown (PDF, EXCEL, HTML, CSV)</h2>'; $dg3 = new C_DataGrid("SELECT * FROM products", "productCode", "products"); $exportDropdown = <<<EXPORTDROPDOWN \$('#products_pager1_left').append ('<div style=padding-right: 16px;>Export:\\ <select onchange=document.location.href=this.options[this.selectedIndex].value;>\\ <option>---</option>\\ <option value=/phpGridx/export.php?gn=products&export_type=excel>Excel</option>\\
?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>A Basic PHP Datagrid</title> </head> <body> <table> <tr><td> <?php $dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders"); $dg->enable_edit(); $dg->display(); ?> </td> <td> <?php $dg2 = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders"); $dg2->set_jq_gridName('order2'); $dg2->set_caption("order 2"); $dg2->enable_edit(); $dg2->display(); ?> </td></tr> </table> </body> </html>
</ul> </li> <li><a href="404.html">Shop</a></li> <li><a href="contact-us.html">Contact</a></li> </ul> </div> </div> <div class="col-sm-3"> <div class="search_box pull-right"> <input type="text" placeholder="Search"/> </div> </div> </div> </div> </div><!--/header-bottom--> </header><!--/header--> <div class="container"> <div class="row row-centered"> <div class="col-md-8 col-centered"> <?php $dg = new C_DataGrid("SELECT * FROM ratings_list", "fideid", "ratings_list"); $dg->enable_advanced_search(true); $dg->set_caption(''); $dg->display(); ?> </div> </div> </div> </body> </html>
?> <html> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <head> <title> <?php echo iconv('Windows-1253', 'UTF-8', 'Προγράμματα Σχολικών Δραστηριοτήτων $prSxetos'); ?> </title> </head> <body> <?php // declare and prepare phpgrid require_once 'phpgrid/conf.php'; $dg = new C_DataGrid("SELECT id,sch1,titel FROM {$prTable}", "id", "{$prTable}"); $dg->set_locale('el'); $dg->set_caption(mb_convert_encoding("Προγράμματα Σχολικών Δραστηριοτήτων {$prSxetos}", "utf-8", "iso-8859-7")); $dg->set_col_property("id", array("name" => "A/A", "width" => 15)); //$dg ->set_col_property("done", array("name"=>"done", "width"=>15)); //$dg ->set_col_property("agree", array("name"=>"done", "width"=>15)); $dg->set_col_title("id", "A/A"); $dg->set_col_title("sch1", mb_convert_encoding("Όνομα Σχολείου", "utf-8", "iso-8859-7")); $dg->set_col_title("titel", mb_convert_encoding("Τίτλος προγράμματος", "utf-8", "iso-8859-7")); //$dg ->set_col_title("done", mb_convert_encoding("Ξεκίνησε;", "utf-8","iso-8859-7" )); //$dg ->set_col_title("agree", mb_convert_encoding("Δήλ.Ολοκλ.", "utf-8","iso-8859-7" )); $dg->enable_search(true); $dg->set_dimension(1100, 700); $dg->set_pagesize(30); $dg->set_col_dynalink("id", "prog.php", "id"); $dg->set_col_dynalink("titel", "prog.php", "id"); // get data from CAS server if (!$prDebug) {
// Just click 'EXCEL' button at the bottom of the grid... session_start(); if (!$_SESSION['loggedin'] || !$_SESSION['admin']) { die('Access denied'); } header('Content-Type: text/html; charset=utf-8'); ?> <html> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <head> <title> <?php echo iconv('Windows-1253', 'UTF-8', 'Προγράμματα Σχολικών Δραστηριοτήτων - Εξαγωγή'); ?> </title> </head> <body> <?php require_once 'conf.php'; require_once 'phpgrid/conf.php'; $dg = new C_DataGrid("SELECT * FROM {$prTable}", "id", "{$prTable}"); $dg->set_locale('el'); $dg->set_caption(mb_convert_encoding("Προγράμματα Σχολικών Δραστηριοτήτων - Προβολή εξαγωγής", "utf-8", "iso-8859-7")); $dg->set_dimension(1100, 700); $dg->set_pagesize(30); $dg->enable_export('EXCEL'); $dg->display(); ?> <a href="javascript:history.go(-1)">Go back...</a> </body> </html>