public function selectSerializeByID($id) { $sth = $this->pdo->prepare("SELECT serilize FROM {$this->prefix}orders WHERE id = :id"); $sth->bindParam(':id', $id); $sth->execute(); $data = $sth->fetchAll(PDO::FETCH_COLUMN); return $data; }
/** * * Удалить запись с кэшем * * @param $sig * * @return bool */ public function remove($sig) { $query = 'DELETE FROM ' . $this->prefix . 'cache WHERE sig = ":sig"'; $sth = $this->pdo->prepare($query); $sth->bindParam(':sig', $sig); if ($sth->execute()) { $result = true; } else { $result = false; } return $result; }