]>
git.wh0rd.org - tt-rss.git/blob - classes/db/mysqli.php
2 class Db_Mysqli
implements IDb
{
6 function connect($host, $user, $pass, $db, $port) {
8 $this->link
= mysqli_connect($host, $user, $pass, $db, $port);
10 $this->link
= mysqli_connect($host, $user, $pass, $db);
17 die("Unable to connect to database (as $user to $host, database $db): " . mysqli_connect_error());
21 function escape_string($s, $strip_tags = true) {
22 if ($strip_tags) $s = strip_tags($s);
24 return mysqli_real_escape_string($this->link
, $s);
27 function query($query, $die_on_error = true) {
28 $result = @mysqli_query
($this->link
, $query);
30 $this->last_error
= @mysqli_error
($this->link
);
32 @mysqli_query
($this->link
, "ROLLBACK");
33 user_error("Query $query failed: " . ($this->link ?
$this->last_error
: "No connection"),
34 $die_on_error ? E_USER_ERROR
: E_USER_WARNING
);
40 function fetch_assoc($result) {
41 return mysqli_fetch_assoc($result);
45 function num_rows($result) {
46 return mysqli_num_rows($result);
49 function fetch_result($result, $row, $param) {
50 if (mysqli_data_seek($result, $row)) {
51 $line = mysqli_fetch_assoc($result);
59 return mysqli_close($this->link
);
62 function affected_rows($result) {
63 return mysqli_affected_rows($this->link
);
66 function last_error() {
67 return mysqli_error();
70 function last_query_error() {
71 return $this->last_error
;
75 $this->query("SET time_zone = '+0:0'");
77 if (defined('MYSQL_CHARSET') && MYSQL_CHARSET
) {
78 $this->query("SET NAMES " . MYSQL_CHARSET
);