<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>
