Changes

Jump to navigation Jump to search
310 bytes added ,  13:28, 10 January 2011
<?php
/*
* This example shows how database commands queries can be executedin an iterative manner.
* Documentation: http://basex.org/api
*
try {
// initialize timer
$start = microtime(true);
 
// create session
$session = new Session("localhost", 1984, "admin", "admin");
try { // create query instance $input = 'declare variable $name external; '. 'for $i in 1 to 10 return element { $name } { $i }'; $query = $session->query($input);  // perform command and bind variable $query->bind("$name", "number");  // initialize query print returned string$query->init();  // loop through all results while($query->more()) { print $sessionquery->executenext()."xquery 1 to 10\n"; }  // close query instance print $query->close();  } catch (Exception $e) { // print exception print $e->getMessage(); }
// close session
$session->close();
 
// print time needed
$time = (microtime(true) - $start) * 1000;
print "\n$time ms\n";
} catch (Exception $e) {
bueraucrat, Bureaucrats, editor, reviewer, Administrators
907

edits

Navigation menu