php操作MSSQL 无限级分类+分页详细实例
运行环境：PHP5.3 + apache2.2 + mssql 2005 ，为什么要用mssql不用，mysql呢， 因为这里在一个平台上做开发，用友数据整合。。。mysql与mssql语句还是有差别的，至少mssql没有limit。。。http://blog.运维网.com/attachment/201211/210732372.png
http://blog.运维网.com/attachment/201211/210744981.png
这个是必须的，开启一个需要一个ntwdblib.dll链接文件，版本还不能太低，其他的自己百度吧，嘿嘿
[*]CREATE TABLE .(
[*] IDENTITY(1,1) NOT NULL,
[*] (150) NULL,
[*] NULL,
[*] (128) NULL,
[*] NULL CONSTRAINT DEFAULT ((6)),
[*] NULL,
[*] NULL,
[*] CONSTRAINT PRIMARY KEY CLUSTERED
[*](
[*] ASC
[*])WITH (PAD_INDEX= OFF, STATISTICS_NORECOMPUTE= OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS= ON, ALLOW_PAGE_LOCKS= ON) ON
[*]) ON
[*]
[*]INSERT INTO ..(,,,)VALUES(124,'数码产品',0,'0,');
[*]INSERT INTO ..(,,,)VALUES(125,'手机','124','0,124,');
[*]INSERT INTO ..(,,,)VALUES(126,'笔记本电脑',124,'0,124,');
[*]INSERT INTO ..(,,,)VALUES(127,'联想',126,0,124,126,);
[*]INSERT INTO ..(,,,)VALUES(129,'HP',126,'0,124,126,');
[*]INSERT INTO ..(,,,)VALUES(134,'G460',127,'0,124,126,127,');
[*]INSERT INTO ..(,,,)VALUES(133,'书类',0,'0,');
[*]INSERT INTO ..(,,,)VALUES(128,'企业类',0,'0,');
[*]INSERT INTO ..(,,,)VALUES(132,'相机',124,'0,124,');
[*]INSERT INTO ..(,,,)VALUES(130,'联想1',127,'0,124,126,127,');
[*]INSERT INTO ..(,,,)VALUES(131,'联想3',129,'0,124,126,127,129,');
[*]INSERT INTO ..(,,,)VALUES(135,'计算机书',130,'0,130,');
http://blog.运维网.com/attachment/201211/210236749.png
[*]
http://blog.运维网.com/attachment/201211/210422615.png
无限级分类，我只做了一个排序，添加就非常简单了，我也没有做什么递归函数，添加的时候把，Id，e
本文来自我的个人网站：http://www.51net.co/
附件：http://down.运维网.com/data/2361742
页:
[1]