]>
git.wh0rd.org - tt-rss.git/blob - classes/db/mysqli.php
2 class Db_Mysqli
implements IDb
{
5 function connect($host, $user, $pass, $db, $port) {
7 $this->link
= mysqli_connect($host, $user, $pass, $db, $port);
9 $this->link
= mysqli_connect($host, $user, $pass, $db);
16 die("Unable to connect to database (as $user to $host, database $db): " . mysqli_connect_error());
20 function escape_string($s, $strip_tags = true) {
21 if ($strip_tags) $s = strip_tags($s);
23 return mysqli_real_escape_string($this->link
, $s);
26 function query($query, $die_on_error = true) {
27 $result = @mysqli_query
($this->link
, $query);
29 $error = @mysqli_error
($this->link
);
31 @mysqli_query
($this->link
, "ROLLBACK");
32 user_error("Query $query failed: " . ($this->link ?
$error : "No connection"),
33 $die_on_error ? E_USER_ERROR
: E_USER_WARNING
);
39 function fetch_assoc($result) {
40 return mysqli_fetch_assoc($result);
44 function num_rows($result) {
45 return mysqli_num_rows($result);
48 function fetch_result($result, $row, $param) {
49 if (mysqli_data_seek($result, $row)) {
50 $line = mysqli_fetch_assoc($result);
58 return mysqli_close($this->link
);
61 function affected_rows($result) {
62 return mysqli_affected_rows($this->link
);
65 function last_error() {
66 return mysqli_error();
70 $this->query("SET time_zone = '+0:0'");
72 if (defined('MYSQL_CHARSET') && MYSQL_CHARSET
) {
73 $this->query("SET NAMES " . MYSQL_CHARSET
);