By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,718 Members | 1,349 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,718 IT Pros & Developers. It's quick & easy.

Convert SQL server data to XML using PHP

P: 94
Hi there,
I need to do webdevelopment with XML, is there any way I can get data from a SQL server and 'convert' it to XML and say, save it in a file as file.xml?
Jan 19 '07 #1
Share this Question
Share on Google+
7 Replies


ronverdonk
Expert 2.5K+
P: 4,258
There are some (free) php classes that you can use to accomplish that. Look at the following at www.phpclasses.org:

MySQL to XML
MySQL to XML - XML to MySQL

Good luck!

Ronald :cool:
Jan 19 '07 #2

P: 94
Thanx for your help

How much does SQL and PostGreSQL differ in trying to convert database data to XML using PHP?
Jan 22 '07 #3

ronverdonk
Expert 2.5K+
P: 4,258
Thanx for your help

How much does SQL and PostGreSQL differ in trying to convert database data to XML using PHP?
I don't really understand what you mean? Do you mean the SQL itself or the way to conect and exchange data with the PostGreSQL db?

Anyway, to assist you could probably look at another class http://phpclasses.half2.nl/browse/package/1378.html
that
........ manages connections to a PostgreSQL database server. It comes also with a class to perform SQL queries and retrieve the results.

The connection class can execute queries and manage transactions. It can also create, read, write and delete large objects (LOBs).
So, when necessary, you could adapt the MySQL-XML class to use PostGreSQL instead of MySQL.

Ronald :cool:
Jan 22 '07 #4

P: 94
I don't really understand what you mean? Do you mean the SQL itself or the way to conect and exchange data with the PostGreSQL db?

Anyway, to assist you could probably look at another class http://phpclasses.half2.nl/browse/package/1378.html
that

So, when necessary, you could adapt the MySQL-XML class to use PostGreSQL instead of MySQL.

Ronald :cool:
Sorry, I didin't set myself quite clear.
Yes, the way PostGreSQL exchanges/supplies data into php.
I need to get data/records from PostGreSQL, convert it to XML and then use it in an OpenLaszlo app.
Thank you soooooo much! You are really helping me, especially with the links.
Jan 23 '07 #5

ronverdonk
Expert 2.5K+
P: 4,258
Can I assume that you can get on with what you have or do you need more information?

Ronald :cool:
Jan 23 '07 #6

P: 94
Can I assume that you can get on with what you have or do you need more information?

Ronald :cool:
Thanx, I'm fine
Jan 24 '07 #7

ronverdonk
Expert 2.5K+
P: 4,258
Okay, see you around.

Ronald :cool:
Jan 24 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.