Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 111 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?
114 lars 2 
    class Ort
3 
    {
4 
        var $o_id;
5 
        var $o_name;
6 
        var $o_name2;
7 
 
8 
        function __construct( $o_id )
9 
        {
10 
            global $db, $db_meld, $error, $meld;
11 
            $o_id = intval( $o_id );
12 
            $sql = "SELECT * FROM locations WHERE l_id=$o_id";
13 
            $res = $db->query( $sql );
14 
            if ( true == DB::isError($res) )
15 
            {
16 
                $error = "true";
17 
                $meld = "Ein Fehler ist aufgetreten!";
18 
                $db_meld = $res->getUserInfo();
19 
                return $error;
20 
            }
21 
            else
22 
            {
23 
                $row = $res->fetchRow();
24 
                $this->o_id = $o_id;
25 
                $this->o_name = $row["l_name"];
26 
                $this->o_name2 = $row["l_name2"];
27 
                return $this;
28 
            }
29 
        }
30 
 
31 
        function update( $l_name, $l_name2 )
32 
        {
33 
            $this->o_name = $l_name;
34 
            $this->o_name2 = $l_name2;
35 
        }
36 
 
37 
        function save( $op )
38 
        {
39 
            global $db;
40 
            switch ( $op )
41 
            {
42 
                case "save":
43 
                    $sql = "INSERT INTO locations (l_name, l_name2)
111 lars 44 
						VALUES ('$this->o_name', '$this->o_name2')";
114 lars 45 
                    break;
46 
                case "update":
47 
                    $sql = "UPDATE locations SET l_name='$this->o_name', l_name2='$this->o_name2' WHERE l_id=$this->o_id";
48 
                    break;
49 
                case "del":
50 
                    $sql = "DELETE FROM locations WHERE l_id=$this->o_id";
51 
                    break;
52 
            }
53 
            return $db->query( $sql );
54 
        }
55 
 
56 
        function listeOrt( $limit, $start = 0 )
57 
        {
58 
            global $db, $db_meld, $error, $meld, $user;
59 
            $sql = "SELECT * FROM locations";
60 
            if ( $db->provides('limit') && $limit > 0 )
61 
            {
62 
                $res = $db->limitquery( $sql, $start, $limit );
63 
            }
64 
            else
65 
            {
66 
                $res = $db->query( $sql );
67 
            }
68 
            if ( true == DB::isError($res) )
69 
            {
70 
                $error = true;
71 
                $meld = "Ein Fehler ist aufgetreten!";
72 
                $db_meld = $res->getUserInfo();
73 
            }
74 
            return $res;
75 
        }
76 
    }
3 lars 77 
?>