classes/Calendar/class.ilCalDBHandler.php

Go to the documentation of this file.

<?php

class ilCalDBHandler
{
        var $ilias;

        var $dbTable;

        var $className="ilCalDBHandler";

        var $orderConstruct;

        var $whereCondition;

        var $column;

        var $number_of_values = 0;

        var $values;

        var $query;

        var $result;

        function ilCalDBHandler() {
                global $ilias;
                $this->ilias =& $ilias;
        }


        function select($dbTable ,$column="" ,$whereCondition="" ,$orderConstruct="") {
                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;
                }
        }

        function insert($number_of_values, $dbTable, $fields, $values) {
      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);
        }

        function update($dbTable, $values, $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.");
                }
        }

        function delete($dbTable, $whereCondition, $delete=false) {
                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.");
                }
        }

}

?>