Subversion-Projekte lars-tiefland.shop_ns

<?php

    /**

     * @author Lars Tiefland

     * @copyright 2012

     */

    namespace Weban;

    class hersteller

    {

        public function __construct( $id )

        {

            $sql = "SELECT

                    id,

                    name,

                    logo,

                    homepage

                FROM

                    hersteller

                WHERE

                    id = $id

            ";

            $res = $GLOBALS["db"]->query( $sql );

            $row = $res->fetchRow();

            $this->id = $row["id"];

            $this->name = $row["name"];

            $this->logo = $row["logo"];

            $this->homepage = $row["homepage"];

        }

        public static function Liste()

        {

            $sql = "SELECT

                    id

                FROM

                    hersteller

            ";

            $res = $GLOBALS["db"]->query( $sql );

            while ( $row = $res->fetchRow() )

            {

                $ret[] = new hersteller( $row["id"] );

            }

            return $ret;

        }

    }

?>