Re: Resource on the PHP API for monetdb

Hi Leon,

On 24 Nov 2014, at 09:04, Leon-Constantin Fopa wrote:

I'm interested in accessing monetdb from a PHP script.

Can someone provide me a link on resource with introduce that.

The MonetDB/PHP connector is included in the MonetDB source distribution, the latest version can be downloaded at [1]. Within that .zip file, you will find the connector in the folder clients/PHP. Basically, you need to include the file php_monetdb.php in the lib folder, and then the usage is very similar to e.g. the MySQL connector: <?php require 'lib/php_monetdb.php'; $db = monetdb_connect($lang="sql", $host = "localhost", $port = 50000, $username = "monetdb", $password = "monetdb", $database = "demo" ) or trigger_error(monetdb_last_error()); $res = monetdb_query($db, monetdb_escape_string("SELECT * FROM TABLES")) or trigger_error(monetdb_last_error()); while ($row = monetdb_fetch_assoc($res)) { print_r($row); } ?> See the examples folder for more details. Hope this helps, Hannes [1] http://dev.monetdb.org/downloads/sources/Oct2014/MonetDB-11.19.3.zip