473,394 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Convert SQL server data to XML using PHP

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
7 3188
ronverdonk
4,258 Expert 4TB
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
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
4,258 Expert 4TB
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
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
4,258 Expert 4TB
Can I assume that you can get on with what you have or do you need more information?

Ronald :cool:
Jan 23 '07 #6
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
4,258 Expert 4TB
Okay, see you around.

Ronald :cool:
Jan 24 '07 #8

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

Similar topics

1
by: Robert | last post by:
I just tried to convert a (hugh size) ftp.retrbinary run into a pseudo-file object with .read(bytes) method in order to not consume 500MB on a copy operation. First I thought, its easy as usual...
1
by: SD | last post by:
Hi, This is driving me nuts, I have a table that stores notes regarding an operation in an IMAGE data type field in MS SQL Server 2000. I can read and write no problem using Access using the...
5
by: Andrew V. Romero | last post by:
At work we have an excel file that contains the list of medications and their corresponding strengths. I would like to save the excel file as a text list and paste this list into a javascript...
25
by: cory | last post by:
Hi, I have an Access database and am having an ASP.NEt application written for it. It is almost complete. I have a hosting company that I signed up with a month ago but before I did anything I...
5
by: manmit.walia | last post by:
Hello All, I am stuck on a conversion problem. I am trying to convert my application which is written in VB.NET to C# because the project I am working on currently is being written in C#. I tried...
29
by: Jan | last post by:
Hi: I have an Access database that's been running (in one form or another) for a couple of different clients for a few years. Now a new client has requested that it be implemented with a SQL...
15
by: angellian | last post by:
Sorry to raise a stupid question but I tried many methods which did work. how can I conserve the initial zero when I try to convert STR(06) into string in SQL statment? It always gives me 6...
6
by: tshad | last post by:
Apparently, I can't do: Dim da2 As New OleDb.OleDbDataAdapter("Select PR, Convert(varchar,getchar(),1),F1, F2, F5, Sum(F4) from temp .... I am getting this error. 'undefined function...
0
daJunkCollector
by: daJunkCollector | last post by:
Hey, I found the following code and I am attempting to convert it so that it works in conjunction with my MS Access database: using System; using System.Data; using...
5
by: sonu | last post by:
hey good morning ...... how to convert a video file in .flv format in php for linux hosting......is there any package whis provide this facility . Can i use ffmpeg for linux hosting...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.