Combining PHP with XML, XSLT, and MySQL_PHP Tutorial

1 Combination application of php with XML, XSLT and Mysql, installation
I often see posts from users asking about the combination of php, XML, and databases, and I also often see some beginners
I mixed PHP code and HTML code together, and then couldn’t find the error when an error occurred. I was so anxious that I will explain it below
Let me talk about how to use XML technology to separate HTML code and PHP programs. Of course, there are many separation technologies, such as PEAR
IT template.
Generally speaking, I personally think that using XML technology is the most convenient. Without further ado, let’s get down to business,
Let’s talk about the installation under win2000

Using xml and xslt in php requires some dll libraries,
extension=php_domxml.dll //Function library for operating XML
extension=php_iconv.dll //For transcoding, such as converting ?????? to UTF-8
extension=php_xslt.dll //XSLT function library

When using the above three libraries, you need to add the dlls directory in the PHP installation directory to the path, otherwise it will not be found

of these libraries
In the following courses, we will use the PEAR class library in php, mainly using the DB class library and Sql2XML class library. You can find it in
Download the latest version from pear.php.net
After downloading the above two class libraries, it is best to set them in php.ini
include_path = ".;d:phppear"

d:phppear is the installation path of my pear

After setting up, restart the machine, otherwise Apache will not start properly because the path cannot be found and cannot be used normally


At this point, the settings for using XML and XSLT in PHP are complete, 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/libicon... About the source code of Iconv

2. Combination application of php with XML, XSLT and Mysql, primary level
What I want to talk about below is a simple process of extracting data from the database, generating XML documents, and converting them into HTML using XSLT,
This process only talks about the process of using this technology, and 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:
#
# Structure of data table `yhxx`
#

CREATE TABLE yhxx (
nsrnm varchar(15) NOT NULL default '',
qymc varchar(200) NOT NULL default '',
qydh varchar(50) NOT NULL default '',
PRIMARY 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', 'Emerald Art Company', '54861465');


Next, I started writing the program to extract the data and the page to display the data
In order to make everyone understand, I use the simplest method to write the program

Program file name: browesData.php
Page file name: browesData.html
The program and page files are available for download. This program has been tested under win2000 and mysql
See the code on the next page


If you are interested in this technology, I will tell you about the deeper application of combining php with xml, xslt, and database

?>
getMessage()); //Connection failed, output error message
}

//The following two are public functions
/**
* Read xsl document
*
* @param String $filename - the name of the xsl file
* @return string

http://www.bkjia.com/PHPjc/631887.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631887.htmlTechArticleThe combined use of php with XML, XSLT, and Mysql. In the installation article, I often see users asking questions about php and Posts on the combined use of XML and databases, I often see some beginners combining php code with...