function checkCredentials($userid, $password, Request $message) { $db = new dbHandler(); $link = $db->getDbHandler(); $query = "SELECT * FROM Security WHERE UserName = '******' and Password = '******'"; $result = sqlite_query($link, $query); if (sqlite_num_rows($result) < 1) { $db->close(); throw new WebORBAuthenticationException("invalid userid or password"); } $db->close(); }
public function getProducts() { try { $db = new dbHandler(); $link = $db->getDbHandler(); /*String*/ $query = "SELECT Name, Price FROM Products"; $result = sqlite_array_query($link, $query, SQLITE_ASSOC); $db->close(); return $result; } catch (Exception $exception) { Log::log(LoggingConstants::EXCEPTION, $exception); } return null; }