$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>
$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>
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 // 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(); ?>
$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'>© 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 */
<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>
$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'>© 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>
$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>
//$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();
//$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();
$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>
$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'>© 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");
$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>
//$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>
$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>
<?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>';