<?php
-class result {
+
+class result extends PDOStatement {
+ //All functions in this class are deprecated!
+ //Please use only native PDOStatement functions!
+
var $_numRows = 0;
var $_numFields = 0;
var $_currentRow = -1;
var $_queryId = false;
var $_sql = "";
-function result($queryId, $sql) {
- $this->_queryId = $queryId;
- $this->_sql = $sql;
- if ($this->_queryId != false) {
- $this->_numRows = @mysql_num_rows($this->_queryId);
- $this->_numFields = @mysql_num_fields($this->_queryId);
+ public $dbh;
+ protected function __construct($dbh) {
+ $this->dbh = $dbh;
+
+ $this->_numRows = @$this->rowCount();
+ //$this->_numFields = @mysql_num_fields($this->_queryId);
$this->_currentRow = -1;
$this->_currentRecord = array();
- } else {
- $this->exception("result failed.");
}
-}
- function next() {
- if ($this->_currentRow + 1 >= $this->_numRows) {
- return false;
- } else {
- $this->_currentRecord = @mysql_fetch_assoc($this->_queryId);
- $this->_currentRow++;
- return true;
+ function next() { //DEPRECATED!!! Use $this->fetch(); instead!!!
+ if ($this->_currentRow + 1 >= $this->_numRows) {
+ return false;
+ } else {
+ $this->_currentRecord = @$this->fetch();
+ $this->_currentRow++;
+ return true;
+ }
}
-}
-/* DEPRECATED!
-function absolute($row) {
- if ($row > 0) {
-// positive row number
- @mysql_data_seek($this->_queryId, $row-1);
- $this->_currentRecord = @mysql_fetch_assoc($this->_queryId);
- $this->_currentRow = $row;
- } elseif ($row < 0) {
- // not implemented yet
- } else {
- $this->exception("Cannot absolute position to row 0");
+ function getRecord() { //DEPRECATED!!! Use $this->fetch(); instead!!!
+ return $this->_currentRecord;
}
-}
-*/
-function getRecord() {
- return $this->_currentRecord;
-}
-
-function getString($column) {
- if (is_int($column) == true) {
- return (string)$this->_currentRecord[$column-1];
- } else {
- return (string)$this->_currentRecord["$column"];
+ function getString($column) { //DEPRECATED!!! Use $this->fetch(); instead!!!
+ if (is_int($column) == true) {
+ return (string) $this->_currentRecord[$column - 1];
+ } else {
+ return (string) $this->_currentRecord["$column"];
+ }
}
-}
-function getInt($column) {
- if (is_int($column) == true) {
- return (int)$this->_currentRecord[$column-1];
- } else {
- return (int)$this->_currentRecord["$column"];
+ function getInt($column) { //DEPRECATED!!! Use $this->fetch(); instead!!!
+ $this->getString($column); //Dynamic typing OMG...
}
-}
-
-/* DEPRECATED!
-function getVariable($column) {
- return (int)$this->_currentRecord["$column"];
-}
-
-function getDouble() {
- if (is_int($column) == true) {
- return (double)$this->_currentRecord[$column-1];
- } else {
- return (double)$this->_currentRecord["$column"];
- }
-}
-
-function getRow() {
- if ($this->_currentRow < 0) {
- return 0;
- } else {
- return $this->_currentRow + 1;
+ function getNumRows() { //DEPRECATED!!! Use $this->rowCount(); instead!!!
+ return $this->_numRows;
}
-}
-*/
-
-function getNumRows() {
- return $this->_numRows;
-}
-
-/* DEPRECATED!
-function getNumFields() {
- return $this->_numFields;
-}
-*/
-
-function exception($errorMsg) { //Internal only!
- die("<pre>SQLException: ".$msg."</pre>");
-}
}
-?>