Re: [MonetDB-users] Using MonetDB / XQuery with PHP

23 Nov 2006

      Hi Fabian, 

performing SQL and MIL queries succeeds using PHP. 

Not concerning XQuery. Connecting with:

$db = monetdb_connect('xquery');
if (!$db) {
    die('Could not connect with MonetDB/XQuery server');
}
echo 'Connected successfully';

succeeds. 

Performing a query with:

$query = 'count(doc("HelloWorld.xml")/doc)';
$result = monetdb_query($query); 
if(!$result)die("Query failed : " . monetdb_error() ."\n");
else echo '<br>Performed query';

succeeds as well. 

But the content of the result set seems to remain 'empty'. 

print_r($result) -> Resource id #3

But 
while($row = monetdb_fetch_array($result)) {
	print_r($row);
}

remains empty. 

Does somebody have a working example of performing an XQuery using PHP?

I wondered, is it required to connect to a specific database in the monetdb_connect command? (the XML-document) I think not, but hey!

With kind regards, 

-----Original Message-----
From:	Fabian Groffen [mailto:Fabian.Groffen@cwi.nl]
Sent:	Wed 11/22/2006 1:08 PM
To:	monetdb-users@lists.sourceforge.net
Cc:	
Subject:	Re: [MonetDB-users] Using MonetDB /  XQuery with PHP

Hi Menno,

Thanks for considering MonetDB.

The php_monetdb module can speak all languages that are supported by
mapi: mil, mal, sql and xquery.  I never used PEAR, but always used the
monetdb_xxx functions directly.  The monetdb_connect() function accepts
a language to use, which can be one of the few mentioned above.

Unfortunately the documentation as on the web is outdated in this
respect.  From the example monetdb_query_demo.php
http://monetdb.cvs.sourceforge.net/monetdb/MonetDB/src/mapi/clients/php/Cimpl/examples/monetdb_query_demo.php?revision=1.5&view=markup
it shows that the language has to be given as first argument to the
monetdb_connect() function.

As from the function documenation:
proto resource monetdb_connect([string language [, string host [, string
port [, string username [, string port [, string database [, int
connect_type]]]]]]])

I hope this helps/clears up a bit.  Feel free to ask.

On 22-11-2006 11:56:40 +0100, Menno Holtkamp wrote:
...
Dear MonetDB Team,
   We are currently checking the MonetDB/XQuery distribution for use in
   several governmental and research projects. We have succesfully
   installed the MonetDB/XQuery server and are able to perform some
   example queries by loading some .xq files with the MapiClient.
   By using the php_monetdb.dll which came along with the MonetDB/SQL
   server, we were able to perform some SQL queries on that database. But
   now we want to perform MIL queries on the MonetDB/XQuery server.
   I assume the used/ripped MAPI dll (version 1.0) does not support the
   MIL language, in essence, I am not able to configure the php.ini to
   accept:
   monetdb.default_language = mil
   On the website, the only thing mentioned about a windows installation
   of the MAPI for PHP is
   (http://monetdb.cwi.nl/TechDocs/APIs/PEARDB/index.html):
   For windows setups the story is a little bit more complex. TODO
   Can you explain how to install / acquire the proper dynamically
   loadable php module php_monetdb.dll which supports MIL and with which
   we can query our XML data?
   With kind regards,
   Menno Holtkamp
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users