Обсуждение: Parsing XML data into PostgreSQL using PHP

Hi,

It would be great helpful for me to know, how to parse the data which
in xml format (.xml) into PostgreSQL using PHP or in any other way.

Scenario: I have the data in .xml format with properly defined tag.  I
want to upload the data into postgreSQL.  Can i use PHP ? if So I want
to know the syntax / reference (URL..).  If PHP is not ideal one,
suggest me some other way to proceed.

Thanks in advance.

Awaiting for your earliest response

Shanker.K

Shanker wrote:


> It would be great helpful for me to know, how to parse the data which
> in xml format (.xml) into PostgreSQL using PHP or in any other way.
>
> Scenario: I have the data in .xml format with properly defined tag.  I
> want to upload the data into postgreSQL.  Can i use PHP ? if So I want
> to know the syntax / reference (URL..).  If PHP is not ideal one,
> suggest me some other way to proceed.


I don't know about PHP, but when it comes to XML processing I'm
a believer in XSLT. You can use JDBC from Java-based XSLT processors
(e.g. saxon, xalan.)

good luck,
-Gunther




--
Gunther Schadow, M.D., Ph.D.                    gschadow@regenstrief.org
Medical Information Scientist      Regenstrief Institute for Health Care
Adjunct Assistant Professor        Indiana University School of Medicine
tel:1(317)630-7960                         http://aurora.regenstrief.org