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