--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/test/sel_produkt.php	Wed Aug 31 14:22:19 2011 +0200
@@ -0,0 +1,61 @@
+<?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();
+	}
+?>
\ No newline at end of file