<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("");
$objGrid->datarows(30);
$objGrid->paginationmode('links');
$objGrid->keyfield("table_index");
$objGrid->orderby("table_index", "DESC");
$objGrid->tabla("inventory_config_types");
$objGrid->noorderarrows();
/* Define fields to show */
For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site
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"])) {
"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();
$objGrid->friendlyHTML();
$objGrid->pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("salary,workeddays");
$objGrid->searchby("id,name,lastname,afiliation");
$objGrid->linkparam("sess=" . $_REQUEST["sess"] . "&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
$objGrid->conectadb("127.0.0.1", "phpclasses", "test", "guru");
$objGrid->tabla("employees");
$objGrid->TituloGrid("phpMyDataGrid Sample page");
$objGrid->FooterGrid("<div style='float:left'>© 2007 Gurusistemas.com</div>");
/* Define the number of rows to show per page */
$objGrid->datarows(5);
/* Define the desired pagination style */
$objGrid->paginationmode('links');
/* Define the initial ordering field and its direction */
$objGrid->orderby("age", "DESC");
/* Define that ordering arrows will not be available to users */
$objGrid->noorderarrows();
<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);
$objGrid->paginationmode('links');
$objGrid->keyfield("table_index");
$objGrid->orderby("table_index", "DESC");
$objGrid->noorderarrows();
/* Define fields to show */
$objGrid->FormatColumn("expense_name", "ব্যাংক", 30, 30, 0, "150", "left");
<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);
$objGrid->paginationmode('links');
$objGrid->keyfield("table_index");
$objGrid->orderby("table_index", "DESC");
$objGrid->noorderarrows();
/* Define fields to show */
$objGrid->FormatColumn("bank_name", "ব্যাংক", 30, 30, 0, "150", "left");
<?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>';
