MYSQL-QUERY

SQL: SELECT p.a_nr AS a_nr, p.kat_nr AS kat_nr, p.name AS name, p.image AS image, p.linkname AS linkname, k.linkname AS klinkname FROM shop_produkt p, shop_kategorie k WHERE p.status = '1' AND p.online = '1' AND k.status = '1' AND k.online = '1' AND p.kat_nr = k.kat_nr ORDER BY k.sort, p.sort

MYSQL-QUERY

SQL: SELECT * FROM shop_land WHERE l_id = 'us' AND status = '1' LIMIT 1

MYSQL-QUERY

SQL: SELECT * FROM shop_land WHERE l_id = 'de' LIMIT 1

MYSQL-QUERY

SQL: SELECT * FROM shop_land WHERE status = '1' ORDER BY name

---

REQUEST

Array
(
    [0] => dev
    [lang] => us
    [referer] => 
    [referenz] => 
    [warenkorb] => f9e17010a00de375783c0d526276cc43
    [historie] => 
)

COOKIE

Array
(
)

COOKIE

Array
(
    [expires] => 1645666042
    [path] => /shop/
    [domain] => www.elektronik-kompendium.de
    [secure] => 1
    [httponly] => 1
)

SESSION

Array
(
    [lifetime] => 1645666042
    [path] => /shop/
    [domain] => www.elektronik-kompendium.de
    [secure] => 1
    [httponly] => 1
)

SESSION

Array
(
    [lang] => us
    [referenz] => 
)

Warenkorb

Array
(
)

Versandkosten pro Bestellung

Array
(
    [l_id] => de
    [name] => Deutschland
    [shipping] => 3.50
    [status] => 1
)

Produkte auf der Startseite

Array
(
    [111] => Array
        (
            [a_nr] => 111
            [name] => Elektronik-Fibel
            [kat_nr] => 110
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-efibel-330.jpg
            [linkname] => elektronik-fibel
            [klinkname] => buecher
        )

    [112] => Array
        (
            [a_nr] => 112
            [name] => Kommunikationstechnik-Fibel
            [kat_nr] => 110
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-kfibel-330.jpg
            [linkname] => kommunikationstechnik-fibel
            [klinkname] => buecher
        )

    [113] => Array
        (
            [a_nr] => 113
            [name] => Computertechnik-Fibel
            [kat_nr] => 110
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-cfibel-330.jpg
            [linkname] => computertechnik-fibel
            [klinkname] => buecher
        )

    [114] => Array
        (
            [a_nr] => 114
            [name] => Netzwerktechnik-Fibel
            [kat_nr] => 110
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-nfibel-330.jpg
            [linkname] => netzwerktechnik-fibel
            [klinkname] => buecher
        )

    [125] => Array
        (
            [a_nr] => 125
            [name] => Timer 555
            [kat_nr] => 110
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-timer-330.jpg
            [linkname] => timer-555
            [klinkname] => buecher
        )

    [118] => Array
        (
            [a_nr] => 118
            [name] => Operationsverstärker und Instrumentationsverstärker
            [kat_nr] => 110
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-opv-330.jpg
            [linkname] => operationsverstaerker-und-instrumentationsverstaerker
            [klinkname] => buecher
        )

    [119] => Array
        (
            [a_nr] => 119
            [name] => Formelbuch
            [kat_nr] => 110
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-formelbuch-330.jpg
            [linkname] => formelbuch
            [klinkname] => buecher
        )

    [131] => Array
        (
            [a_nr] => 131
            [name] => Elektronik-Fibel (PDF)
            [kat_nr] => 130
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-efibel-ebook-330.jpg
            [linkname] => elektronik-fibel
            [klinkname] => ebooks
        )

    [132] => Array
        (
            [a_nr] => 132
            [name] => Kommunikationstechnik-Fibel (PDF)
            [kat_nr] => 130
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-kfibel-ebook-330.jpg
            [linkname] => kommunikationstechnik-fibel
            [klinkname] => ebooks
        )

    [133] => Array
        (
            [a_nr] => 133
            [name] => Computertechnik-Fibel (PDF)
            [kat_nr] => 130
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-cfibel-ebook-330.jpg
            [linkname] => computertechnik-fibel
            [klinkname] => ebooks
        )

    [134] => Array
        (
            [a_nr] => 134
            [name] => Netzwerktechnik-Fibel (PDF)
            [kat_nr] => 130
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-nfibel-ebook-330.jpg
            [linkname] => netzwerktechnik-fibel
            [klinkname] => ebooks
        )

    [135] => Array
        (
            [a_nr] => 135
            [name] => Collection IPv6 (PDF)
            [kat_nr] => 130
            [image] => https://www.elektronik-kompendium.de/res/bilder/collection-ipv6-330.jpg
            [linkname] => collection-ipv6
            [klinkname] => ebooks
        )

    [136] => Array
        (
            [a_nr] => 136
            [name] => Timer 555 (PDF)
            [kat_nr] => 130
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-timer-ebook-330.jpg
            [linkname] => timer-555
            [klinkname] => ebooks
        )

    [137] => Array
        (
            [a_nr] => 137
            [name] => Operationsverstärker und Instrumentationsverstärker (PDF)
            [kat_nr] => 130
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-opv-ebook-330.jpg
            [linkname] => opv-buch
            [klinkname] => ebooks
        )

    [138] => Array
        (
            [a_nr] => 138
            [name] => Formelbuch (PDF)
            [kat_nr] => 130
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-formelbuch-ebook-330.jpg
            [linkname] => formelbuch
            [klinkname] => ebooks
        )

    [141] => Array
        (
            [a_nr] => 141
            [name] => Elektronik-Fibel (Bundle)
            [kat_nr] => 140
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-efibel-bundle-330.jpg
            [linkname] => elektronik-fibel
            [klinkname] => bundle
        )

    [142] => Array
        (
            [a_nr] => 142
            [name] => Kommunikationstechnik-Fibel (Bundle)
            [kat_nr] => 140
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-kfibel-bundle-330.jpg
            [linkname] => kommunikationstechnik-fibel
            [klinkname] => bundle
        )

    [143] => Array
        (
            [a_nr] => 143
            [name] => Computertechnik-Fibel (Bundle)
            [kat_nr] => 140
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-cfibel-bundle-330.jpg
            [linkname] => computertechnik-fibel
            [klinkname] => bundle
        )

    [144] => Array
        (
            [a_nr] => 144
            [name] => Netzwerktechnik-Fibel (Bundle)
            [kat_nr] => 140
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-nfibel-bundle-330.jpg
            [linkname] => netzwerktechnik-fibel
            [klinkname] => bundle
        )

    [148] => Array
        (
            [a_nr] => 148
            [name] => Formelbuch (Bundle)
            [kat_nr] => 140
            [image] => https://www.elektronik-kompendium.de/res/bilder/buch-formelbuch-bundle-330.jpg
            [linkname] => formelbuch
            [klinkname] => bundle
        )

    [601] => Array
        (
            [a_nr] => 601
            [name] => Starter Edition
            [kat_nr] => 600
            [image] => https://www.elektronik-kompendium.de/res/bilder/set-starter-edition-komplett-300.jpg
            [linkname] => starter-edition
            [klinkname] => elektronik-set
        )

    [602] => Array
        (
            [a_nr] => 602
            [name] => Basic Edition
            [kat_nr] => 600
            [image] => https://www.elektronik-kompendium.de/res/bilder/set-basic-edition-330.jpg
            [linkname] => basic-edition
            [klinkname] => elektronik-set
        )

    [603] => Array
        (
            [a_nr] => 603
            [name] => Raspberry Pi Edition
            [kat_nr] => 600
            [image] => https://www.elektronik-kompendium.de/res/bilder/set-raspberry-pi-edition-330.jpg
            [linkname] => raspberry-pi-edition
            [klinkname] => elektronik-set
        )

    [604] => Array
        (
            [a_nr] => 604
            [name] => Pico Edition
            [kat_nr] => 600
            [image] => https://www.elektronik-kompendium.de/res/bilder/set-pico-edition-300.jpg
            [linkname] => pico-edition
            [klinkname] => elektronik-set
        )

    [201] => Array
        (
            [a_nr] => 201
            [name] => Picobello 1
            [kat_nr] => 200
            [image] => https://www.elektronik-kompendium.de/res/bilder/event-picobello1-500.jpg
            [linkname] => picobello-1
            [klinkname] => online-workshop
        )

    [202] => Array
        (
            [a_nr] => 202
            [name] => Picobello 2
            [kat_nr] => 200
            [image] => https://www.elektronik-kompendium.de/res/bilder/event-picobello2-500.jpg
            [linkname] => picobello-2
            [klinkname] => online-workshop
        )

)

Länder

Array
(
    [be] => Array
        (
            [l_id] => be
            [name] => Belgien
            [shipping] => 8.00
        )

    [ba] => Array
        (
            [l_id] => ba
            [name] => Bosnien
            [shipping] => 12.00
        )

    [bg] => Array
        (
            [l_id] => bg
            [name] => Bulgarien
            [shipping] => 10.00
        )

    [de] => Array
        (
            [l_id] => de
            [name] => Deutschland
            [shipping] => 3.50
        )

    [dk] => Array
        (
            [l_id] => dk
            [name] => Dänemark
            [shipping] => 8.00
        )

    [ee] => Array
        (
            [l_id] => ee
            [name] => Estland
            [shipping] => 12.00
        )

    [fr] => Array
        (
            [l_id] => fr
            [name] => Frankreich
            [shipping] => 8.00
        )

    [gr] => Array
        (
            [l_id] => gr
            [name] => Griechenland
            [shipping] => 12.00
        )

    [ie] => Array
        (
            [l_id] => ie
            [name] => Irland
            [shipping] => 12.00
        )

    [it] => Array
        (
            [l_id] => it
            [name] => Italien
            [shipping] => 11.00
        )

    [hr] => Array
        (
            [l_id] => hr
            [name] => Kroatien
            [shipping] => 12.00
        )

    [lv] => Array
        (
            [l_id] => lv
            [name] => Lettland
            [shipping] => 12.00
        )

    [li] => Array
        (
            [l_id] => li
            [name] => Liechtenstein
            [shipping] => 16.00
        )

    [lt] => Array
        (
            [l_id] => lt
            [name] => Litauen
            [shipping] => 12.00
        )

    [lu] => Array
        (
            [l_id] => lu
            [name] => Luxemburg
            [shipping] => 12.00
        )

    [nl] => Array
        (
            [l_id] => nl
            [name] => Niederlande
            [shipping] => 8.00
        )

    [no] => Array
        (
            [l_id] => no
            [name] => Norwegen
            [shipping] => 12.00
        )

    [pl] => Array
        (
            [l_id] => pl
            [name] => Polen
            [shipping] => 10.00
        )

    [pt] => Array
        (
            [l_id] => pt
            [name] => Portugal
            [shipping] => 12.00
        )

    [ro] => Array
        (
            [l_id] => ro
            [name] => Rumänien
            [shipping] => 12.00
        )

    [se] => Array
        (
            [l_id] => se
            [name] => Schweden
            [shipping] => 12.00
        )

    [ch] => Array
        (
            [l_id] => ch
            [name] => Schweiz
            [shipping] => 12.00
        )

    [cs] => Array
        (
            [l_id] => cs
            [name] => Serbien und Montenegro
            [shipping] => 12.00
        )

    [sk] => Array
        (
            [l_id] => sk
            [name] => Slowakei
            [shipping] => 12.00
        )

    [si] => Array
        (
            [l_id] => si
            [name] => Slowenien
            [shipping] => 11.00
        )

    [es] => Array
        (
            [l_id] => es
            [name] => Spanien
            [shipping] => 12.00
        )

    [cz] => Array
        (
            [l_id] => cz
            [name] => Tschechien
            [shipping] => 8.00
        )

    [hu] => Array
        (
            [l_id] => hu
            [name] => Ungarn
            [shipping] => 12.00
        )

    [at] => Array
        (
            [l_id] => at
            [name] => Österreich
            [shipping] => 8.00
        )

)

SERVER ENV

Array
(
    [REDIRECT_REDIRECT_UNIQUE_ID] => Ye9R@lgYQcZVFaj@KM9ilwAAAAI
    [REDIRECT_REDIRECT_DOCUMENT_ROOT] => /kunden/homepages/19/d222769350/htdocs/elektronik-kompendium
    [REDIRECT_REDIRECT_UI_SUEXEC_DEFAULT_CHROOT_ID] => 14
    [REDIRECT_REDIRECT_UI_SUEXEC_FSTATD_UNIXSOCKET] => /run/ui-fstatd.suexec.socket
    [REDIRECT_REDIRECT_UI_SUEXEC_STATISTICS_UNIXSOCKET] => /homepages/sclientMF/http.sock.bin
    [REDIRECT_REDIRECT_HTTPS] => on
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL_CPU] => 120
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL_MEM] => 1024
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL_PROCSOFT] => 30
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL_PROCHARD] => 80
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL_JIMDO] => 800
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL_CPU_JIMDO] => 60
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL_MEM_JIMDO] => 768
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL_PROCSOFT_JIMDO] => 24
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL_PROCHARD_JIMDO] => 24
    [REDIRECT_REDIRECT_DBENTRY_HOST] => elektronik-kompendium.de
    [REDIRECT_REDIRECT_DBENTRY_VALUE] => /kunden/homepages/19/d222769350/htdocs/elektronik-kompendium:d0000#CPU 120 #MEM 153600 #CGI 786762 #NPROC 80 #TAID 46952041 #LANG 0 #PARKING 1 #RSCLVL 999 #STAT 1 #CHROOT 7
    [REDIRECT_REDIRECT_DBENTRY_DOCROOT] => /kunden/homepages/19/d222769350/htdocs/elektronik-kompendium
    [REDIRECT_REDIRECT_DBENTRY_HASH] => d0000
    [REDIRECT_REDIRECT_DBENTRY__CPU] => 120
    [REDIRECT_REDIRECT_DBENTRY__MEM] => 153600
    [REDIRECT_REDIRECT_DBENTRY__CGI] => 786762
    [REDIRECT_REDIRECT_DBENTRY__NPROC] => 80
    [REDIRECT_REDIRECT_DBENTRY__TAID] => 46952041
    [REDIRECT_REDIRECT_DBENTRY__LANG] => 0
    [REDIRECT_REDIRECT_DBENTRY__PARKING] => 1
    [REDIRECT_REDIRECT_DBENTRY__RSCLVL] => 999
    [REDIRECT_REDIRECT_DBENTRY__STAT] => 1
    [REDIRECT_REDIRECT_DBENTRY__CHROOT] => 7
    [REDIRECT_REDIRECT_DBENTRY] => /kunden/homepages/19/d222769350/htdocs/elektronik-kompendium:d0000#CPU 120 #MEM 153600 #CGI 786762 #NPROC 80 #TAID 46952041 #LANG 0 #PARKING 1 #RSCLVL 999 #STAT 1 #CHROOT 7
    [REDIRECT_REDIRECT_STATUS] => 200
    [REDIRECT_UNIQUE_ID] => Ye9R@lgYQcZVFaj@KM9ilwAAAAI
    [REDIRECT_DOCUMENT_ROOT] => /kunden/homepages/19/d222769350/htdocs/elektronik-kompendium
    [REDIRECT_HTTPS] => on
    [REDIRECT_HANDLER] => x-mapp-php5.5
    [REDIRECT_STATUS] => 200
    [UNIQUE_ID] => Ye9R@lgYQcZVFaj@KM9ilwAAAAI
    [HTTPS] => on
    [HTTP_HOST] => www.elektronik-kompendium.de
    [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
    [HTTP_IF_MODIFIED_SINCE] => Sun, 28 Nov 2021 23:06:13 GMT
    [HTTP_ACCEPT_ENCODING] => br,gzip
    [PATH] => /bin:/usr/bin
    [SERVER_SIGNATURE] => 
    [SERVER_SOFTWARE] => Apache
    [SERVER_NAME] => elektronik-kompendium.de
    [SERVER_ADDR] => 172.29.8.207
    [SERVER_PORT] => 443
    [REMOTE_ADDR] => 52.203.18.65
    [DOCUMENT_ROOT] => /kunden/homepages/19/d222769350/htdocs/elektronik-kompendium
    [REQUEST_SCHEME] => https
    [CONTEXT_PREFIX] => /system-bin/
    [CONTEXT_DOCUMENT_ROOT] => /kunden/usr/lib/cgi-bin/
    [SERVER_ADMIN] => webmaster@elektronik-kompendium.de
    [SCRIPT_FILENAME] => /kunden/homepages/19/d222769350/htdocs/elektronik-kompendium/shop/index.php
    [REMOTE_PORT] => 21440
    [REDIRECT_URL] => /shop/index.php
    [REDIRECT_QUERY_STRING] => q=dev
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => q=dev
    [REQUEST_URI] => /shop/dev
    [SCRIPT_NAME] => /shop/index.php
    [STATUS] => 200
    [ORIG_PATH_INFO] => /shop/index.php
    [ORIG_PATH_TRANSLATED] => /kunden/homepages/19/d222769350/htdocs/elektronik-kompendium/shop/index.php
    [PHP_SELF] => /shop/index.php
    [REQUEST_TIME_FLOAT] => 1643074042.5677
    [REQUEST_TIME] => 1643074042
    [argv] => Array
        (
            [0] => q=dev
        )

    [argc] => 1
)