经常看到有用户问一些关于php(做为现在的主流开发语言)与xml(标准化越来越近了)、数据库结合运用的贴子,也经常看到一些初学者
把php(做为现在的主流开发语言)代码与HTML代码混写到一起,然后在出错的时候找不到错误,急得团团转,下面我就给大
家讲一下如何用xml(标准化越来越近了)技术将HTML代码和php(做为现在的主流开发语言)程序分离,当然,分离的技术有好多种,比如PEAR中
的IT模板.
总的来说,个人认为使用xml(标准化越来越近了)技术是最方便的,废话不多说了,我们言归正传,
讲一下在win2000下的安装
Use xml in php (as the current mainstream development language) (standardization is getting closer) and xslt need to use some dll libraries,
extension =php(as the current mainstream development language)_domxml(Standardization is getting closer).dll //Operation xml(Standardization is getting closer)’s function library
extension=php (as the current mainstream development language) _iconv.dll // Used for transcoding, such as converting GB2312 to UTF-8
extension =php(as the current mainstream development language)_xslt.dll //XSLT function library
When using the above three libraries, you need to use php( For the current mainstream development languages) The dlls directory in the installation directory is added to the path, otherwise it will not be found
These class libraries
In the following courses, we will use php (As the current mainstream development language) The PEAR class library in mainly uses the DB class library, Sql2xml(standardization is getting closer) class library, you can find it in
pear.php (as the current mainstream development language) Download the latest version on .net
After downloading the above two class libraries, it is best to download the latest version in php (as the current mainstream development language) Set include_path = ".;d:php
(as the current mainstream development language).ini"pear"
d: php
(as the current mainstream development language)pear is the installation path of my pear >(The most popular WEB server platform on the Unix platform)
Starts abnormally and cannot be used normally
At this point, you have to use php
(as the current mainstream development language)
The xml
(standardization is getting closer) and the XSLT settings are completed, isn’t it very simple:) Users using Linux can go to http://www.gingerall. com/Download the source code about XSLt http://www.gnu.org/software/libiconv/Download the source code about Iconv
2 php
(as the current mainstream development language)
The combined use of xml
(standardization is getting closer), It is a simple process of extracting data from the database, generating xml (standardization is getting closer) document, and converting it into HTML using XSLT. This process only talks about the process of using this technology , will not involve other technologies such as paging For this example, I use the following database table and data
Table name: Enterprise user information table, English name: yhxx Table structure: #
#The structure of the data table `yhxx`
#
CREATE TABLE yhxx (
nsrnm varchar(15) NOT NULL default,
qymc varchar(200) NOT NULL default,
qydh varchar(50) NOT NULL default ,
Prima
(The most complete virtual host management system)
RY KEY (nsrnm)
) TYPE=MyISAM COMMENT=User information table;
#
# Data table content `yhxx` #
INSERT INTO yhxx VALUES (310109040111985, Qiaojia Catering Development Co., Ltd., 8621-63346626);
INSERT INTO yhxx VALUES (310104040221736, Shanghai Jialing Trading Co., Ltd., 74292546);
INSERT INTO yhxx VALUES (310108040331576, Jade Art Company, 54861465);
Next I will start Write programs and displays for extracting data Data page