DB_Sql::query() - Code Metrics - intraface/intraface.dk - Measure and Improve Code Quality continuously with Scrutinizer

DB_Sql::query() A
last analyzed 2017-03-20 12:20 UTC

↳ Parent: DB_Sql

Complexity

Conditions	2
Paths	2

Size

Total Lines	7
Code Lines	4

Duplication

Lines	7
Ratio	100 %

Importance

Changes

Metric	Value
cc	2
eloc	4
nc	2
nop	1
dl	7
loc	7
rs	9.4285
c	0
b	0
f	0

<?php
/**
 * This is an old PHP4 database abstraction class. It has be rewritten to use
 * a singleton of PEARs MDB2.
 */
require_once 'MDB2.php';

class DB_Sql
{
    var $db;
    var $row;
    var $result;

    function DB_Sql($dbhost = '', $dbuser = '', $dbpass = '', $dbname = '')

    {
        if (empty($dbhost) OR empty($dbuser) OR empty($dbpass) OR empty($dbname)) {
// Logical operators have lower precedence:
$f = false or true;

// is executed like this:
($f = false) or true;


// Boolean operators have higher precedence:
$f = false || true;

// is executed like this:
$f = (false || true);
            $this->db = MDB2::singleton(DB_DSN);
        } else {
            $this->db = MDB2::singleton('mysql://' . $dbuser . ':' . $dbpass . '@' . $dbhost . '/' . $dbname);
        }

        if (PEAR::isError($this->db)) {
            die($this->db->getMessage() . ' ' . $this->db->getUserInfo());

        }
        $this->db->query('SET NAMES utf8');
        $this->db->setOption('portability', MDB2_PORTABILITY_NONE);
    }

    function query($SQL)

    {
        $this->result = $this->db->query($SQL);
        if (PEAR::isError($this->result)) {
            die($this->result->getMessage() . ' ' . $this->result->getUserInfo());

        }
    }

    function exec($SQL)

    {
        $this->result = $this->db->exec($SQL);
        if (PEAR::isError($this->result)) {
            die($this->result->getMessage() . ' ' . $this->result->getUserInfo());

        }

        $this->result->free();
    }

    function nextRecord()

    {
        // Gennemsøger recordset.
        // Går videre til næste post hver gang den kaldes.
        // Returnere true så længe der er en post
        // while($db->next_record()) {

        $this->row = $this->result->fetchRow(MDB2_FETCHMODE_ASSOC);
        if (PEAR::isError($this->row)) {
            die($this->row->getMessage() . '' . $this->row->getUserInfo());

        }

        return($this->row);
    }

    function affectedRows()
    {
        // returnere antallet af berørte rækker ved INSERT, UPDATE, DELETE
        // print($db->affected_rows());


        return($this->db->_affectedRows(NULL));

    }

    function f($name)
    {
        // Returnere værdien fra feltet med navet som er angivet.
        // Print($db->f("felt"));

        return($this->row[$name]);
    }

    function free()
    {
        // Frigør hukommelse til resultatet
        // $db->free();

        $this->result->free();
    }

    function insertedId()
    {
        // Returnere det id som lige er blevet indsat
        // $sidste_id = $db->inserted_id();


        return($this->db->lastInsertID());
    }

    function numRows()
    {
        // Returnere antallet af rækker
        // print($db->num_rows());


        return($this->result->numRows());
    }

    function escape($value)
    {
        return mysql_escape_string($value);

    }

    function quote($value, $type)
    {
        return $this->db->quote($value, $type);
    }
}


intraface / intraface.dk

DB_Sql::query() A last analyzed 2017-03-20 12:20 UTC

Complexity

Size

Duplication

Importance

Logical Operators are used for Control-Flow

Duplication Side-by-Side

Filter issues like

DB_Sql::query() A
last analyzed 2017-03-20 12:20 UTC