PHP datagrid::orderby示例

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

示例#2

显示文件

文件： sample6.php 项目： n-sakib/avijatryerp

$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'>&copy; 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();
$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->setHeader();
?>
</head>

示例#3

显示文件

文件： sample15.php 项目： n-sakib/avijatryerp

*/
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();

示例#4

显示文件

文件： datagrid_for_oracle.php 项目： u0mo5/app

<?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>';