public function getList()
{
$result = SQL::query("SELECT * FROM users;");
$response = array();
for ($i = 0; $i < $result->num_rows; $i++) {
$line = SQL::fetchAssoc($result);
array_push($response, $line);
}
return $response;
}
public function getList()
{
$userId = $_SESSION["userId"];
$result = SQL::query("SELECT * FROM foods WHERE user_id = " . $userId . ";");
$response = array();
for ($i = 0; $i < $result->num_rows; $i++) {
$line = SQL::fetchAssoc($result);
array_push($response, $line);
}
return $response;
}
public function getList()
{
$food = new Food();
$userId = $_SESSION["userId"];
$result = SQL::query("SELECT * FROM calories WHERE user_id = " . $userId . ";");
$response = array();
for ($i = 0; $i < $result->num_rows; $i++) {
$line = SQL::fetchAssoc($result);
$foodData = $food->getById($line["food_id"]);
$line["food_data"] = $foodData;
array_push($response, $line);
}
return $response;
}
}
// unique identifer for this session, to validate ajax requests.
// document root is included because it is likely a difficult value
// for potential attackers to guess
$requestKey = substr(md5(session_id() . $_SERVER["DOCUMENT_ROOT"]), 0, 16);
if (isset($conn) && $conn->isConnected()) {
if (isset($_GET['db'])) {
$db = $conn->escapeString($_GET['db']);
}
if (isset($_GET['table'])) {
$table = $conn->escapeString($_GET['table']);
}
if ($conn->hasCharsetSupport()) {
$charsetSql = $conn->listCharset();
if ($conn->isResultSet($charsetSql)) {
while ($charsetRow = $conn->fetchAssoc($charsetSql)) {
$charsetList[] = $charsetRow['Charset'];
}
}
$collationSql = $conn->listCollation();
if ($conn->isResultSet($collationSql)) {
while ($collationRow = $conn->fetchAssoc($collationSql)) {
$collationList[$collationRow['Collation']] = $collationRow['Charset'];
}
}
}
}
// undo magic quotes, if necessary
if (get_magic_quotes_gpc()) {
$_GET = stripslashesFromArray($_GET);
$_POST = stripslashesFromArray($_POST);
public function get()
{
$result = SQL::query("SELECT daily_calories FROM users WHERE id = '" . $_SESSION["userId"] . "' LIMIT 1;");
return SQL::fetchAssoc($result);
}
