Ejemplo n.º 1
0
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
$objGrid->closeTags(true);
$objGrid->friendlyHTML();
$objGrid->methodForm("get");
$objGrid->conectadb("127.0.0.1", "phpclasses", "test", "guru");
$objGrid->salt("Myc0defor5tr0ng3r-Pro3EctiOn");
$objGrid->language("en");
$objGrid->buttons(true, false, true, false);
$objGrid->form('employee', true);
$objGrid->searchby("name,lastname");
$objGrid->tabla("employees");
$objGrid->keyfield("id");
$objGrid->datarows(20);
$objGrid->orderby("name", "ASC");
$objGrid->FormatColumn("id", "ID Employee", 5, 5, 1, "50", "center", "integer");
$objGrid->FormatColumn("name", "Name", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("lastname", "Last name", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("age", "Age", 5, 5, 0, "50", "right");
$objGrid->FormatColumn("afiliation", "Afiliation Date", 10, 10, 0, "100", "center", "date:dmy:/");
$objGrid->FormatColumn("status", "Status", 5, 5, 0, "60", "left", "select:1_Single:2_Married:3_Divorced");
$objGrid->FormatColumn("active", "Active", 2, 2, 0, "50", "center", "check:No:Yes");
$objGrid->FormatColumn("salary", "Salary", 10, 10, 0, "90", "right", "money:€");
$objGrid->FormatColumn("workeddays", "Work days", 5, 2, 0, "50", "right", "integer");
$objGrid->checkable();
if (!isset($_REQUEST["DG_ajaxid"])) {
    // If we intercept an AJAX request from page
Ejemplo n.º 2
0
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("inventory_config_types");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("total_qty");
$objGrid->searchby("table_index,factory_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->buttons(true, true, true, true);
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("অভিযাত্রী সুজ বিক্রি তথ্য");
$objGrid->FooterGrid("");
Ejemplo n.º 3
0
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("banks");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->searchby("table_index,bank_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->buttons(true, true, true, true);
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("অভিযাত্রী সুজ");
$objGrid->FooterGrid("");
$objGrid->datarows(30);
Ejemplo n.º 4
0
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("other_expenses");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->searchby("table_index,expense_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->buttons(true, true, true, true);
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("অভিযাত্রী সুজ");
$objGrid->FooterGrid("");
$objGrid->datarows(30);
Ejemplo n.º 5
0
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("inventory");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("total_qty");
$objGrid->searchby("table_index,factory_name,pid");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->tabla("inventory");
$objGrid->buttons(true, true, true, true);
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("অভিযাত্রি ইনভেন্টরি");
Ejemplo n.º 6
0
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyDatagrid - Sample file</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry_beta_v2");
/* Select the table to use */
$objGrid->tabla("factories");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("table_index");
$objGrid->searchby("table_index,factory_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->tabla("factories");
$objGrid->buttons(true, true, true, true);
$objGrid->keyfield("table_index");
$objGrid->salt("Some Code4Stronger(Protection)");
Ejemplo n.º 7
0
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("purchase_memos");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("total_qty");
$objGrid->searchby("table_index,factory_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->buttons(true, true, true, true);
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("phpMyDataGrid Sample page");
$objGrid->FooterGrid("");
Ejemplo n.º 8
0
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("bank_log");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->searchby("table_index,bank_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->buttons(true, true, true, true);
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("অভিযাত্রী সুজ");
$objGrid->FooterGrid("");
$objGrid->datarows(30);
Ejemplo n.º 9
0
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("other_expense_log");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->searchby("table_index,expense_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->buttons(true, true, true, true);
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("অভিযাত্রী সুজ");
$objGrid->FooterGrid("");
$objGrid->datarows(30);
Ejemplo n.º 10
0
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("sell_memos");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("total_qty");
$objGrid->searchby("table_index,factory_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->buttons(true, true, true, true);
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("অভিযাত্রী সুজ বিক্রি তথ্য");
$objGrid->FooterGrid("");
Ejemplo n.º 11
0
<?php

include "phporadatagrid.class.php";
$objGrid = new datagrid();
$objGrid->closeTags(true);
$objGrid->friendlyHTML();
$objGrid->methodForm("post");
$objGrid->conectadb();
$objGrid->salt("Myc0defor5tr0ng3r-Pro3EctiOn");
$objGrid->language("en");
$objGrid->buttons(true, true, true, false);
$objGrid->form('Add', true);
$objGrid->searchby("ID,NAME,LASTNAME,AGE,SALARY");
$objGrid->tabla("EMPLOYEES");
$objGrid->keyfield("ID");
$objGrid->orderby("ID", "ASC");
$objGrid->FormatColumn("ID", "ID", 5, 5, 1, "50", "center", "integer");
$objGrid->FormatColumn("NAME", "Name", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("LASTNAME", "Last Name", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("AGE", "Age", 5, 5, 0, "50", "right");
$objGrid->FormatColumn("SALARY", "Salary", 10, 10, 0, "90", "right", "2");
$objGrid->setHeader();
echo '<div align="center"><br />';
$objGrid->ajax('silent');
$objGrid->grid();
$objGrid->desconectar();
echo '</div>';