[PHP] Verstehe Class nicht.

Tab · 12 Januar 2008

Vielen dank für deine/eure Antworten:

Habe mir mal einen Code angeschaut und wollte mal wissen wie man jetzt zum Beispiel mit der Klasse eine Tabelle mit Inhalt füllen (INSERT)?

WIe müsste das jetzt aussehen?

PHP:

<?php
/**
 * database abstraction layer
 */
class Database {
    var $link = false;
    var $debug = false;
    var $error_log = array();

    var $db_new = false;
    var $db_name = false;
    var $db_host = false;
    var $db_user = false;
    var $db_pass = false;

    var $query_count = 0;
    var $query_log = array();


    function connect($host, $user, $pass, $new = true) {
        if($this->link = mysql_connect($host, $user, $pass, $new)) {
            $this->db_host = $host;
            $this->db_user = $user;
            $this->db_pass = $pass;

            return true;
        } else {
            $this->db_host = false;
            $this->db_user = false;
            $this->db_pass = false;

            //!TODO: Fehler-Log in Datei
            if($this->debug) {
                header('HTTP/1.1 503 Service Unavailable');
                die;
            } else {
                header('HTTP/1.1 503 Service Unavailable');
                die;
            }
        }
    }

    // select
    function select($database) {
        if(@mysql_select_db($database, $this->link)) {
            $this->db_name = $database;

            return true;
        } else {
            $this->db_name = false;

            //!TODO: Fehler-Log in Datei
            if($this->debug) {
                header('HTTP/1.1 503 Service Unavailable');
                die;
            } else {
                header('HTTP/1.1 503 Service Unavailable');
                die;
            }            
        }
    }

    // close
    function close() {
        @mysql_close($this->link);

        return true;
    }

    // disconnect
    function disconnect() {
        @mysql_close($this->link);

        return true;
    }

    // reconnect
    function reconnect() {
        $this->connect($this->db_host, $this->db_user, $this->db_pass, $this->db_new);
        $this->select($this->db_name);
    }


    // insert
    function insert($table, $values, $ignore = false) {
        ++$this->query_count;
        if(!$ignore) {
            $query = 'INSERT INTO '.$table.' VALUES('.$values.')';
        } else {
            $query = 'INSERT IGNORE INTO '.$table.' VALUES('.$values.')';
        }
        $this->query_log[] = $query;

        if(@mysql_query($query, $this->link)) {
            return true;
        } else {
            $this->error_log[] = array('query' => $query, 'error' => mysql_error(), 'errno' => mysql_errno());
            if($this->debug) { echo mysql_error().'<br>'; }

            return false;
        }        
    }

    // update
    function update($table, $set, $where) {
        ++$this->query_count;
        $query = trim('UPDATE '.$table.' SET '.$set.' '.$where);
        $this->query_log[] = $query;

        if(@mysql_query($query, $this->link)) {
            return true;
        } else {
            $this->error_log[] = array('query' => $query, 'error' => mysql_error(), 'errno' => mysql_errno());
            if($this->debug) { echo mysql_error().'<br>'; }

            return false;
        }
    }

    // delete
    function delete($table, $where) {
        ++$this->query_count;
        $query = trim('DELETE FROM '.$table.' '.$where);
        $this->query_log[] = $query;

        if(@mysql_query($query, $this->link)) {
            return true;
        } else {
            $this->error_log[] = array('query' => $query, 'error' => mysql_error(), 'errno' => mysql_errno());
            if($this->debug) { echo mysql_error().'<br>'; }

            return false;
        }
    }


    // do_query
    function do_query($query) {
        ++$this->query_count;
        $this->query_log[] = $query;

        if(@mysql_query($query, $this->link)) {
            return true;
        } else {
            $this->error_log[] = array('query' => $query, 'error' => mysql_error(), 'errno' => mysql_errno());
            if($this->debug) { echo mysql_error().'<br>'; }

            return false;
        }
    }

    // get_query
    function get_query($query) {
        ++$this->query_count;
        $this->query_log[] = $query;
        $array = array();

        $mysql_query = @mysql_query($query, $this->link);
        if($mysql_query) {
            while($row = mysql_fetch_assoc($mysql_query)) {
                $array[] = $row;
            }
            return $array;
        } else {
            $this->error_log[] = array('query' => $query, 'error' => mysql_error(), 'errno' => mysql_errno());
            if($this->debug) { echo mysql_error().'<br>'; }

            return false;
        }
    }

    // get_array
    function get_array($table, $where) {
        ++$this->query_count;
        $query = trim('SELECT * FROM '.$table.' '.$where);
        $this->query_log[] = $query;
        $array = array();

        $mysql_query = @mysql_query($query, $this->link);
        if($mysql_query) {
            while($arr = mysql_fetch_assoc($mysql_query)) {
                $array[] = $arr;
            }
            return $array;
        } else {
            $this->error_log[] = array('query' => $query, 'error' => mysql_error(), 'errno' => mysql_errno());
            if($this->debug) { echo mysql_error().'<br>'; }

            return false;
        }
    }

    // get_row
    function get_row($table, $where) {
        ++$this->query_count;
        $query = trim('SELECT * FROM '.$table.' '.$where.' LIMIT 1');
        $this->query_log[] = $query;
        $array = array();

        $mysql_query = @mysql_query($query, $this->link);
        if($mysql_query) {
            $arr = mysql_fetch_assoc($mysql_query);

            return $arr;
        } else {
            $this->error_log[] = array('query' => $query, 'error' => mysql_error(), 'errno' => mysql_errno());
            if($this->debug) { echo mysql_error().'<br>'; }

            return false;
        }
    }

    // get_count
    function get_count($table, $where) {
        ++$this->query_count;
        $query = trim('SELECT COUNT(*) FROM '.$table.' '.$where);
        $this->query_log[] = $query;

        $mysql_query = @mysql_query($query, $this->link);
        if($mysql_query) {
            $arr = mysql_fetch_row($mysql_query);

            return $arr[0];
        } else {
            $this->error_log[] = array('query' => $query, 'error' => mysql_error(), 'errno' => mysql_errno());
            if($this->debug) { echo mysql_error().'<br>'; }

            return 0;
        }
    }


    // get_id
    function get_id() {
        return mysql_insert_id($this->link);
    }

    // affected_rows
    function affected_rows() {
        return mysql_affected_rows($this->link);
    }
}
?>

PHP:

$db = New Database(); 
$db->connect( DB_HOST, DB_USER, DB_PASS ); 
$db->select( DB_NAME ); 
$db->insert( tabelle, array mit values);

so?

Und was genau müsste ich hier hinein schreiben?

PHP:

$db->insert( tabelle, array mit values);

Liebe Grüße
Markus

[PHP] Verstehe Class nicht.

Tab

unlimited