private function updateSessionActivity($in_sessid)
{
//
// make sure we have a database connection.
//
$conn = DBH::opretForbindelse();
try {
$sessid = $this->escape_string($in_sessid);
$querystr = <<<EOQUERY
UPDATE loggedinusers SET lastupdate = NOW()
WHERE sessionid = '{$in_sessid}'
EOQUERY;
$results = @$conn->query($querystr);
if ($results === FALSE) {
throw new DatabaseErrorException($conn->error);
}
} catch (Exception $e) {
throw $e;
}
}
<?php
$beerid = $_REQUEST['beerid'];
$usermgr = new UserManager();
$userid = $usermgr->sessionLoggedIn(session_id());
$conn = DBH::opretForbindelse();
$query = "SELECT * FROM beer WHERE userid = {$userid} AND tablebeerid = {$beerid}";
$result = $conn->query($query);
$aroma_1 = 61;
$udseende_1 = 62;
$smag_1 = 63;
$mundfylde_1 = 64;
$helhedsindtryk_1 = 65;
$aroma_2 = 71;
$udseende_2 = 72;
$smag_2 = 73;
$mundfylde_2 = 74;
$helhedsindtryk_2 = 75;
$aroma_3 = 81;
$udseende_3 = 82;
$smag_3 = 83;
$mundfylde_3 = 84;
$helhedsindtryk_3 = 85;
$definition = $result->fetch_assoc();
echo <<<htmltekst
<script type="text/javascript">
\$(function () {
\$('#container').highcharts({
public function brewDelete($in_brewid)
{
$conn = DBH::opretForbindelse();
try {
$qstr = "DELETE FROM brew WHERE brew_id = {$in_brewid}";
$result = @$conn->query($qstr);
if ($result === FALSE) {
throw new DatabaseErrorException($conn->error);
}
} catch (Exception $e) {
if (isset($conn)) {
$conn->close();
}
throw $e;
}
//
// clean up and go home!
//
$conn->close();
}
