Dear Leo and Michael,

$session->execute('OPEN myDB; EXPORT path/to/export.xml;CLOSE myDB;')

Command is not clear to me and where I'll place my xquery ?

But the second one is perfect and its working with xquery.

Thanks for the reply.

Best Regards Nafiz

-----Original Message----- From: Leo Wörteler [mailto:lw@basex.org] Sent: Thursday, February 02, 2012 4:36 PM Cc: Nafiz Al Naharul Islam Grameenphone IT Ltd.; basex-talk@mailman.uni-konstanz.de Subject: Re: [basex-talk] export xml using xquery in php

Hi Nafiz,

Am 02.02.2012 11:13, schrieb Michael Seiferle:

I guess you could use the built in EXPORT command.

...

$session->execute('OPEN myDB; EXPORT path/to/export.xml;CLOSE myDB;')

[...]

Another (again untested :-)) approach might be:

file_put_contents( $filename, $session->execute('XQUERY doc("myDB")') );

one should remark that the first approach would store the XML file on the machine the *BaseX instance* is running on, the second one uses the machine where the *web server* is running. So if these are different in your setup, only one of the snippets will work as expected.

Hope that helps, cheers, Leo

The information contained in this email and any attachment(s) to this email are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient and have received this email and/or its attachment(s) in error, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this email and/or its attachment(s) is strictly prohibited. Please notify the sender immediately and delete this email and any attachments.

WARNING: Computer viruses can be transmitted via email. Although GPIT has taken reasonable precautions to ensure no viruses are present in this email and/or its attachment(s), GPIT does not guarantee that this email and/or its attachments are secure or error-free. The recipient should check this email and any attachment(s) for the presence of viruses. GPIT shall accept no liability whatsoever for any loss or damage arising from the use of this email and/or its attachment(s).

Hi Michael,

I got it in previous but confused about the xquery?? Where and how I can apply xquery using this command? That is actually my question was.

Best Regards Nafiz

From: Michael Seiferle [mailto:michael.seiferle@uni-konstanz.de] Sent: Thursday, February 02, 2012 10:38 PM To: Nafiz Al Naharul Islam Grameenphone IT Ltd. Cc: 'Leo Wörteler'; basex-talk@mailman.uni-konstanz.de Subject: Re: [basex-talk] export xml using xquery in php

Hi Nafiz,

the EXPORT command exports the whole database, hence for the example code below: a file path/to/export.xml would be created on the machine running BaseX, with the serialized results of your database.

Hope this helped clear things up :) Kind Regards Michael Am 02.02.2012 um 16:05 schrieb Nafiz Al Naharul Islam Grameenphone IT Ltd.:

$session->execute('OPEN myDB; EXPORT path/to/export.xml;CLOSE myDB;')

Command is not clear to me and where I'll place my xquery ?

But the second one is perfect and its working with xquery.

________________________________ The information contained in this email and any attachment(s) to this email are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient and have received this email and/or its attachment(s) in error, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this email and/or its attachment(s) is strictly prohibited. Please notify the sender immediately and delete this email and any attachments.

WARNING: Computer viruses can be transmitted via email. Although GPIT has taken reasonable precautions to ensure no viruses are present in this email and/or its attachment(s), GPIT does not guarantee that this email and/or its attachments are secure or error-free. The recipient should check this email and any attachment(s) for the presence of viruses. GPIT shall accept no liability whatsoever for any loss or damage arising from the use of this email and/or its attachment(s).

Hi,

May i export a xml according to my required format ....

Currently using xquery i got following....

<tender ID="01">AA</tender> <tender ID="02">BB</tender>

But i want in following format...

<?xml version="1.0" encoding="ISO-8859-1"?> <tenders> <tender ID="01">AA</tender> <tender ID="02">BB</tender> </tenders>

Is it possible in php and Basex?

Regards Nafiz ________________________________________ From: Christian Grün [christian.gruen@gmail.com] Sent: Friday, February 03, 2012 12:25 AM To: Nafiz Al Naharul Islam Grameenphone IT Ltd. Cc: Michael Seiferle; Leo Wörteler; basex-talk@mailman.uni-konstanz.de Subject: Re: [basex-talk] export xml using xquery in php

Dear Nafiz,

I would recommend you to first have a closer look at our Client Wiki page, which demonstrates how to work with the client code:

http://docs.basex.org/wiki/Clients

Hope this helps, Christian ___________________________

On Thu, Feb 2, 2012 at 6:20 PM, Nafiz Al Naharul Islam Grameenphone IT Ltd. nnislam@grameenphone.com wrote:

Hi Michael,

I got it in previous but confused about the xquery?? Where and how I can apply xquery using this command? That is actually my question was.

Best Regards

Nafiz

From: Michael Seiferle [mailto:michael.seiferle@uni-konstanz.de] Sent: Thursday, February 02, 2012 10:38 PM To: Nafiz Al Naharul Islam Grameenphone IT Ltd. Cc: 'Leo Wörteler'; basex-talk@mailman.uni-konstanz.de

Subject: Re: [basex-talk] export xml using xquery in php

Hi Nafiz,

the EXPORT command exports the whole database, hence for the example code below:

a file path/to/export.xml would be created on the machine running BaseX, with the serialized results of your database.

Hope this helped clear things up :)

Kind Regards

Michael

Am 02.02.2012 um 16:05 schrieb Nafiz Al Naharul Islam Grameenphone IT Ltd.:

$session->execute('OPEN myDB; EXPORT path/to/export.xml;CLOSE myDB;')

Command is not clear to me and where I'll place my xquery ?

But the second one is perfect and its working with xquery.

---

The information contained in this email and any attachment(s) to this email are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient and have received this email and/or its attachment(s) in error, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this email and/or its attachment(s) is strictly prohibited. Please notify the sender immediately and delete this email and any attachments.

WARNING: Computer viruses can be transmitted via email. Although GPIT has taken reasonable precautions to ensure no viruses are present in this email and/or its attachment(s), GPIT does not guarantee that this email and/or its attachments are secure or error-free. The recipient should check this email and any attachment(s) for the presence of viruses. GPIT shall accept no liability whatsoever for any loss or damage arising from the use of this email and/or its attachment(s).

---

BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk

The information contained in this email and any attachment(s) to this email are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient and have received this email and/or its attachment(s) in error, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this email and/or its attachment(s) is strictly prohibited. Please notify the sender immediately and delete this email and any attachments.

WARNING: Computer viruses can be transmitted via email. Although GPIT has taken reasonable precautions to ensure no viruses are present in this email and/or its attachment(s), GPIT does not guarantee that this email and/or its attachments are secure or error-free. The recipient should check this email and any attachment(s) for the presence of viruses. GPIT shall accept no liability whatsoever for any loss or damage arising from the use of this email and/or its attachment(s).