PHP db::Query方法代码示例

 public function register()
 {
     if ($this->get_uid()) {
         return $this->get_uid();
     }
     $res = db::Query("INSERT INTO users.info DEFAULT VALUES RETURNING uid", [], true);
     return $this->get_login($res->uid);
 }

 private function CheckForRequestFrame($network)
 {
     try {
         $res = db::Query("UPDATE personal.frequency\n          SET last_access=now()\n          WHERE network=\$1\n          AND now() - last_access > min_interval\n          RETURNING *", [$network], true);
         return $res();
     } catch (Exception $e) {
         return false;
     }
 }

 private function new_income($data = [])
 {
     $trans = db::Begin();
     $handle = db::Query("INSERT INTO transactions(system, data) VALUES (\$1, \$2) RETURNING id", ["yandex.wallet", json_encode($data)], true);
     $result = $trans->Commit();
     if (!$result) {
         header('500 Failed to store transaction');
         exit;
     }
 }

 private function get_account_object($account_id)
 {
     if (!empty($this->loaded_accounts[$account_id])) {
         return $this->loaded_accounts[$account_id];
     }
     $account = db::Query("SELECT *\n      FROM personal.tokens\n      WHERE uid=\$1\n        AND account_id=\$2", [db::UID(), $account_id], true);
     phoxy_protected_assert($account(), "Account not found. Please connect again");
     list($obj, $user) = $this->network_signin($account->network, json_decode($account->token_data, true));
     db::Query("UPDATE personal.tokens\n        SET profile_id=\$2\n        WHERE account_id=\$1", [$account_id, $user->id]);
     return $this->loaded_accounts[$account_id] = $obj;
 }

 protected function register()
 {
     if (isset($_POST["register"])) {
         if (!empty($_POST['username']) && !empty($_POST['password'])) {
             $username = $_POST['username'];
             $password = $_POST['password'];
             $sameusers = db::Query("select * from users WHERE username=\$1", [$username]);
             if ($sameusers() == 0) {
                 $useradd = "INSERT INTO users (username,password) VALUES (\$1,\$2) RETURNING id";
                 $result = db::Query($useradd, [$username, $password], true);
                 if ($result() != 0) {
                     return "Аккаунт создан, вы прекрасны";
                 } else {
                     return "Ошибка :p";
                 }
             } else {
                 return "Такой чувак уже есть.";
             }
         } else {
             return "Поля незаполнены!";
         }
     }
 }

 protected function vote($id, $delta)
 {
     return db::Query("UPDATE quotes SET ratio=ratio+\$2 WHERE id=\$1 RETURNING ratio", [$id, $delta], true)->ratio;
 }

<?php

require_once 'vendor/autoload.php';
if (!PRODUCTION) {
    error_reporting(E_ALL);
    ini_set('display_errors', 'On');
}
function phoxy_conf()
{
    $ret = phoxy_default_conf();
    $ret["api_xss_prevent"] = PRODUCTION;
    return $ret;
}
function default_addons()
{
    $ret = ["cache" => PRODUCTION ? ['global' => '10m'] : "no", "result" => "canvas"];
    return $ret;
}
include 'phoxy/phoxy_return_worker.php';
phoxy_return_worker::$add_hook_cb = function ($that) {
    global $USER_SENSITIVE;
    if ($USER_SENSITIVE) {
        $that->obj['cache'] = 'no';
    }
};
phpsql\OneLineConfig(conf()->db->connection_string);
db::Query("INSERT INTO requests(url, get, post, headers, server) VALUES (\$1, \$2, \$3, \$4, \$5)", [$_SERVER['QUERY_STRING'], json_encode($_GET), json_encode($_POST), json_encode(getallheaders()), json_encode($_SERVER)]);
include 'phoxy/load.php';

 public function info($account_id)
 {
     $account = db::Query("SELECT *\n      FROM personal.tokens\n      WHERE uid=\$1 AND account_id=\$2", [db::UID(), $account_id], true);
     phoxy_protected_assert($account(), "Internal issue: account not found");
     return $this->PrepareAccount($account);
 }

 protected function rendertags($id)
 {
     $sql_tags = db::Query("SELECT tag FROM tags WHERE quote_id=\$1", [$id]);
     return ["design" => "quotes/tags", "data" => ["tags" => $sql_tags]];
 }

 public function Update($type, $resource_id, $data, $expiration)
 {
     // TODO: Update if exists
     db::Query("DELETE FROM personal.account_cache WHERE expired < now()");
     db::Query("INSERT INTO personal.account_cache\n        (account_id, type, resource_id, data, expired)\n        VALUES (\$1, \$2, \$3, \$4, 'epoch'::timestamp + \$5::int8 * '1 second'::interval)", [$this->AccountID(), $type, $resource_id, json_encode($data, true), $expiration]);
 }

}
function SQLLoad($file)
{
    header("SQL: {$file}", false);
    $con = db::RawConnection();
    $sql = file_get_contents($file);
    pg_send_query($con, $sql);
    if (($error = pg_last_error($con)) !== '') {
        die("Failure at loading {{$file}} with {{$error}}");
    }
    while (pg_connection_busy($con)) {
        sleep(1);
    }
    while (pg_get_result($con) !== false) {
        if (($error = pg_last_error($con)) !== '') {
            die("Failure at loading {{$file}} with {{$error}}");
        }
    }
}
if (db::RawConnection() == false) {
    EmergencyCreateDB();
}
$res = @db::Query("SELECT * FROM quotes LIMIT 1");
if (is_string($res)) {
    // then its error
    SQLLoad("sql/schema.sql");
} else {
    if (!$res()) {
    }
}
header("SQL: OK", false);

 public function Register()
 {
     return db::Query("INSERT INTO personal.users DEFAULT VALUES RETURNING uid", [], true)->uid;
 }