(
`id`
,
`name`
,
`lastname`
,
`salary`
,
`age`
,
`afiliation`
,
`status`
,
`active`
,
`worke
ddays`
,
`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`
,
`worke
ddays`
,
`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`
,
`worke
ddays`
,
`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`
,
`worke
ddays`
,
`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`
,
`worke
ddays`
,
`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`
,
`worke
ddays`
,
`photo`
)
values
(
7
,
'Lucca'
,
'Normany'
,
2800
,
36
,
'2006-10-02'
,
3
,
1
,
20
,
'7.jpg'
);
2. PHP 程序介绍
phpMyDataGrid 主要是通过 phpmydatagrid.class.php,dgscripts.js 来实现的,
总共加起来不到 100kB,又是一个小巧的软件。对于这两个文件就不多讲了,感兴趣的
“
”
同学可以 打包带走 回去慢慢品。主要介绍该软件的使用方法,即实例
datagrid_for_mysql.php。先看一下页面示意图: