/** * Executes an SQL SELECT statement * * @param rdbms.DBConnection conn * @param rdbms.Peer peer * @param rdbms.join.Joinprocessor jp optional * @param bool buffered default TRUE * @return rdbms.ResultSet */ public function executeSelect(DBConnection $conn, Peer $peer, $jp = null, $buffered = true) { $statement = preg_replace('/object\\(([^\\)]+)\\)/i', '$1.' . implode(', $1.', array_keys($peer->types)), $this->statement); if ($buffered) { return $conn->query($statement, ...$this->arguments); } else { return $conn->open($statement, ...$this->arguments); } }
public function update($id) { $values = []; $columns = []; foreach (static::$columns as $column) { $values[':' . $column] = $this->{$column}; $columns[] = $column . '=:' . $column; } $sql = 'UPDATE' . ' ' . static::$table . ' ' . 'SET' . ' ' . implode(',', $columns) . ' ' . 'WHERE id=:id'; echo $sql; $res = new DBConnection(); $res->query($sql, $id, $values); }
$shares = array(); if (!empty($_POST['1'])) { array_push($shares, $_POST['1']); } if (!empty($_POST['2'])) { array_push($shares, $_POST['2']); } if (!empty($_POST['3'])) { array_push($shares, $_POST['3']); } //var_dump($shares); $reconstructed_secret = reconstruct($shares); $db = new DBConnection(); $db->connect(); $user = get_user_info(); $secret = $db->query('secret', 'secret', "uid='{$user}'", null, null, null)[0]['secret']; $db->delete('secret', "uid='{$user}'"); $db->disconnect(); if ($secret == $reconstructed_secret) { echo "Secrets matching. Access granted."; } else { echo "{$secret} != {$reconstructed_secret}. Access denied"; } } else { echo "fail"; } } else { echo "fail"; } /* [1,8683146895150534502] [2,17361141234745553751] [3,7143385603424603993] * Secret 5152555555515253
<?php require_once "includes/db.class.inc"; require_once "includes/mailapi.inc"; require_once "includes/session.inc"; if (is_session_active()) { $db = new DBConnection(); $db->connect(); $user = get_user_info(); $secretshare = $db->query('shares', 'share', "uid='{$user}' AND share LIKE '[2,%'", null, null, null)[0]['share']; //print_r($secretshare); $db->delete("shares", "share='{$secretshare}'"); $db->disconnect(); //send secretshare in sms //sendsms($user, $share) echo $secretshare; //echo "fail"; //echo "success"; } else { echo "fail"; }
/** * Executes an SQL SELECT statement * * @param rdbms.DBConnection conn * @param rdbms.Peer peer * @param rdbms.join.Joinprocessor jp optional * @param bool buffered default TRUE * @return rdbms.ResultSet */ public function executeSelect(DBConnection $conn, Peer $peer, $jp = NULL, $buffered = TRUE) { return $conn->query('%c', $this->getSelectQueryString($conn, $peer, $jp), $buffered); }