Collaboration diagram for ilSCORM13DB:

Public Member Functions
	__construct ($dsn, $login, $password, $type='mysql')

	init ($dsn, $login, $password, $type='mysql')

	addQueries ()

	getLastId ()

	getType ()

&	getRecord ($tableOrView, $idname, $idvalue)

	setRecord ($tableOrView, $row, $idname=null)

&	getRecords ($tableOrView, $idname=null, $idvalues=null, $order=null, $paging=null)

	setRecords ($tableOrView, $rows, $idname=null)

	removeRecord ($table, $idname, $idvalue)

	removeRecords ($tables, $idnames, $idvalues)

&	query ($query, $params=null, $order=null, $paging=null, $fetchType=PDO::FETCH_ASSOC)

	exec ($queries, $params=null, &$result=null)
	exec('delete...') exec('delete... id=?', array(231)) exec('insert... id=?', array(array(231), array(130))) exec(array('select... id=?', 'select2... id=?'), array(array(231))) exec(array('select... id=?', 'select2... id=?'), array(array(231), array(130))) More...

	begin ()

	commit ()

	rollback ()

	il_to_pdo_dsn ($il_dsn)

Static Public Attributes
static	$DB

Private Member Functions
	getDSN ()

	getDB ()

	escapeName ($name)

	setLastId ($id)

Private Attributes
	$db

	$dsn

	$type

	$brackets

	$lastId

Static Private Attributes
static	$DSN

static	$TYPE

static	$BRACKETS

static	$LAST_ID

static	$ERRORS

static	$BRACKETS_LIST

static	$errors

static	$SQLCOMMAND = array()

Detailed Description

Author: Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e, Hendrik Holtmann holtm.nosp@m.ann@.nosp@m.mac.c.nosp@m.om, Alfred Kohnert alfre.nosp@m.d.ko.nosp@m.hnert.nosp@m.@big.nosp@m.foot..nosp@m.com

Version: $Id$

Definition at line 30 of file ilSCORM13DB.php.

Constructor & Destructor Documentation

◆ __construct()

ilSCORM13DB::__construct	(	$dsn,
		$login,
		$password,
		$type = `'mysql'`
	)

Definition at line 56 of file ilSCORM13DB.php.

        {
                try {
                        self::$DB = new PDO($dsn, $login, $password); 
                } catch (PDOException $e) {
                        error_log("Error!: " . $e->getMessage());       
                }
                $this->dsn = $dsn; 
                $this->brackets = self::$BRACKETS_LIST[$type]; 
                $this->type = is_null($type) ? substr($dsn, 0, strpos($dsn, ':')) : $type;
                $this->brackets = self::$BRACKETS_LIST[$this->type]; 
                
        }

References $dsn, $type, and Monolog\Handler\error_log().

Here is the call graph for this function:

Member Function Documentation

◆ addQueries()

ilSCORM13DB::addQueries ( )

Definition at line 82 of file ilSCORM13DB.php.

        {
                require_once("./Modules/Scorm2004/classes/ilSCORM13Player_mysql.php");
        }

Referenced by exec(), and query().

Here is the caller graph for this function:

◆ begin()

ilSCORM13DB::begin ( )

Definition at line 358 of file ilSCORM13DB.php.

        {
                self::getDB()->beginTransaction();
                self::$ERRORS = 0;
        }

References getDB().

Here is the call graph for this function:

◆ commit()

ilSCORM13DB::commit ( )

Definition at line 364 of file ilSCORM13DB.php.

        {
                self::$ERRORS 
                        ? self::getDB()->rollBack() 
                        : self::getDB()->commit();
                return self::$ERRORS;
        }

References $ERRORS, and getDB().

Here is the call graph for this function:

◆ escapeName()

ilSCORM13DB::escapeName ( $name )

private

Definition at line 116 of file ilSCORM13DB.php.

        {
                $b = $this && $this instanceof ilSCORM13DB 
                        ? $this->brackets 
                        : self::$BRACKETS; 
                return $b[0] . preg_replace('/[^\w_.-]/', '_', $name) . $b[1];
        }

References $BRACKETS.

Referenced by getRecord(), getRecords(), query(), removeRecords(), and setRecords().

Here is the caller graph for this function:

◆ exec()

ilSCORM13DB::exec	(		$queries,
			$params = `null`,
		&	$result = `null`
	)

exec('delete...')
exec('delete... id=?', array(231))
exec('insert... id=?', array(array(231), array(130)))
exec(array('select... id=?', 'select2... id=?'), array(array(231)))
exec(array('select... id=?', 'select2... id=?'), array(array(231), array(130)))

erstelle gleich dimensionale arrays f�r $queries und $params

Definition at line 304 of file ilSCORM13DB.php.

    { 
        if (!is_array($queries)) 
        { 
            $r = self::exec(array($queries), $params); 
            return $r[0]; 
        } 
        if (!is_array($params))  
        { 
            $params = array(); 
        } 
        if (!is_array(current($params)))  
        { 
            $params = array($params); 
        } 
        //$d = new PDO(self::getDSN()); 
        $d = self::getDB(); 
                self::addQueries();
        foreach ($queries as $i => &$q)  
        { 
           if ($s = $d->prepare($sql = (self::$SQLCOMMAND[$q] ? self::$SQLCOMMAND[$q] : $q)))  
            { 
                                error_log("SQL-Command: ".self::$SQLCOMMAND[$q]);
                $q = 0; 
                $r = array(); 
                $ps = is_array($params) ? $params[$i % count($params)] : null; 
                if (!is_array(current($ps)))  
                { 
                    $ps = array($ps); 
                } 
                foreach ($ps as $p)  
                { 
                 $q+=$s->execute($p);
                 $arr = $s->errorInfo();
                 file_put_contents('/tmp/sql.log', implode("\n", array('', date('c'), $sql, var_export($p, true),var_export($arr,true))), FILE_APPEND);  
                
                    if (is_array($result))  
                    { 
                        count($queries)<2 
                            ? $result = $s->fetchAll(PDO::FETCH_ASSOC) 
                            : $result[] = $s->fetchAll(PDO::FETCH_ASSOC); 
                    } 
                } 
            } 
            else 
            { 
                // prepare failed 
            } 
        } 
        unset($d); 
        return $queries;  
    } 

References $d, $params, $r, $result, addQueries(), Monolog\Handler\error_log(), exec(), and getDB().

Referenced by exec(), and removeRecords().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getDB()

ilSCORM13DB::getDB ( )

private

Definition at line 109 of file ilSCORM13DB.php.

        {
                return $this && $this instanceof ilSCORM13DB 
                        ? $this->db
                        : self::$DB; 
        }

References $DB.

Referenced by begin(), commit(), exec(), getLastId(), query(), removeRecords(), rollback(), and setRecords().

Here is the caller graph for this function:

◆ getDSN()

ilSCORM13DB::getDSN ( )

private

Definition at line 102 of file ilSCORM13DB.php.

        {
                return $this && $this instanceof ilSCORM13DB 
                        ? $this->dsn 
                        : self::$DSN; 
        }

References $DSN.

◆ getLastId()

ilSCORM13DB::getLastId ( )

Definition at line 87 of file ilSCORM13DB.php.

        {
                return self::getDB()->lastInsertId();
                return $this && $this instanceof ilSCORM13DB
                        ? $this->lastId
                        : self::$LAST_ID; 
        }

References $LAST_ID, and getDB().

Here is the call graph for this function:

◆ getRecord()

& ilSCORM13DB::getRecord	(	$tableOrView,
		$idname,
		$idvalue
	)

Definition at line 131 of file ilSCORM13DB.php.

        {
                if (!is_string($idname) || !is_numeric($idvalue))
                {
                        return false;
                }
                $q = 'SELECT * FROM ' . self::escapeName($tableOrView) . ' WHERE ' . self::escapeName($idname) . '=' . $idvalue;
                $r = self::query($q);
                return $r[0];
        }

References $r, escapeName(), and query().

Here is the call graph for this function:

◆ getRecords()

& ilSCORM13DB::getRecords	(	$tableOrView,
		$idname = `null`,
		$idvalues = `null`,
		$order = `null`,
		$paging = `null`
	)

Definition at line 148 of file ilSCORM13DB.php.

        {
                $tableOrView = self::escapeName($tableOrView);
                $q = "SELECT * FROM $tableOrView";
                if (is_string($idname) && is_array($idvalues))
                {
                        $idname = self::escapeName($idname);            
                        foreach ($idvalues as &$idvalue) 
                        {
                                if (!is_numeric($idvalue)) return false;
                                $idvalue = "$idname=$idvalue";
                        }
                        $q .= ' ' . implode(' OR ', $idvalues);
                }
                return self::query($q, null, $order, $paging);
        }

References escapeName(), and query().

Here is the call graph for this function:

◆ getType()

ilSCORM13DB::getType ( )

Definition at line 95 of file ilSCORM13DB.php.

        {
                return $this && $this instanceof ilSCORM13DB
                        ? $this->type
                        : self::$TYPE; 
        }

References $TYPE.

Referenced by setRecords().

Here is the caller graph for this function:

◆ il_to_pdo_dsn()

ilSCORM13DB::il_to_pdo_dsn ( $il_dsn )

Definition at line 378 of file ilSCORM13DB.php.

        {
                $pattern = '/([a-z]+)(:\/\/)([^:]*)(:)([^@]*)(@)([^\/]+)(\/)(.*)/i';
                preg_match($pattern, $il_dsn, $matches);
                $pdo_dsn[0]=$matches[1].":dbname=".$matches[9].";host=".$matches[7];
                $pdo_dsn[1]=$matches[3];
                $pdo_dsn[2]=$matches[5];
                return $pdo_dsn;
        }

◆ init()

ilSCORM13DB::init	(	$dsn,
		$login,
		$password,
		$type = `'mysql'`
	)

Definition at line 70 of file ilSCORM13DB.php.

        {       
                try {
                        self::$DB = new PDO($dsn, $login, $password); 
                } catch (PDOException $e) {
                        error_log("Error!: " . $e->getMessage());       
                }
                self::$DSN = $dsn;
                self::$TYPE = is_null($type) ? substr($dsn, 0, strpos($dsn, ':')) : $type;
                self::$BRACKETS = self::$BRACKETS_LIST[self::$TYPE]; 
        }

References $dsn, $TYPE, $type, and Monolog\Handler\error_log().

Here is the call graph for this function:

◆ query()

& ilSCORM13DB::query	(	$query,
		$params = `null`,
		$order = `null`,
		$paging = `null`,
		$fetchType = `PDO::FETCH_ASSOC`
	)

Definition at line 258 of file ilSCORM13DB.php.

        {
                $r = array();
                $d = self::getDB();
                self::addQueries();
                $q = array(self::$SQLCOMMAND[$query] ? self::$SQLCOMMAND[$query] : $query);
                if (is_array($order))
                {
                        $o = array();
                        foreach ($order as $k => $v) 
                        {
                                $o[] = self::escapeName($k) . ' ' . ($v ? 'ASC' : 'DESC');
                        }  
                        $q[] = 'ORDER BY ' . implode(', ', $o);
                }
                if (is_array($paging))
                {
                        if (is_int($o = $paging['count'])) 
                        {
                                // MySQL Style
                                $q[] = "LIMIT $o"; 
                                if (is_int($o = $paging['offset'])) 
                                {
                                        $q[] = "OFFSET $o";
                                }
                        }
                }
                $q = implode(' ', $q);
                $s = $d->prepare($q);
                $s->execute($params);
                $arr = $s->errorInfo();
        file_put_contents('/tmp/sql.log', implode("\n", array('', date('c'), $q, var_export($params, true),var_export($arr,true))), FILE_APPEND);
                $r = $s->fetchAll($fetchType);
                unset($d);
                return $r;
        }

References $d, $params, $query, $r, addQueries(), escapeName(), and getDB().

Referenced by getRecord(), and getRecords().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ removeRecord()

ilSCORM13DB::removeRecord	(	$table,
		$idname,
		$idvalue
	)

Definition at line 220 of file ilSCORM13DB.php.

        {
                self::removeRecords($table, $idname, array($idvalue));
        }

References removeRecords().

Here is the call graph for this function:

◆ removeRecords()

ilSCORM13DB::removeRecords	(	$tables,
		$idnames,
		$idvalues
	)

Definition at line 225 of file ilSCORM13DB.php.

        {
                if (!is_array($idvalues))
                {
                        return false;
                }
                //$d = new PDO(self::getDSN());
                $d = self::getDB();
                if (!is_array($tables))
                {
                        $tables = array($tables);
                } 
                if (!is_array($idnames))
                {
                        $idnames = array($idnames);
                }
                $tables = array_reverse($tables);
                foreach ($tables as $i => &$table) 
                {
                        $table = self::escapeName($table);
                        $idname = $idnames[$i % count($idnames)];
                        if (!is_string($idname)) return false;
                        $idname = self::escapeName($idname);
                        $q = "DELETE FROM $table WHERE $idname=?";
                        foreach ($idvalues as $idvalue) 
                        {
                                $table = self::exec($q, $idvalue);
                        }
                }
                unset($d);
                return array_reverse($tables);
        }       

References $d, escapeName(), exec(), and getDB().

Referenced by removeRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ rollback()

ilSCORM13DB::rollback ( )

Definition at line 372 of file ilSCORM13DB.php.

        {
                self::getDB()->rollBack(); 
        }

References getDB().

Here is the call graph for this function:

◆ setLastId()

ilSCORM13DB::setLastId ( $id )

private

Definition at line 124 of file ilSCORM13DB.php.

        {
                $this && $this instanceof ilSCORM13DB
                        ? $this->lastId = $id
                        : self::$LAST_ID = $id;
        }

Referenced by setRecords().

Here is the caller graph for this function:

◆ setRecord()

ilSCORM13DB::setRecord	(	$tableOrView,
		$row,
		$idname = `null`
	)

Definition at line 142 of file ilSCORM13DB.php.

        {
                $r = self::setRecords($tableOrView, array($row), $idname);
                return $r[0];
        }

References $r, $row, and setRecords().

Here is the call graph for this function:

◆ setRecords()

ilSCORM13DB::setRecords	(	$tableOrView,
		$rows,
		$idname = `null`
	)

Definition at line 165 of file ilSCORM13DB.php.

        {
                //$d = new PDO(self::getDSN());
                $d = self::getDB();
                $r = 0;
                if (!is_array($row = $rows[0]))
                {
                        return false;
                }
                $tableOrView = self::escapeName($tableOrView);
                $q = array();
                if (is_string($idname)) {
                        $idvalue = $row[$idname];
                        $idname = self::escapeName($idname);
                }
                $u = is_numeric($idvalue);
                if ($u)
                {
                        foreach (array_keys($row) as $k) 
                        {
                                $q[] = self::escapeName($k) . '=?';
                        }
                        $q = implode(', ', $q);
                        $q = "UPDATE $tableOrView SET $q WHERE $idname=$idvalue";
                }
                else 
                {                       
                        foreach (array_keys($row) as $k) 
                        {
                                $q[] = self::escapeName($k);
                        }
                        $q = implode(', ', $q);
                        $q = "INSERT INTO $tableOrView ($q) VALUES (" . str_pad('', count($row)*2-1, '?,') . ')';
                }
                //echo "<br>$q";
                if ($s = $d->prepare($q)) 
                {
                        $type = self::getType();
                        foreach ($rows as &$row)
                        {
                                $row = $s->execute(array_values($row));
                                $arr = $s->errorInfo();
                file_put_contents('/tmp/sql.log', implode("\n", array('', date('c'), $sql, var_export($q, true),var_export($arr,true))), FILE_APPEND);  
                
                                if (!$u && is_string($idname) && $row)
                                {
                                        $row = $d->lastInsertId();
                                        self::setLastId($row);
                                } 
                        } 
                }
                unset($d);
                return $rows;
        }

References $d, $r, $row, $type, escapeName(), getDB(), getType(), and setLastId().

Referenced by setRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $BRACKETS

ilSCORM13DB::$BRACKETS

staticprivate

Definition at line 37 of file ilSCORM13DB.php.

Referenced by escapeName().

◆ $brackets

ilSCORM13DB::$brackets

private

Definition at line 49 of file ilSCORM13DB.php.

◆ $BRACKETS_LIST

ilSCORM13DB::$BRACKETS_LIST

staticprivate

Initial value:

= array(
                'mysql' => '``', 
                'sqlite' => '""',
        )

Definition at line 40 of file ilSCORM13DB.php.

◆ $DB

ilSCORM13DB::$DB

static

Definition at line 34 of file ilSCORM13DB.php.

Referenced by getDB().

◆ $db

ilSCORM13DB::$db

private

Definition at line 46 of file ilSCORM13DB.php.

◆ $DSN

ilSCORM13DB::$DSN

staticprivate

Definition at line 35 of file ilSCORM13DB.php.

Referenced by getDSN().

◆ $dsn

ilSCORM13DB::$dsn

private

Definition at line 47 of file ilSCORM13DB.php.

Referenced by __construct(), and init().

◆ $ERRORS

ilSCORM13DB::$ERRORS

staticprivate

Definition at line 39 of file ilSCORM13DB.php.

Referenced by commit().

◆ $errors

ilSCORM13DB::$errors

staticprivate

Definition at line 51 of file ilSCORM13DB.php.

◆ $LAST_ID

ilSCORM13DB::$LAST_ID

staticprivate

Definition at line 38 of file ilSCORM13DB.php.

Referenced by getLastId().

◆ $lastId

ilSCORM13DB::$lastId

private

Definition at line 50 of file ilSCORM13DB.php.

◆ $SQLCOMMAND

ilSCORM13DB::$SQLCOMMAND = array()

staticprivate

Definition at line 53 of file ilSCORM13DB.php.

◆ $TYPE

ilSCORM13DB::$TYPE

staticprivate

Definition at line 36 of file ilSCORM13DB.php.

Referenced by getType(), and init().

◆ $type

ilSCORM13DB::$type

private

Definition at line 48 of file ilSCORM13DB.php.

Referenced by __construct(), init(), and setRecords().

The documentation for this class was generated from the following file:

Modules/Scorm2004/classes/ilSCORM13DB.php

Public Member Functions

Static Public Attributes

Private Member Functions

Private Attributes

Static Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addQueries()

◆ begin()

◆ commit()

◆ escapeName()

◆ exec()

◆ getDB()

◆ getDSN()

◆ getLastId()

◆ getRecord()

◆ getRecords()

◆ getType()

◆ il_to_pdo_dsn()

◆ init()

◆ query()

◆ removeRecord()

◆ removeRecords()

◆ rollback()

◆ setLastId()

◆ setRecord()

◆ setRecords()

Field Documentation

◆ $BRACKETS

◆ $brackets

◆ $BRACKETS_LIST

◆ $DB

◆ $db

◆ $DSN

◆ $dsn

◆ $ERRORS

◆ $errors

◆ $LAST_ID

◆ $lastId

◆ $SQLCOMMAND

◆ $TYPE

◆ $type