Lines Matching refs:db
254 $db = $this->sqlitehelper->getDB();
283 $where = 'WHERE blog = ' . $db->quote_string($query['blog']) . ' ';
291 $where .= 'AND ( title LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
294 $where .= 'AND ( author LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
297 … $where .= 'AND ( comments.text LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
300 … $where .= 'AND ( comments.ip LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
303 … $where .= 'AND ( tags.tag LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
310 $where .= 'AND ( comments.pid = ' . $db->quote_string($query['pid']) . ' ) ';
322 $res = $db->query($sqlcount);
323 $count = $db->res2single($res);
325 $resid = $db->query($sqlselect);