Home >Backend Development >PHP Tutorial >Create XML_PHP tutorial with MySQL and PHP
Create XML_PHP tutorial with MySQL and PHP
- WBOYOriginal
- 2016-07-13 17:31:54884browse
xml (standardization is getting closer) emerged as a data exchange standard. Both Java and .NET have built-in support for xml (standardization is getting closer) , but developers on other platforms don't have to worry about being left behind by this technology. PHP (as the current mainstream development language) is a popular scripting environment that supports xml (standardization is getting closer) .
In this article, I will introduce to you the use of tools such as php(as the current mainstream development language) and MySQL(the best combination with PHP) Such open source tools to handle the process of xml (standardization is getting closer) . I will use the example of executing a MySQL(best combination with PHP) query and formatting the data obtained from the query into xml(standardization is getting closer) Explain. Finally, before diving into writing code, I'll explain how to write xml(standardization is getting closer) to a file and detect system settings.
In order to run the code given in this article, you need to be able to run php (as the current mainstream development language) and MySQL (the best combination with PHP ), and to take full advantage of these examples, you'll also need to know the hostname, username, and password. The format of the MySQL(best combination with PHP) database in the example is shown in Figure A. Let's see how to use php(as the current mainstream development language) to connect to the database.
Picture A
Use php(as the current mainstream development language)Establish a database connection
The following php(as the current mainstream development language) Development language) The script establishes a connection to the database and executes a query:
(as the current mainstream development language)
$db_name = "xrandomusa_4 ";
$connection = MySQL(The best combination with PHP)_connect("MySQL(The best combination with PHP).somewhere.com", " username", "password") or die("Could not connect.");
$table_name = pages;
Query MySQL(with PHP The best combination with PHP
After the MySQL connection is established, you must use the connection to create the current database. The following code is used to complete this task: $db = MySQL
(The best combination with PHP)
_select_db($dbName, $link);Now, use a SQL statement to select all rows in
$table_name
: $query = "select * from " . $table_name;
If necessary, you can then Add attributes. Now, execute the query as follows:
$result = MySQL
(The best combination with PHP)
_query($query, $connection) or die("Could not complete database query");$num = MySQL(The best combination with PHP)
_num_rows($result);You can use php
(as the current mainstream development language)
.net website for reference material on all MySQL(best combination with PHP) functions.
Build and write xml
Now, you should be done Creation of new xml
(standardization is getting closer) document preparation. There are many ways to do this, but I think the method used in Listing A will serve most purposes. Now we introduce this process in detail. The variable
num
indicates whether the data row you query appears or not. It is used for MySQL(the best combination with PHP) and MySQL(the best combination with PHP). The best combination)_num_rows function is testable. The variable $file contains a pointer, which points to php(as the current mainstream development language)The results.xml was successfully searched in the file system(standardization is getting closer)The generated file object. If you find result.xml(standardization is getting closer), then create your php(as the current mainstream development language) file object and the specified file, and its attributes are writable. Now you can print the contents of a variable to the created file (since your directory has been set up to allow php(as the current mainstream development language) to write files, there is no problem in doing so) . Note that from a security perspective, this is actually stupid to do in actual application development. To ensure that you can safely implement the concepts covered in this article, you should provide the full path to the file you wish to open and write, and ensure that the file is located in your web root directory.
Then, php
(as the current mainstream development language)
'sMySQL(the best combination with PHP)_fetch_array function Convert the query variable $result into an array and loop by its keys. If pgaeTitle is in the column returned by the query, the return value for each row is written to the string variable $_xml (standardization is getting closer) Enter some text. Note the operator ".=" (which is used to splice strings in xml
(standardization is getting closer)
format as numerical values) to read $row . When the loop ends, the root xml(Standardization is getting closer) node is printed to the variable $_xml(Standardization is getting closer) , all variables are written into the file.xml (standardization is getting closer) file using the fwrite function of php (as the current mainstream development language) among. Now, a link appears on the screen. Make sure this link points to the path of your xml
(Standardization is getting closer)
file, otherwise you won't be able to see this formatted xml(Standardization is getting closer)( This file is generated using php(as the current mainstream development language) to process MySQL(the best combination with PHP) query).