Subversion-Projekte lars-tiefland.shop_ns

Revision

Revision 24 | Zur aktuellen Revision | Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
2 lars 1 
<?php
2 
 
3 
    /**
4 
     * @author Lars Tiefland
5 
     * @copyright 2012
6 
     */
7 
    namespace Weban;
8 
    class randelement
9 
    {
10 
        public function __construct( $id )
11 
        {
12 
            $sql = "SELECT
13 
                    id,
14 
                    ueberschrift AS titel,
15 
                    text AS inhalt,
16 
                    typ,
17 
                    untertyp,
18 
                    bild_url,
19 
                    bild_link,
20 
                    position
21 
                FROM
22 
                    sonderkasten
23 
                WHERE
24 
                    id = $id
25 
            ";
26 
            $res = $GLOBALS["db"]->query( $sql );
27 
            $row = $res->fetchRow();
28 
            foreach ( $row as $feld => $wert )
29 
            {
30 
                $this->$feld = $wert;
31 
            }
32 
        }
33 
 
34 
        public static function Liste( $position )
35 
        {
36 
            $sql = "SELECT
37 
                    id
38 
                FROM
39 
                    sonderkasten
40 
                WHERE
41 
                    position LIKE '%$position%'
42 
                AND
43 
                    language = '" . $GLOBALS["INI"]["language"] . "'
44 
                AND
45 
                    shops_ID = '" . $GLOBALS["INI"]["shops_ID"] . "'
46 
            ";
47 
            $res = $GLOBALS["db"]->query( $sql );
48 
            while ( $row = $res->fetchRow() )
49 
            {
50 
                $ret[] = new randelement( $row["id"] );
51 
            }
52 
            return $ret;
53 
        }
54 
    }
55 
 
56 
?>