datagridcolumnstyle rewrites the PHP DataGrid implementation code

Since it needs to be connected to Oracle, I personally feel that phpMyDataGrid is relatively easy to get started with in terms of secondary development and page style. This article first introduces the usage based on MySQL, and then briefly introduces the secondary development of Oracle connection (based on sqlrelay).
1. Create test database and tables

Copy code The code is as follows:

create database `guru`;
USE `guru`;
CREATE TABLE `employees` (
`id` int(6) NOT NULL auto_increment,
`name` char(20) default NULL,
`lastname` char(20) default NULL,
`salary` float default NULL,
`age` int(2) default NULL,
`afiliation` date default NULL,
`status` int(1) default NULL,
`active` tinyint(1) default NULL,
`workeddays` int(2) default NULL,
`photo` char(30) default NULL,
PRIMARY KEY ( `id`)
)
insert into `employees`
(`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`, `photo`)
values ​​(1, 'Ana', 'Trujillo',2000,45, '2005-05-13',1,1,10, '1.jpg');
insert into `employees`
( `id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)
values ​​(2, 'Jennifer', ' Aniston',3500,23, '2004-10-22',1,0,0, '2.jpg');
insert into `employees`
(`id`,`name`,`lastname`,`salary `,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)
values ​​(3, 'Michael', 'Norman',1200,19, '2007-01-10' ,1,1,5, '3.jpg');
insert into `employees`
(`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`, `active`,`workeddays`,`photo`)
values ​​(4, 'Vanessa', 'Black',6500,31, '2000-11-05',1,1,30, '4.jpg');
insert into `employees`
(`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)
values (5, 'Michael', 'Strauss',3200,45, '2006-10-21',2,0,22, '5.jpg');
insert into `employees`
(`id`,`name `,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)
values ​​(6, 'William', 'Brown',2300,21 , '2001-03-10',3,1,10, '6.jpg');
insert into `employees`
(`id`,`name`,`lastname`,`salary`,`age`, `afiliation`,`status`,`active`,`workeddays`,`photo`)
values ​​(7, 'Lucca', 'Normany',2800,36, '2006-10-02',3,1,20 , '7.jpg');

2. Introduction to PHP program
phpMyDataGrid is mainly implemented through phpmydatagrid.class.php and dgscripts.js. The total amount is less than 100kB, and it is a small software. I won’t go into detail about these two documents. Interested students can “pack them away” and go back to read them slowly. It mainly introduces how to use the software, namely the example datagrid_for_mysql.php. Let’s take a look at the page diagram first:

Program explanation:

Copy the code The code is as follows:

include ("phpmydatagrid.class.php");
$objGrid = new datagrid;
$objGrid->closeTags(true);
$objGrid->friendlyHTML();
$objGrid- >methodForm("get");
//Connect to the database
$objGrid->conectadb("127.0.0.1", "root", "root", "guru");//Encrypt string
$objGrid- >salt("Myc0defor5tr0ng3r-Pro3EctiOn");
$objGrid->language("en");
//The function keys displayed in the last column, from left to right, are "new key" and "edit key" , "Delete key", "Browse key".
$objGrid->buttons(true,true,true,true);
//Form name generated when modifying the value
$objGrid->form('employee', true);
//Retrieval of column names
$objGrid->searchby("name,lastname");
//The table that needs to be read
$objGrid->tabla("employees");
//The index value is used to modify the data
$objGrid-> keyfield("id");
//The number of rows displayed in pagination
$objGrid->datarows(20);
//Default sorting method
$objGrid->orderby("name", "ASC");
/ /Display column settings, related settings can refer to phpmydatagrid.class.php
$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");//Custom date format
$objGrid->FormatColumn("afiliation", "Afiliation Date", 10, 10, 0, "100", "center", "date:dmy:/");//Can be customized as Mode
$objGrid->FormatColumn("status", "Status", 5, 5, 0, "60", "left", "select:1_Single:2_Married:3_Divorced");
//Can be edited when editing Customized as mode
$objGrid->FormatColumn("active", "Active", 2, 2, 0,"50", "center", "check:No:Yes");//Auto Define currency display format
$objGrid->FormatColumn("salary", "Salary", 10, 10, 0, "90", "right", "money:€");//Display data in a bar chart
$objGrid->FormatColumn("workeddays", "Work days", 5, 2, 0, "50", "right", "chart:percent:val:31");
$objGrid->checkable() ;
$objGrid->setHeader();
$objGrid->ajax('silent');
echo '

';
//Generate DataGrid
$objGrid->grid();
echo '

> ;';//Close the database connection
$objGrid->desconectar();
?>

3. Based on Oracle introduction

For Oracle reading, phpmydatagrid.class is mainly used. The function that connects to MySQL in PHP is modified to Oracle. This article is an Oracle connection through sqlrelay (please refer to http://sqlrelay.sourceforge.net/). Of course, you can also use the OCI8 module that comes with PHP (somewhat efficient Low), after modification, save it as phporadatagrid.class.php and then call it in other programs (datagrid_for_oracle.php). All programs mentioned above can be found in compressed packages.
Hope it’s useful to everyone!
4. Source program download

The above introduces the datagridcolumnstyle rewriting PHP DataGrid implementation code, including the content of datagridcolumnstyle rewriting. I hope it will be helpful to friends who are interested in PHP tutorials.