Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <meta http-equiv="content-type" content="text/html; charset=utf-8">
- <title>Term�kek</title>
- <style>
- body { margin: 4px; padding:0px; }
- form { background-color: #f0f0ff; border: 1px dotted #c0c0f0; padding: 8px; margin: 0px; }
- body, form, input, select { font-family: Verdana; font-size: 8pt; }
- select { background-color: #e0e0ff; }
- input.filtertext { background-color: #c0c0ff; color: #404040; width: 80px; }
- /* ---------- */
- table { border: 1px dotted #c0d080; margin-top: 4px; width: 100%; font-family: Verdana; font-size: 10pt; }
- tr.head { background-color: #c0d080; }
- tr.row0 { background-color: #e0f0c0; }
- tr.row1 { background-color: #f0ffc0; }
- th { padding-left: 8px; padding-right: 8px; }
- td { padding-left: 4px; padding-right: 4px; }
- td.center { text-align: center; }
- td.right { text-align: right; padding-right: 8px; }
- </style>
- <script>
- function setPage(page) {
- document.forms['navbar'].page.value=page;
- document.forms['navbar'].submit();
- }
- </script>
- </head>
- <body>
- <form name="navbar" method="get">
- <select name="mode" onchange="document.forms['navbar'].submit()"><option value="0" selected>egyszerű lista</option><option value="1">csoportos�tott lista</option></select>
- Szűr�s: <input name="filter" class="filtertext" value=""> <input type="submit" value="[frissit]">
- Lista hossza: <select name="pgLen" onchange="document.forms['navbar'].submit()"><option value="10">10</option><option value="50">50</option><option value="100" selected>100</option><option value="500">500</option></select>
- Lapoz�s: <<
- <
- 1/10. oldal
- <a href="#" onclick="setPage('1')">></a>
- <a href="#" onclick="setPage('9')">>></a>
- <input name="page" type="hidden" class="filtertext" value="">
- </form>
- <?php
- //
- //<table cellspacing="1" cellpadding="1" border="0"><tr class="head"><th>Termꬫ��th><th>Termꫠneve</th><th>Mennyisꧼ/th><th>Elad⴩ Ⲽ/th></tr><tr class="row0"><td>Bor, pezsg��d><td>Aranykancs󠠰,75 l</td><td class="center">1 db</td><td class="right">343 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Aranykancs󠶶r��0,75 l</td><td class="center">1 db</td><td class="right">357 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Balatonbogl⳩ kꬦrankos 0,75 l</td><td class="center">1 db</td><td class="right">588 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Balatonbogl⳩ merlot 0,75 l</td><td class="center">1 db</td><td class="right">526 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>BB ꥥs pezsg��75 l</td><td class="center">1 db</td><td class="right">907 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>BB fꭩdes pezsg��75 l</td><td class="center">1 db</td><td class="right">907 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>BB fꭳzⳡz pezsg��75 l</td><td class="center">1 db</td><td class="right">907 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Dtk zweigelt 0,75 l</td><td class="center">1 db</td><td class="right">302 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Egervin cabernet savignon 0,75 l</td><td class="center">1 db</td><td class="right">749 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Egervin debr��uvꥠ0,75 l</td><td class="center">1 db</td><td class="right">638 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Egervin egri bikav겠0,75 l</td><td class="center">1 db</td><td class="right">798 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Eskulit󠳯ml󩠯laszrizl. 07 l</td><td class="center">1 db</td><td class="right">952 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Eximius v�� portug⬠ 0,75 l</td><td class="center">1 db</td><td class="right">805 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Finca losaltos spanyol 0,75 l</td><td class="center">1 db</td><td class="right">861 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Francia tokaji hⳳlevel󠠰,75 l</td><td class="center">1 db</td><td class="right">987 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>J.p. chenet fracia szⳡz 0,75 l</td><td class="center">1 db</td><td class="right">1 008 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Kiskun-vin alf�� muskot⭹ 075 l</td><td class="center">1 db</td><td class="right">406 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Kiskun-vin alf�� olaszrizl. 0,75 l</td><td class="center">1 db</td><td class="right">391 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Kiskun-vin dunam. Zweigelt 0,75 l</td><td class="center">1 db</td><td class="right">623 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Kiskunvin dunamell.kꬦrankos 0,75 l</td><td class="center">1 db</td><td class="right">301 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Kov⤳ cabernet savignon 0,75 l</td><td class="center">1 db</td><td class="right">1 217 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Kov⤳ merlot 0,75 l</td><td class="center">1 db</td><td class="right">791 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Kov⤳ p.vill⯹i ros頠0,75 l</td><td class="center">1 db</td><td class="right">784 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Kov⤳ pince juhfark 0,75 l</td><td class="center">1 db</td><td class="right">693 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Kov⤳ pinot noire 0,75 l</td><td class="center">1 db</td><td class="right">791 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Kov⤳ portugieser 0,75 l</td><td class="center">1 db</td><td class="right">791 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Kov⤳ vill⯹i cuvꥠ 0,75 l</td><td class="center">1 db</td><td class="right">791 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K��k pezsg��mⳠ0,75 l</td><td class="center">1 db</td><td class="right">402 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>K��k pezsg��rackos 0,75 l</td><td class="center">1 db</td><td class="right">402 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K��kklub pezsg��,75 l</td><td class="center">1 db</td><td class="right">203 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>K�� alf�� muskot⭹ cuvꥠ0,75 l</td><td class="center">1 db</td><td class="right">405 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K�� alf�� olasz 0,75 l</td><td class="center">1 db</td><td class="right">301 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>K�� cserszegi f󳺥res 0,75 l</td><td class="center">1 db</td><td class="right">371 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K�� desszert bor 0,75 l</td><td class="center">1 db</td><td class="right">1 575 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>K�� dtk chardonnay 0,75 l</td><td class="center">1 db</td><td class="right">409 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K�� dtk portuguiser 0,75 l</td><td class="center">1 db</td><td class="right">491 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>K�� dunamellꬩ kꬦrankos 0,75 l </td><td class="center">1 db</td><td class="right">441 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K�� dunamellꬩ zweigelt 0,75 l </td><td class="center">1 db</td><td class="right">454 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>K�� egri cuvꥠ 0,75 l</td><td class="center">1 db</td><td class="right">784 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K�� egri kꬦrankos 0,75 l</td><td class="center">1 db</td><td class="right">819 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>K�� kꬦrankos roz頰,75 l</td><td class="center">1 db</td><td class="right">434 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K�� nagyrꥥi cabernet 0,75 l</td><td class="center">1 db</td><td class="right">882 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>K�� nagyrꥥi chardonnay 0,75 l</td><td class="center">1 db</td><td class="right">595 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K�� nagyrꥥi ros頠0,75 l</td><td class="center">1 db</td><td class="right">868 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>K�� pince nagyrꥥi ros頠0,75 l</td><td class="center">1 db</td><td class="right">861 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>K�� szekszⳤi kꬦrankos 0,75 l</td><td class="center">1 db</td><td class="right">847 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Kuns⨩ boszork⯹ 0,75 l</td><td class="center">1 db</td><td class="right">554 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Kuns⨩ cabernet franc 0,75 l</td><td class="center">1 db</td><td class="right">469 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Kuns⨩ kꬦrankos 0,75 l </td><td class="center">1 db</td><td class="right">455 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Kuns⨩ kꬦrankos ros頠0,75 l</td><td class="center">1 db</td><td class="right">462 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Kuns⨩ muskat ottonel 0,75 l</td><td class="center">1 db</td><td class="right">469 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Kutevin bestia 0,5 l</td><td class="center">1 db</td><td class="right">567 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Vino rosso merlot 0,75 l</td><td class="center">1 db</td><td class="right">442 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>V��sꨩ kꬦrankos 0,75 l</td><td class="center">1 db</td><td class="right">469 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>V��sꨶin csemege v�� 0,75 l</td><td class="center">1 db</td><td class="right">525 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Weinhaus dank󠠰,75 l</td><td class="center">1 db</td><td class="right">525 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Weinhaus merlot pinot-noire 0,75 l</td><td class="center">1 db</td><td class="right">525 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Wunderlich olaszrizling 0,75 l</td><td class="center">1 db</td><td class="right">1 442 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Wunderlich portugieser 0,75 l</td><td class="center">1 db</td><td class="right">1 442 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Wunderlich roz頰,75 l</td><td class="center">1 db</td><td class="right">1 442 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Zala kincse 0,75 l</td><td class="center">1 db</td><td class="right">221 Ft</td></tr><tr class="row1"><td>Bor, pezsg��d><td>Zemplꯩ furmint fꭩd.feh. 2 l</td><td class="center">1 db</td><td class="right">839 Ft</td></tr><tr class="row0"><td>Bor, pezsg��d><td>Zsup顮agyrꥥ m⵲aaljai muscat ottonel 0,75 l</td><td class="center">1 db</td><td class="right">1 711 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Artur krꬥrmix 100 g</td><td class="center">1 db</td><td class="right">142 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Bake rolls 80 g</td><td class="center">1 db</td><td class="right">155 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Cheetos hot-dog 55 g</td><td class="center">1 db</td><td class="right">138 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Chio burgonya szirom 45 g</td><td class="center">1 db</td><td class="right">124 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Chio chips extra 90 g</td><td class="center">1 db</td><td class="right">254 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Chio chips extra paradicsom 90 g</td><td class="center">1 db</td><td class="right">254 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Chio chips hagymⳠtejf�� 90 g</td><td class="center">1 db</td><td class="right">254 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Coop puffasztott b򺡠100 g</td><td class="center">1 db</td><td class="right">81 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Coop puffasztott rizs 100 g</td><td class="center">1 db</td><td class="right">81 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Coop s󳠰⭣ika 50 g</td><td class="center">1 db</td><td class="right">34 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Coop s󳠰opcorn 100 g</td><td class="center">1 db</td><td class="right">72 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Coop t��g 100 g</td><td class="center">1 db</td><td class="right">103 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Coop vajas popcorn 100 g</td><td class="center">1 db</td><td class="right">72 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Csipet s󳠰erec 100 g</td><td class="center">1 db</td><td class="right">88 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Dexi extrud⭴ keny겠125 g</td><td class="center">1 db</td><td class="right">197 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>ʤesvil⧠krꬥr 250 g</td><td class="center">1 db</td><td class="right">236 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>ʤesvil⧠s󳠰⭣ika 270 g</td><td class="center">1 db</td><td class="right">230 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>ʤesvil⧠s󳠰erec 270 g</td><td class="center">1 db</td><td class="right">230 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>ʤesvil⧠s󳭩x 250 g</td><td class="center">1 db</td><td class="right">236 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>ʤesvil⧠s󳭩x 350 g</td><td class="center">1 db</td><td class="right">473 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Ham-let puffasztott rizs 100 g</td><td class="center">1 db</td><td class="right">161 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Jⴺs⨩ sajtos tall겠 85 g</td><td class="center">1 db</td><td class="right">162 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>L⯧os s��pizzⳠtall겠 100 g</td><td class="center">1 db</td><td class="right">149 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Lays appetite 90 g</td><td class="center">1 db</td><td class="right">215 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Lays chips 90 g</td><td class="center">1 db</td><td class="right">236 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Maxi stic 170 g</td><td class="center">1 db</td><td class="right">122 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Mogyi amerikai mogyor󠠸0 g</td><td class="center">1 db</td><td class="right">385 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Mogyi csemegemix 100 g</td><td class="center">1 db</td><td class="right">213 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Mogyi di⬣semege 100 g</td><td class="center">1 db</td><td class="right">122 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Mogyi kesudi󠠸0 g</td><td class="center">1 db</td><td class="right">344 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Mogyi mandulabꬠ 80 g</td><td class="center">1 db</td><td class="right">344 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Mogyi mexicorn barbecue 70 g</td><td class="center">1 db</td><td class="right">97 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Mogyi mexicorn s󳠠70 g</td><td class="center">1 db</td><td class="right">97 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Mogyi mikropopcorn sajtos 100 g</td><td class="center">1 db</td><td class="right">107 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Mogyi mikropopcorn s󳠠100 g</td><td class="center">1 db</td><td class="right">107 Ft</td></tr><tr class="row0"><td>Csoki, csemege</td><td>Traccsparty burg.szirom 50 g</td><td class="center">1 db</td><td class="right">151 Ft</td></tr><tr class="row1"><td>Csoki, csemege</td><td>Tuti snack f꭫.burgsz. 90 g</td><td class="center">1 db</td><td class="right">162 Ft</td></tr></table><div style="text-align: right;">K괺tte: S��K⳯ly (bodu2v)</div>
- $user ="ha85z1";
- $pass = "19860518";
- $host = "web-okt.duf.hu";
- $dbh = mysql_connect($host,$user,$pass);
- $szures = 1;
- //page=0
- if (isset($_GET['page']))
- {
- $PAGE = $_GET["page"];
- }
- else
- {
- $PAGE = 0;
- }
- if (isset($_GET['mode']))
- {
- $listtype = $_GET["mode"];
- }
- else
- {
- $listtype = 0;
- }
- if (isset($_GET['pgLen']))
- {
- $PGLEN = $_GET["pgLen"];
- }
- else
- {
- $PGLEN = 100;
- }
- if (isset($_GET['filter']))
- {
- $keresett = $_GET["filter"];
- }
- else
- {
- $keresett = '%';
- }
- if (!$dbh) {
- die('Kapcsol�d�si hiba: ' . mysql_error()); }
- mysql_select_db("ha85z1");
- $kezd = 0;
- $limit = 50;
- //$getGroups = "SELECT * From product_group;
- //$getG = mysql_query($getGroups);
- //$GROUPS = array ( 'B'=>'Bor, pezsgő','CS'=>'Csoki, csemege','E'=>'Elem','EDES'=>'�dess�g','F'=>'Fagyi','FEL'=>'Felv�gott','FU'=>'Fűszer',=>'G'=>'G�ngy�leg','K'=>'K�v�','KO'=>'Konzerv','M'=>'Mirelit',('N','Neh�z�ru'),('P'=>'P�k�ru'),('POGI','Pog�csa'),('S','S�r'),('SAV','Savany�s�g'),('SEGED','Seg�danyag'),('SZ','Szeszesital'),('T','Tejterm�k'),('TEJ','Tej'),('U','�js�g'),('UDITO','�d�tő'),('V','Vegyi�ru'),('KU','�llateledel');
- $honnan = $PAGE*$PGLEN;
- if ($szures == 0)
- {
- $sql = "SELECT * FROM product limit $honnan,$PGLEN";//left join product_group using (pgr_id)";
- }
- else
- {
- $sql = "SELECT * FROM product where prod_name like '%$keresett%' limit $honnan,$PGLEN";
- }
- $query = mysql_query($sql);
- echo "<table cellspacing=1 cellpadding=1 border=0> <tr class=head > <th>Term�kk�r</th> <th>Term�k neve</th> <th>Mennyis�g </th><th>Elad�si �r </th> </tr>";
- while ($row = mysql_fetch_row($query))
- {
- //
- if ($listtype == 0){
- echo "<tr class=row0> <td> $row[3] </td> <td> $row[1]</td> <td class=center>1 $row[2]</td> <td class=right> $row[5]</td> </tr>";
- }
- else
- {
- if ($type == $row[3])
- {
- echo "<tr class=row0> <td> </td> <td> $row[1]</td> <td class=center>1 $row[2]</td> <td class=right> $row[5] FT</td> </tr>";
- }
- else
- {
- echo "<tr class=head> <td colspan = 4> $row[3] </td> </tr>";
- $type = $row[3];
- }
- }
- }
- echo "</tabel>";
- //$r = mysql_fetch_assoc($query);
- //echo " ----- ".$r['COLUMNS'];
- mysql_close($dbh);
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
