Re: Database creating from XML file
| From: | Seung Hwan Kang | Date: | Wed, 06 Nov 2002 06:02:56 +0000 |
| Subject: | Re: Database creating from XML file | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-122942@lists.php.net to get a copy of this message | ||
Another idea of doing this task is using XSLT. XML file can be tranformed
to a text SQL file, then it can be called by PHP scripts. That can't be
hard to do that if you know XSLT.
"Bernardo De Barros Franco" <bfranco@qwc.com.br> wrote in message
news:20021105203656.93604.qmail@pb1.pair.com...
> Hello PHP users,
>
> I've recently tried to find info about creating databases from XML files
and
> didn't find anything. Since there is no php.XML I'm posting it in the
> general section.
> Does anyone know where I can find PHP source code that will parse an XML
> file and generate SQL queries that would create tables based on the
> structure described on the XML?
> Something like:
> xml = "
> <Database name='db1'>
> <Table name='Table1'>
> <Attribute name='foo1' type='int4' />
> </Table>
> </Database>
> ";
> and some function func(xml) would return a set of SQL queries that would
> create that database in a particular DB (say PostgreSQL or MySQL).
> Anything similar would help already.
>
> Thanks in advance,
> Bernardo de Barros Franco
>
>