public function insertBPData()
{
//create the sql query
$sql = "INSERT INTO log_bodymetrics (created, user, metric_id, metric_value) values (CURRENT_TIMESTAMP, " . $this->user . ",2,'" . $this->jsonData . "')";
parent::__construct();
parent::execQuery($sql, false);
return true;
}
public function returnAllData($whatData)
{
//try to find a match for the SQL we want to retrieve.
$sql = parent::getSQL($whatData);
$result = parent::execQuery($sql, true);
if (!$result) {
echo "There was an issue executing your query to return all metrics";
exit;
} else {
$strBuffer = "<ul>";
//let's package the data for consumption
for ($i = 0; $i < sizeof($result); $i++) {
$strBuffer .= "<li>" . $result[$i]['note'] . "</li>";
}
$strBuffer .= "</ul>";
}
return $strBuffer;
}
