<?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();
	}
?>