public function restoreUserFromUsername( DatabaseConnection $connection ) {
		if(!isset($connection) || !isset($this->username)) {
			$this->isAuthenticated = false;
			return$this->isAuthenticated;
		}
		if( !$connection->isConnected ) {
			if( !$connection->Connect() ){
				return $this->isAuthenticated;
			}
		}

		$query = "select userId, username, userLevel, ipaddress, isLoggedIn, lastLogin from users where username='{$this->username}';";

		if( !$connection->query( $query ) ) {
			return $this->isAuthenticated;
		} 

		if( 1 > $connection->getNumRows() ) {
			//echo "user {$query}";
			//print_r($connection->getObject());
			return $this->isAuthenticated;
		}

		$user = $connection->getObject();
		$this->userLevel = $user->userLevel;
		$this->lastLogin = $user->lastLogin;
		$this->ipaddress = $user->ipaddress;
		$this->isAuthenticated = $user->isLoggedIn;
	} 

 /**
  * @brief Loads a wiki page
  *
  * Will attempt to load a wiki page from the database. If revision is not
  * specified, the latest revision will be loaded.
  *
  * @param String $page
  * @param Int $revision
  * @return Boolean True on success, false otherwise
  */
 function loadWikiPage($page, $revision = null)
 {
     $db = new DatabaseConnection();
     list($ns, $name) = $this->splitUri($page, 'wiki');
     if (!$revision) {
         $pd = $db->getSingleRow("SELECT * FROM wikipages WHERE pagens=%s AND pagename=%s " . "ORDER BY revision DESC LIMIT 1;", $ns, $name);
     } else {
         $pd = $db->getSingleRow("SELECT * FROM wikipages WHERE pagens=%s AND pagename=%s AND " . "revision<%d ORDER BY revision DESC LIMIT 1;", $ns, $name, $revision);
     }
     if ($pd) {
         $revs = $db->getSingleRow("SELECT revision FROM wikipages WHERE pagens=%s AND pagename=%s", $ns, $name);
         foreach ($revs as $rev) {
             $this->revisions[] = $rev['revision'];
         }
         if ($pd['format'] != NULL) {
             $this->markup = $pd['markuptype'];
             $this->parser = markup::factory($this->markup);
         }
         $this->content = $pd['content'];
         $this->pagerevision = $pd['revision'];
         $this->modified = false;
         $this->pagens = $pd['pagens'];
         $this->pagename = $pd['pagename'];
         $this->pagetitle = $pd['pagetitle'];
         return true;
     } else {
         return false;
     }
 }

 public function getUserList()
 {
     $dbconn = new DatabaseConnection('localhost', 'user', 'password');
     $results = $dbconn->query('select name from user');
     sort($results);
     return $results;
 }

 public function refreshUserList()
 {
     //assim evitamos a necessidade de consultar o banco a cada requisição de lista
     $dbconn = new DatabaseConnection('localhost', 'user', 'password');
     $results = $dbconn->query('select name from user');
     $this->setUserList(sort($results));
 }

function addSubjects($name)
{
    $sql = "INSERT INTO subjects VALUES ('', ?)";
    $string = array($name);
    $db = new DatabaseConnection("localhost", "adminuser", "asd12345", "school");
    $db->queryWithoutResult($sql, $string, true, "s");
}

 /**
  * Get constraint type handler for driver
  *
  * @param \DatabaseConnection $connection
  * @param string $type
  *
  * @return ConstraintInterface
  */
 public function get(\DatabaseConnection $connection, $type)
 {
     $driver = $connection->driver();
     if (isset($this->instances[$driver][$type])) {
         return $this->instances[$driver][$type];
     }
     return $this->instances[$driver][$type] = $this->createInstance($connection, $type);
 }

 function staticText($slug)
 {
     $db = new DatabaseConnection();
     $text = $db->getSingleRow("SELECT * FROM statictext WHERE slug=%s", $slug);
     if ($text) {
         return $text['content'];
     }
 }

 function showStart()
 {
     $this->loadTemplate();
     $controller = new DatabaseConnection();
     $controller->raw('CALL registraVisita()');
     $controller = null;
     include 'view/welcome.php';
 }

function getStudentIds()
{
    $db = new DatabaseConnection("localhost", "adminuser", "asd12345", "school");
    $sql = "SELECT id FROM students";
    $string = array();
    $res = $db->select($sql, $string, false, '');
    return $res;
}

 public function getListaUsuario($dbconn = null)
 {
     if (!isset($dbconn) || !$dbconn instanceof DatabaseConnection) {
         $dbconn = new DatabaseConnection('localhost', 'root', '');
     }
     $results = $dbconn->query('SELECT name FROM users');
     sort($results);
     return $results;
 }

 public function deleteLocation($id)
 {
     $db = new DatabaseConnection();
     $conn = $db->connectToDB();
     $result = $db->updateDatabase("DELETE FROM location where id = {$id}");
     $db->closeDBConnection($conn);
     header("Content-Type: application/json");
     echo json_encode($result);
 }

 public function submitComment()
 {
     $conn = new DatabaseConnection();
     if (!isset($_GET['replyid'])) {
         $sentence = 'CALL addComment(' . $_SESSION['bookid'] . ',' . $_SESSION['id'] . ",'" . $_POST['comment'] . "')";
     } else {
         $sentence = 'CALL addReply(' . $_SESSION['bookid'] . ',' . $_SESSION['id'] . ',' . $conn->quote($_POST['reply']) . ',' . $_GET['replyid'] . ')';
     }
     $conn->query($sentence);
 }

 public function __construct()
 {
     $this->dbTable = 'product';
     $connection = new DatabaseConnection();
     try {
         $this->database = $connection->SetupDatabase();
     } catch (\Exception $e) {
         throw $e;
     }
 }

 public function addEvent(AuditEvent $event)
 {
     $event->setComponent($this->_component);
     $cn = get_class($event);
     $sev = serialize($event);
     // Shove into DB -- echo $sev;
     echo $cn . "\n\n" . $sev . "\n";
     $db = new DatabaseConnection();
     $db->insertRow("INSERT INTO auditlog " . "eventclass,component,severity,eventdate,data) " . "VALUES (%s,%s,%d,%d,NOW(),%s)", $cn, $event->getComponent(), $event->getSeverity(), $event->getAssociatedUserId(), $sev);
 }

 function savepost()
 {
     $post = new WebForm($this->gbform);
     if (!$post->isValid()) {
         // Form is invalid, post it back to the user to allow correction
     } else {
         $db = new DatabaseConnection();
         $db->insertRow("INSERT INTO guestbook (name,email,website,message) VALUES (%s,%s,%s,%s)", $post->name, $post->email, $post->website, $post->message);
     }
 }

 /**
  * Testcase Constructor.
  *
  * @return void
  */
 public function setUpPool()
 {
     $this->pool = $this->getMockBuilder('Lunr\\Gravity\\Database\\DatabaseConnectionPool')->disableOriginalConstructor()->getMock();
     $this->logger = $this->getMock('Psr\\Log\\LoggerInterface');
     $this->db = $this->getMockBuilder('Lunr\\Gravity\\Database\\MySQL\\MySQLConnection')->disableOriginalConstructor()->getMock();
     $escaper = $this->getMockBuilder('Lunr\\Gravity\\Database\\MySQL\\MySQLQueryEscaper')->disableOriginalConstructor()->getMock();
     $this->db->expects($this->once())->method('get_query_escaper_object')->will($this->returnValue($escaper));
     $this->dao = $this->getMockBuilder('Lunr\\Gravity\\Database\\DatabaseAccessObject')->setConstructorArgs(array($this->db, $this->logger, $this->pool))->getMockForAbstractClass();
     $this->reflection_dao = new ReflectionClass('Lunr\\Gravity\\Database\\DatabaseAccessObject');
 }

 protected static final function openConnection($driver)
 {
     $adapter = 'Adapter' . $driver;
     include_once dirname(__FILE__) . '/adapter/' . $adapter . '.php';
     $connection = new DatabaseConnection(new $adapter());
     $cfg = self::getConnectionConf();
     $connection->connect($cfg['engine'], $cfg['hostname'], $cfg['database'], $cfg['username'], $cfg['password']);
     return $connection;
     // end function
 }

 public function testLastID()
 {
     require __DIR__ . '/config/database_test.php';
     $db = new DatabaseConnection($host, $database, $user, $password);
     $insert_result = $db->query("INSERT INTO characters (id, name, description, type, dead, stage, hp) \r\n\t\t\tVALUES ('9999', 'Carla', 'The swordmaster of Melee Island', 'pirate', 'false',  '4',  '87');");
     $actual = $db->lastID();
     $expected = '9999';
     $delete_result = $db->query("DELETE FROM characters WHERE id = '9999'");
     $this->assertNotEmpty($actual, 'Function LastID returning empty value. Check TestDatabaseConnection::lastID()');
     $this->assertEquals($expected, $actual, 'Function LastID not returning expected value. Check TestDatabaseConnection::lastID()');
 }

 function getAllPosts()
 {
     // Acquire a handle to the database.
     $db = new DatabaseConnection();
     // Query the posts and assign the result to a postcollection.
     $rs = $db->getRows("SELECT * FROM blogposts ORDER BY pubdate DESC");
     $coll = array();
     foreach ($rs as $post) {
         $coll[] = new BlogPost($post);
     }
     // Finally return it
     return $coll;
 }

 function __construct(DatabaseConnection $parent)
 {
     //echo "Opening Connection\n";
     if ($parent->is_transaction()) {
         $this->using_savepoints = true;
         $this->savepoint_name = 'transaction_' . uniqid();
         $parent->query('SAVEPOINT ' . pg_escape_identifier($this->savepoint_name));
     } else {
         $this->using_savepoints = false;
         $parent->query("START TRANSACTION");
     }
     $this->parent_connection = $parent;
 }