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