$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 */
$objGrid->FormatColumn("genre", "জুতার ধরনের নং", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("type", "জুতার ধরন", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
?>
</body>
</html>
Example #2
0
$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");
$objGrid->FormatColumn("phone", "ফোন", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
?>
</body>
</html>
Example #3
0
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:&euro;");
$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
    // then do not display data below
    echo '<!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=$charset" />' . '<meta name="description" content="Site description" />' . '<meta name="revisit-after" content="8 days" />' . '<meta name="keywords" content="keywords for site" />' . '<meta http-equiv="Pragma" content="no-cache" />' . '<meta name="robots" content="all" />' . '<link rel="shortcut icon" href="images/guru.ico" />' . '<meta http-equiv="Content-Script-Type" content="type" />' . '<link type="text/css" rel="stylesheet" href="./css/styles.css" />' . '<title>phpMyDataGrid Test script</title>';
    $objGrid->setHeader();
    ?>
Example #4
0
$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->buttons(true, true, true, true);
$objGrid->keyfield("id");
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("phpMyDataGrid Sample page");
$objGrid->FooterGrid("<div style='float:left'>&copy; 2007 Gurusistemas.com</div>");
$objGrid->datarows(5);
$objGrid->paginationmode('links');
$objGrid->orderby("age", "DESC");
$objGrid->noorderarrows();
$objGrid->FormatColumn("id", "ID Employee", 5, 5, 1, "50", "center", "integer");
$objGrid->FormatColumn("name", "Name", 30, 30, 0, "150", "left");
/* Text Links: Displaying a text link is only available to show values stored in fields */
/* Note: inputtype must be set to 4 */
$objGrid->FormatColumn("lastname", "Text link", "30", "30", "4", "100", "left", "link:updatepicture(%s%s%s),id,name,lastname");
$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", "2");
$objGrid->FormatColumn("workeddays", "Work days", 5, 2, 0, "50", "right", "integer");
$objGrid->FormatColumn("calc_1", "Value Days", "10", "10", "3", "70", "right", "calc:((salary/30)*workeddays)");
/* Dynamic image: Displaying an image link with a value stored in a field */
/* Note: The %s in the image name will be replaced by the selected field, in this example by photo field */
$objGrid->FormatColumn("photo", "Photo", "25", "0", "0", "150", "center", "imagelink:images/sample/%s:updatepicture(%s%s%s),id,name,lastname");
/* Static image: Displaying an image link with an unique name */
Example #5
0
<title>phpMyDatagrid - Sample file</title>

<?php 
/* Include class file */
include "phpmydatagrid.class.php";
/* Create object */
$objGrid = new datagrid();
/* Define the "FORM" will be named employee and Must be 
   created by the grid script */
$objGrid->form('employee', true);
/* Connect with the database */
$objGrid->conectadb("127.0.0.1", "phpclasses", "test", "guru");
/* Select the table to use */
$objGrid->tabla("employees");
/* Define fields to show */
$objGrid->FormatColumn("id", "ID Employee", 5, 5, 1, "50", "center");
$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");
$objGrid->FormatColumn("active", "Active", 2, 2, 0, "50", "center");
$objGrid->FormatColumn("salary", "Salary", 10, 10, 0, "90", "right");
$objGrid->FormatColumn("workeddays", "Work days", 5, 2, 0, "50", "right");
/* The setHeader function MUST be set between the <HEAD> and </HEAD> 
   to correctly set the CSS and JS parameters */
$objGrid->setHeader();
?>
</head>

<body>
Example #6
0
$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)");
$objGrid->TituloGrid("phpMyDataGrid Sample page");
$objGrid->FooterGrid("<div style='float:left'>&copy; 2007 Gurusistemas.com</div>");
$objGrid->datarows(5);
$objGrid->paginationmode('links');
$objGrid->orderby("table_index", "DESC");
$objGrid->noorderarrows();
/* Define fields to show */
$objGrid->FormatColumn("table_index", "ID Employee", 5, 5, 1, "50", "center");
$objGrid->FormatColumn("factory_name", "Name", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
?>
</body>
</html>
Example #7
0
$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");
$objGrid->FormatColumn("acc_number", "অ্যাকাউন্ট নং", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
?>
</body>
</html>
Example #8
0
//$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("");
$objGrid->datarows(30);
$objGrid->paginationmode('links');
$objGrid->keyfield("table_index");
$objGrid->orderby("table_index", "DESC");
$objGrid->tabla("purchase_memos");
$objGrid->noorderarrows();
/* Define fields to show */
$objGrid->FormatColumn("factory_name", "কারখানার নাম", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("grand_total", "সর্বমোট", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("paid", "জমা", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("due", "বাকি", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("date_bought", "মাল কেনার তারিখ", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("comment", "মন্তব্য", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("purchase_type", "মাল কেনার ধরন", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
Example #9
0
//$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("অভিযাত্রি ইনভেন্টরি");
$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("table_index", "ইনডেক্স", 5, 5, "4", "50", "center");
//inputtype 4 blocks from editing
$objGrid->FormatColumn("factory_name", "কারখানা", 30, 30, "4", "150", "left");
$objGrid->FormatColumn("pid", "আইডি", 30, 30, "4", "150", "left");
$objGrid->FormatColumn("total_qty", "জোড়া", 30, 30, "4", "150", "left");
$objGrid->FormatColumn("cost_price", "ডজন দাম", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("retail_price", "গায়ের দাম", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
//$objGrid -> ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
Example #10
0
$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("date", "তারিখ", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("bank_name", "ব্যাংক", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("deposited", "জমা", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("balance", "উত্তোলন", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("comment", "মন্তব্য", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
?>
</body>
$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_colors");
$objGrid->noorderarrows();
/* Define fields to show */
$objGrid->FormatColumn("color", "জুতার রং", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
?>
</body>
</html>
Example #12
0
$objGrid->decimalPoint(",");
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry_beta_v2");
/* Select the table to use */
$objGrid->tabla("factories");
$objGrid->buttons(true, true, true, true);
$objGrid->keyfield("id");
$objGrid->salt("Some Code4Stronger(Protection)");
$objGrid->TituloGrid("phpMyDataGrid Sample page");
$objGrid->FooterGrid("<div style='float:left'>&copy; 2007 Gurusistemas.com</div>");
$objGrid->datarows(5);
$objGrid->paginationmode('links');
$objGrid->orderby("age", "DESC");
$objGrid->noorderarrows();
/* Define fields to show */
$objGrid->FormatColumn("table_index", "ID Employee", 5, 5, 1, "50", "center");
$objGrid->FormatColumn("factory_name", "Name", 30, 30, 0, "150", "left");
/* Dynamic image: Displaying an image with a value stored in a field */
/* Note: The %s will be replaced by the selected field, in this example by photo field */
$objGrid->FormatColumn("photo", "Photo", "25", "0", "0", "150", "center", "image:images/sample/%s");
/* Static image: Displaying an image with an unique name */
/* Note: inputtype must be set to 3 */
$objGrid->FormatColumn("image_1", "Img", "25", "0", "3", "20", "center", "image:images/sample/money.png");
$objGrid->where("active = '1'");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
Example #13
0
$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("date", "তারিখ", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("expense_name", "ব্যাংক", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("amount", "পরিমান", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("due", "বাকী", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("comment", "মন্তব্য", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
?>
</body>
Example #14
0
//$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("sell_memos");
$objGrid->noorderarrows();
/* Define fields to show */
$objGrid->FormatColumn("company_name", "পার্টির নাম", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("total_qty", "পরিমাণ", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("grand_total", "সর্বমোট বিক্রি", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("paid", "জমা", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("extra_cost", "এক্সট্রা খরচ", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("extra_cost_descr", "বাবদ", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("carry_cost", "পাঠানো খরচ", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("due", "বাকি", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("date_sold", "বিক্রির তারিখ", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("comment", "মন্তব্য", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("sell_type", "বিক্রির ধরন", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("jolap_info", "জোলাপ", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("checked", "চেকড", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>
Example #15
0
$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->noorderarrows();
/* Define fields to show */
$objGrid->FormatColumn("factory_name", "ব্যাংক", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("phone", "ফোন", 30, 30, 0, "150", "left");
$objGrid->FormatColumn("address", "ঠিকানা", 30, 30, 0, "150", "left");
$objGrid->setHeader();
?>
</head>

<body>
<?php 
$objGrid->ajax("silent");
$objGrid->grid();
$objGrid->desconectar();
?>
</body>
</html>
Example #16
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>';