DB-Handler The DB-Handler contains the SQL functions for the ILIAS3-Calendar. More...

Public Member Functions
	ilCalDBHandler ()
	DBHandler Constructor @ access public.
	select ($dbTable, $column="", $whereCondition="", $orderConstruct="")
	select statement
	insert ($number_of_values, $dbTable, $fields, $values)
	insert statement
	update ($dbTable, $values, $whereCondition)
	update statement
	delete ($dbTable, $whereCondition, $delete=false)
	delete statement
Data Fields
	$ilias
	$dbTable
	$className = "ilCalDBHandler"
	$orderConstruct
	$whereCondition
	$column
	$number_of_values = 0
	$values
	$query
	$result

Detailed Description

DB-Handler The DB-Handler contains the SQL functions for the ILIAS3-Calendar.

version 1.0

Author:: Christoph Schulz-Sacharov <sch-sa@gmx.de>; MArtin Schumacher <ilias@auchich.de>; Mark Ulbrich <Mark_Ulbrich@web.de>

Definition at line 13 of file class.ilCalDBHandler.php.

Member Function Documentation

ilCalDBHandler::delete	(	$	dbTable,
		$	whereCondition,
		$	delete = `false`
	)

delete statement

Parameters:

string

dbTable, string whereCondition public

Definition at line 180 of file class.ilCalDBHandler.php.

References $dbTable, $query, $result, and $whereCondition.

                                                                  {
                if (strlen($dbTable) != 0 && strlen($whereCondition) != 0) {
                        $query = "DELETE FROM {$dbTable} WHERE {$whereCondition}";
                        $result = $this->ilias->db->query($query);
                }
                elseif (strlen($dbTable) != 0 && strlen($whereCondition) == 0 && $delete == true) {
                        $query = "DELETE FROM {$dbTable}";
                        $result = $this->ilias->db->query($query);
                }
                else {
                        die ($this->className . "::delete(): incorrect parameters.");
                }
        }

ilCalDBHandler::ilCalDBHandler ( )

DBHandler Constructor @ access public.

Definition at line 98 of file class.ilCalDBHandler.php.

References $ilias.

                                  {
                global $ilias;
                $this->ilias =& $ilias;
        }

ilCalDBHandler::insert	(	$	number_of_values,
		$	dbTable,
		$	fields,
		$	values
	)

insert statement

Parameters:

int

$number_of_values, string $values (only a single string), string $dbTable public

Definition at line 145 of file class.ilCalDBHandler.php.

References $number_of_values, $query, and $result.

                                                                       {
      switch ($number_of_values) {
        case 0: die($this->className . "::insert(): no number_of_values given.");
                 break;
         case 1: $query = "INSERT INTO {$dbTable} ({$fields}) VALUE ({$values})";
                 break;
         default: $query = "INSERT INTO {$dbTable} ({$fields}) VALUES ({$values})";
      }
//echo "<b>DBHandler:insert:</b> ".$query."<br>";
                $result = $this->ilias->db->query($query);
        }

ilCalDBHandler::select	(	$	dbTable,
		$	column = `""`,
		$	whereCondition = `""`,
		$	orderConstruct = `""`
	)

select statement

Returns:: result set

Parameters:

string

$dbTable; opt: string $column, string $where, string orderConstruct public

Definition at line 110 of file class.ilCalDBHandler.php.

References $column, $dbTable, $orderConstruct, $query, $result, and $whereCondition.

                                                                                      {
                if (strlen($dbTable) == 0) {
                        die($this->className . "::select(): No dbTable given.");
                }
                else {
                        if (strlen($column) == 0) {
                                $column = "*";
                        }
                        if (strlen($orderConstruct) == 0) {
                        if (strlen($whereCondition) == 0) {
                                $query = "SELECT {$column} FROM {$dbTable}";
                      }
                      else {
                                $query = "SELECT {$column} FROM {$dbTable} WHERE {$whereCondition}";
                           }
                   }
                   else {
                        if (strlen($whereCondition) == 0) {
                        $query = "SELECT {$column} FROM {$dbTable} ORDER BY {$orderConstruct}";
                      }
                      else {
                        $query = "SELECT {$column} FROM {$dbTable} WHERE {$whereCondition} ORDER BY {$orderConstruct}";
                                }
                   }
                        $result = $this->ilias->db->query($query);
                        //echo "Select: ".$query."<br>";
                        return $result;
                }
        }

ilCalDBHandler::update	(	$	dbTable,
		$	values,
		$	whereCondition
	)

update statement

Parameters:

string

dbTable, string values (<column>=<new value>="">), string whereCondition public

Definition at line 163 of file class.ilCalDBHandler.php.

References $dbTable, $query, $result, $values, and $whereCondition.

                                                            {
                if (strlen($dbTable) != 0 && strlen($values) != 0 && strlen($whereCondition) != 0) {
                        $query = "UPDATE {$dbTable} SET {$values} WHERE {$whereCondition}";
                        $result = $this->ilias->db->query($query);
//echo "DBHandler->update():".$query."<br>";
                }
                else {
                        die ($this->className . "::update(): incorrect parameters.");
                }
        }