<?php

//header('content-type: text/html; charset=iso-8859-1'); // Standard, nicht notwendig

//header('content-type: text/html; charset=utf-8');

// Beispiel mysqli-Klasse 'dbconnection' verwenden

//include_once($_SERVER['DOCUMENT_ROOT']."/fhiiqm/inc/dbconnect.inc.php");

//echo $_SERVER['DOCUMENT_ROOT'] ."<br><br>\n";

include_once("inc/dbconnect.inc.php");

//setlocale (LC_ALL, 'de_DE');

// nur erfolgreich, wenn Sortierung der Spalte = latin1_general_ci by "LIKE 'y%'"!	

	echo "before connection DB: ". Date("d.m.Y H:i:s")."<br><br>\n";

	$dbc = new dbconnection();

//	print "Error = <". $dbc->error ."><br>\n";

//	printf ("Server = %s, DB = %s, User = %s<br><br>\n", $config["server"], $config["dbname"],$config["user"]);

//    echo $dbc->getclient_info()."<br>\n";

//    echo $dbc->gethost_info()."<br>\n";

	if (!$dbc->error)

	{

//		$dbc -> setcharset("iso-8859-1"); //latin1_general_ci

//		printf("<br>Current character set: %s<br>\n",$dbc -> _connectionid ->character_set_name()); //Standard: latin1

//    	$like = $dbc->escapestring('y');

//        echo system("locale"). "<br><br>\n";

// COLLATE muss unbedingt fuer die Sortierreihenfolge angegeben werden! (19.05.2011)

        $sql = "SELECT p.`produkt_ID` , p.`prod_name` , g.prod_group_name, p.`ag_ID` , p.`imp_ID` , p.`conn_ID` , p.`Bemerkung`

    			FROM Produkt p

    			INNER JOIN Produkt_Gruppe g ON p.`prod_group_ID` = g.`prod_group_ID`

    			WHERE prod_name LIKE '%' COLLATE latin1_general_ci

    			ORDER BY prod_name "; ;

    	echo "sql = $sql<br><br>\n";

		if ($result = $dbc->queryObjectArray($sql))

		{

			printf ("<p>Es wurden %s Saetze gefunden.</p>", $dbc->numrows($sql));

			$bg1 = "#F8F8F8";

			$bg2 = "#DEDFE1";

			$bg = "#FFFFFF";

			echo "<p><b>Tabelle Produkt</b></p>\n";

			echo "<table cellpadding='2'>";

			echo "<tr bgcolor='#B7CBFA'><th align='left'>ID</th><th align='left'>Produkt</th>

				<th align='left'>Prod-Gruppe</th><th align='left'>ag-ID</th><th align='left'>imp-ID</th><th align='left'>conn-ID</th><th align='left'>Bemerkung</th></tr>\n";

			foreach($result as $row)

			{

				if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;

				print "<tr bgcolor='" . $bg . "'><td>$row->produkt_ID</td><td>$row->prod_name</td><td>$row->prod_group_name</td><td>$row->ag_ID</td><td>$row->imp_ID</td><td>$row->conn_ID</td><td>$row->Bemerkung</td></tr>";

			}

				echo "</table>\n";

//			$dbc->close();

		}

		else

			echo "leider kein Ergebnis!<br>\n";

		if ($result = $dbc -> querySingleItem("SELECT COUNT(*) FROM produkt"))

		{

			echo "<p>Tabelle 'produkt' enthaelt $result Eintraege</p>\n";

		}

		$dbc->close();

	}

?>