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; }