query_redirect("DELETE" . limit1("FROM " . table($TABLE), " WHERE {$where}"), $location, array(lang('Item has been deleted.'), 'success'));
} else {
$set = array();
foreach ($fields as $name => $field) {
$val = process_input($field);
if ($val !== false && $val !== null) {
$set[idf_escape($name)] = $update ? "\n" . idf_escape($name) . " = {$val}" : $val;
}
}
if ($update) {
if (!$set) {
redirect($location);
}
query_redirect("UPDATE" . limit1(table($TABLE) . " SET" . implode(",", $set), "\nWHERE {$where}"), $location, array(lang('Item has been updated.'), 'success'));
} else {
$result = insert_into($TABLE, $set);
$last_id = $result ? last_id() : 0;
queries_redirect($location, array(lang('Item%s has been inserted.', $last_id ? " {$last_id}" : ""), 'success'), $result);
//! link
}
}
}
$table_name = $adminer->tableName(table_status($TABLE));
page_header($update ? lang('Edit') : lang('Insert'), $error, array("select" => array($TABLE, $table_name)), $table_name);
$adminer->selectLinks($table_status, '');
// @todo are params OK?
$row = null;
if ($_POST["save"]) {
$row = (array) $_POST["fields"];
} elseif ($where) {
$select = array();
function get_url($url, $cache_hard = true)
{
global $http_cache_timeout;
global $api_calls;
global $cached_api_calls;
# Check whether we have a cached response for this URL
# Note there are two cache timestamps: fetched_on_server is tied to the
# server (mothership)'s clock and fetched_on is tied to the local clock.
# We are careful to compare the local now() against fetched_on and the
# server's "Date:" header values against fetched_on_server.
if (!$http_cache_timeout) {
throw new Exception("\$http_cache_timeout not set");
}
# Expire old cache entries.
mysql_query('delete from http_cache where fetched_on < now() - ' . $http_cache_timeout);
# Load a valid cache element, if any.
$sql = 'select content, fetched_on_server from http_cache where url = \'' . mysql_real_escape_string($url) . '\' and fetched_on >= now() - ' . $http_cache_timeout;
$q = mysql_query($sql);
if (!$q) {
throw new Exception("Getting cache, got database error: " . mysql_error());
}
require_once 'HTTP/Request.php';
if ($row = mysql_fetch_row($q)) {
list($content, $fetched_on) = $row;
# Under "hard" caching, return the cached data without talking to server.
if ($cache_hard) {
message("Hard cache hit at {$url}");
return $content;
}
# Under "soft" caching, we make a request to ask the server if the resource
# has changed since our copy.
$fetched_on_http_date = date(DATE_RFC1123, from_mysql_date($fetched_on));
$req = new HTTP_Request($url);
$req->addHeader('If-Modified-Since', $fetched_on_http_date);
$request_timer -= microtime(true);
$ok = $req->sendRequest();
$request_timer += microtime(true);
$cached_api_calls = $cached_api_calls + 1;
if (!PEAR::isError($ok)) {
$respCode = $req->getResponseCode();
if (304 == $respCode) {
# 304 Not Modified; we can use the cached copy.
message('Cache hit at ' . $url . ' using If-Modified-Since: ' . $fetched_on_http_date . "Request timer: {$request_timer}" . 's');
return $content;
} elseif (200 <= $respCode && $respCode < 300) {
# Got an OK response, use the data.
message('Cache refresh at ' . $url . ' If-Modified-Since: ' . $fetched_on_http_date . '. Request timer: ' . $request_timer . 's');
$content = $req->getResponseBody();
$fetched_on_server = mysql_date(from_http_date($req->getResponseHeader('Date')));
mysql_query('delete from http_cache where url = \'' . mysql_real_escape_string($url) . '\'');
if (!insert_into('http_cache', array('url' => $url, 'content' => $content, 'fetched_on_server' => $fetched_on_server))) {
throw new Exception("Database error writing to HTTP cache: " . mysql_error());
}
return $content;
}
} else {
throw new Exception("Error while GETing {$url} ({$ok})");
}
} else {
$req = new HTTP_Request($url);
$request_timer -= microtime(true);
$ok = $req->sendRequest();
$request_timer += microtime(true);
$api_calls = $api_calls + 1;
message("Cache miss at {$url} Request timer: " . $request_timer . "s");
if (PEAR::isError($ok)) {
throw new Exception("Unknown error trying GET {$url}");
}
$respCode = $req->getResponseCode();
if (200 <= $respCode && $respCode < 300) {
# Got an OK response, use it.
$content = $req->getResponseBody();
$fetched_on_server = mysql_date(from_http_date($req->getResponseHeader('Date')));
mysql_query('delete from http_cache where url = \'' . mysql_real_escape_string($url) . '\'');
if (!insert_into('http_cache', array('url' => $url, 'content' => $content, 'fetched_on_server' => $fetched_on_server))) {
throw new Exception("Database error writing to HTTP cache: " . mysql_error());
}
return $content;
} else {
error("GET {$url} returned {$respCode}");
return null;
}
}
}
function set_site_links($links)
{
mysql_query('delete from site_links');
foreach ($links as $link) {
insert_into('site_links', array('text' => $link['text'], 'url' => $link['url']));
}
}
<?php
try {
require_once 'Sprinkles.php';
require_once 'HTTP_Request_Oauth.php';
$sprink = new Sprinkles();
$return = request_param('return');
$consumer_data = $sprink->oauth_consumer_data();
if (!$consumer_data['key'] || !$consumer_data['secret']) {
die("The OAuth consumer data was missing from the Instant-On Help " . "Center database! Perhaps something went wrong during installation " . "and setup.");
}
list($token, $secret) = get_oauth_request_token($consumer_data);
if (!$token || !$secret) {
error("Failed to fetch OAuth request token " . "(Result token: '{$token}'; Token secret: '{$token_secret}')");
die("Failed to fetch OAuth request token from getsatisfaction.com.");
}
$result = insert_into('sessions', array('token' => $token, 'token_secret' => $secret));
if (!$result) {
die("Error inserting OAuth tokens into database.");
}
$first_login = request_param('first_login');
$callback_url = $sprink->sprinkles_root_url() . 'handle-oauth-return.php?' . ($first_login ? 'first_login=true&' : '') . 'return=' . urlencode($return);
redirect(oauth_authorization_url($token, $callback_url));
exit(0);
} catch (Exception $e) {
error_log("Exception thrown while preparing page: " . $e->getMessage());
$smarty->display('error.t');
}
<?php
/*
* Handling the form data for the Login page > index.php
* Project : Secure Login Module - Udemy PHP Basics
* Date : Feb 2016
* Author : Carl Simpson
* Version : 1.0
*
*/
include '_includes/db_connect.php';
include '_includes/db_functions.php';
if (isset($_POST['submit'])) {
insert_into();
} else {
echo 'there has been an error';
}
