function diagramGetAll($dbhandle)
{
$diagrams = array();
$query = "SELECT * FROM diagram ORDER BY title";
$result = sqlite_query($dbhandle, $query);
if ($result) {
while ($row = sqlite_fetch_array($result, SQLITE_ASSOC)) {
#print_r($row);
$d = new Diagram();
$d->loadFromSQL($row);
$diagrams[] = $d;
}
}
return $diagrams;
}
public function diagramsForUserNative($userId, $level)
{
$diagrams = array();
DEBUG ? $_SESSION['logs'][] = __CLASS__ . '{#}' . __FUNCTION__ . "{#}{#}" . __LINE__ : '';
$query = "select diagram.* from diagram, userdiagram\r\n where userdiagram.userId = {$userId}\r\n and userdiagram.diagramId = diagram.id" . (isset($level) ? " and userdiagram.level = '{$level}'" : '') . " order by title";
DEBUG ? $_SESSION['logs'][] = " " . __CLASS__ . '{#}' . __FUNCTION__ . "{#}{$query}{#}" . __LINE__ : '';
#echo $query;
//EXECUTE query
$result = $this->executeSQL($query, $this->con);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$diagram = new Diagram();
$diagram->loadFromSQL($row);
$diagrams[] = $diagram;
}
return $diagrams;
}
function diagramGetAll2($dbhandle)
{
$diagrams = array();
$query = "SELECT * FROM diagram ORDER BY title";
$results = $this->query($query);
if ($results) {
while ($row = $results->fetchArray()) {
#print_r($row);
$d = new Diagram();
$d->loadFromSQL($row);
$diagrams[] = $d;
}
}
return $diagrams;
}
