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