PHP DataGrid implementation code_PHP tutorial

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. PHP program introduction
phpMyDataGrid is mainly through phpmydatagrid.class.php, dgscripts .js is implemented, the total amount is less than 100kB, and it is a compact 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");//Encrypted string
$objGrid->salt("Myc0defor5tr0ng3r-Pro3EctiOn");
$objGrid->language("en");
//The function keys displayed in the last column, from left to right, have the functions of "Add key", "Edit key", "Delete key" and "Browse key".
$objGrid->buttons(true,true,true,true);
//Form name generated when modifying the value
$objGrid->form('employee', true);
//Searchable column name
$objGrid->searchby("name,lastname");
//Table to be read
$objGrid->tabla("employees");
//The index value is used to modify the data
$objGrid->keyfield("id");
//The number of rows displayed in paging
$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 to mode
$objGrid->FormatColumn when editing ("status", "Status", 5, 5, 0, "60", "left", "select:1_Single:2_Married:3_Divorced");
//Can be customized to mode when editing
$objGrid->FormatColumn("active", "Active", 2, 2, 0,"50", "center", "check:No:Yes");//Custom currency display form
$objGrid->FormatColumn("salary", "Salary", 10, 10, 0, "90", "right", "money:€");//Display the data in a histogram
$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, the main method is to modify the function connected to MySQL in phpmydatagrid.class.php to Oracle. This article is through sqlrelay (please refer to http://sqlrelay.sourceforge.net/ ), of course you can also use the OCI8 module that comes with PHP (somewhat inefficient). After modification, save it as phporadatagrid.class.php and 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

http://www.bkjia.com/PHPjc/320387.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/320387.htmlTechArticleSince 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...