thorsten /
phpMyFAQ
| @@ 99-116 (lines=18) @@ | ||
| 96 | * |
|
| 97 | * @return mixed $result |
|
| 98 | */ |
|
| 99 | public function query($query, $offset = 0, $rowcount = 0) |
|
| 100 | { |
|
| 101 | if (DEBUG) { |
|
| 102 | $this->sqllog .= PMF_Utils::debug($query); |
|
| 103 | } |
|
| 104 | ||
| 105 | if (0 < $rowcount) { |
|
| 106 | $query .= sprintf(' OFFSET %d ROWS FETCH NEXT %d ROWS ONLY', $offset, $rowcount); |
|
| 107 | } |
|
| 108 | ||
| 109 | $result = mssql_query($query, $this->conn); |
|
| 110 | ||
| 111 | if (!$result) { |
|
| 112 | $this->sqllog .= $this->error(); |
|
| 113 | } |
|
| 114 | ||
| 115 | return $result; |
|
| 116 | } |
|
| 117 | ||
| 118 | /** |
|
| 119 | * Escapes a string for use in a query. |
|
| @@ 111-128 (lines=18) @@ | ||
| 108 | * |
|
| 109 | * @return mysqli_result $result |
|
| 110 | */ |
|
| 111 | public function query($query, $offset = 0, $rowCount = 0) |
|
| 112 | { |
|
| 113 | if (DEBUG) { |
|
| 114 | $this->sqllog .= PMF_Utils::debug($query); |
|
| 115 | } |
|
| 116 | ||
| 117 | if (0 < $rowCount) { |
|
| 118 | $query .= sprintf(' LIMIT %d,%d', $offset, $rowCount); |
|
| 119 | } |
|
| 120 | ||
| 121 | $result = $this->conn->query($query); |
|
| 122 | ||
| 123 | if (!$result) { |
|
| 124 | $this->sqllog .= $this->error(); |
|
| 125 | } |
|
| 126 | ||
| 127 | return $result; |
|
| 128 | } |
|
| 129 | ||
| 130 | /** |
|
| 131 | * Escapes a string for use in a query. |
|
| @@ 102-119 (lines=18) @@ | ||
| 99 | * |
|
| 100 | * @return mixed $result |
|
| 101 | */ |
|
| 102 | public function query($query, $offset = 0, $rowcount = 0) |
|
| 103 | { |
|
| 104 | if (DEBUG) { |
|
| 105 | $this->sqllog .= PMF_Utils::debug($query); |
|
| 106 | } |
|
| 107 | ||
| 108 | if (0 < $rowcount) { |
|
| 109 | $query .= sprintf(' LIMIT %d OFFSET %d', $rowcount, $offset); |
|
| 110 | } |
|
| 111 | ||
| 112 | $result = pg_query($this->conn, $query); |
|
| 113 | ||
| 114 | if (!$result) { |
|
| 115 | $this->sqllog .= $this->error(); |
|
| 116 | } |
|
| 117 | ||
| 118 | return $result; |
|
| 119 | } |
|
| 120 | ||
| 121 | /** |
|
| 122 | * Escapes a string for use in a query. |
|
| @@ 93-110 (lines=18) @@ | ||
| 90 | * |
|
| 91 | * @return mixed $result |
|
| 92 | */ |
|
| 93 | public function query($query, $offset = 0, $rowcount = 0) |
|
| 94 | { |
|
| 95 | if (DEBUG) { |
|
| 96 | $this->sqllog .= PMF_Utils::debug($query); |
|
| 97 | } |
|
| 98 | ||
| 99 | if (0 < $rowcount) { |
|
| 100 | $query .= sprintf(' LIMIT %d,%d', $offset, $rowcount); |
|
| 101 | } |
|
| 102 | ||
| 103 | $result = $this->conn->query($query); |
|
| 104 | ||
| 105 | if (!$result) { |
|
| 106 | $this->sqllog .= $this->error(); |
|
| 107 | } |
|
| 108 | ||
| 109 | return $result; |
|
| 110 | } |
|
| 111 | ||
| 112 | /** |
|
| 113 | * Escapes a string for use in a query. |
|
