<?php
require 'monetdb/php_monetdb.php';
$db = monetdb_connect("sql", "localhost", $argv[1], "monetdb", "monetdb", $argv[2]) or die(monetdb_last_error());
$packet_size = 20000;
$sql = 'select 1';
$sql = str_pad($sql, $packet_size, ' ');
echo strlen($sql) . "\n";
$res = monetdb_query($sql);
while ($row = monetdb_fetch_assoc($res)) {
print_r($row);
}
monetdb_disconnect();
/**
* Generates the next id in the sequence $seq
*
* @param resource connection instance
* @param seq sequence whose next
* value we want to retrieve
* @return string the ID of the last tuple inserted. FALSE if an error occurs
*/
function monetdb_insert_id($connection = NULL, $seq)
{
$num_args = func_num_args();
if ($num_args == 1) {
$connection = mapi_get_current_conn();
$seq = func_get_arg(0);
}
if (is_string($seq)) {
$query = "SELECT NEXT VALUE FOR " . monetdb_quote_ident($seq) . "";
$res = monetdb_query($connection, $query);
$row = monetdb_fetch_assoc($result);
return $row[$seq];
}
return FALSE;
}
#!/usr/bin/php
<?php
# This Source Code Form is subject to the terms of the Mozilla Public
# License, v. 2.0. If a copy of the MPL was not distributed with this
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
# Copyright 2008-2015 MonetDB B.V.
?>
<?php
require 'monetdb/php_monetdb.php';
$db = monetdb_connect("sql", "localhost", $argv[1], "monetdb", "monetdb", $argv[2]);
$tables = monetdb_query('SELECT name FROM tables LIMIT 10');
for ($i = 0; $line = @monetdb_fetch_assoc($tables); $i++) {
print $line['name'] . "\n";
}
$result = monetdb_query('SELECT name, schema_id, query, type, system, commit_action, access, temporary FROM tables LIMIT 10');
$cols = monetdb_num_fields($result);
for ($i = 0; $i < $cols; $i++) {
print monetdb_field_name($result, $i) . "\t";
}
print "\n";
while ($row = @monetdb_fetch_row($result)) {
for ($i = 0; $i < $cols; $i++) {
print $row[$i] . "\t";
}
print "\n";
}
<?php
error_reporting(E_ALL);
require 'php_monetdb.php';
define("DB", "demo");
echo function_exists("monetdb_connect");
echo function_exists("monetdb_last_error");
$db = monetdb_connect("sql", "127.0.0.1", 50000, "monetdb", "monetdb", "demo");
$err = monetdb_last_error();
$query = "SELECT * FROM demo.sys.word_asos where main_word = 'skull'";
$res = monetdb_query($db, $query) or trigger_error(monetdb_last_error());
echo "Rows: " . monetdb_num_rows($res) . "\n";
$row = monetdb_fetch_assoc($res);
var_dump($row);
foreach ($row as $rows) {
if ($rows != null && $rows != '') {
$assoc = "";
}
}
monetdb_free_result($res);
if (monetdb_connected($db)) {
monetdb_disconnect($db);
}
