--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/test/test_mysql.php	Wed Aug 31 14:22:19 2011 +0200
@@ -0,0 +1,58 @@
+<?php
+
+/**
+ * @author B.Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2011
+ */
+
+include_once("inc/conf.inc.php");
+
+echo "<h3> Test Verbindung zu MySQL Server-DB 'fhiiqm' </h3>\n";
+$localvar = setlocale(LC_ALL, '0');
+//echo "lokale Varablen original: $localvar<br>\n";
+        
+$localvar = setlocale(LC_ALL, "de_DE.iso88591");
+date_default_timezone_set("Europe/Berlin");
+//echo "lokale Varablen: $localvar<br>\n";
+echo "before connection DB: ". Date("d.m.Y H:i:s")."<br>\n";
+
+//$conn=mssql_connect('I2005',$config["user"],$config["passwort"]);
+$conn=mysql_connect($config["server"],$config["user"],$config["passwort"]) or die("Keine Verbindung zum SQL Server");
+
+//$conn=mssql_connect('mssql',$config["user"],$config["passwort"]);
+echo   $conn.";  user=".$config["user"].", db=" .$config["dbname"] . "<--<br><br>\n";
+//echo mssql_get_last_message() . "<br>";
+
+$db=mysql_select_db($config["dbname"],$conn); // or die("Keine Verbindung zur DB fhiiqm");
+echo "after connection DB: ". Date("d.m.Y H:i:s")."<br>\n";
+if (mysql_errno())
+	echo "error after connect und db select: " . mysql_errno() . ": " . mysql_error() . "<br>\n";
+
+$query="SELECT produkt_ID, prod_name FROM Produkt order by prod_name 
+		WHERE prod_name like 'y%'";
+if ($conn && $db)
+{
+        $result=mysql_query($query,$conn);
+            echo "sql = $query<br><br>\n";
+		
+		if ($result && mysql_num_rows($result))
+		{
+			printf ("<p>Es wurden %d Datensaetze gefunden.</p>", mysql_num_rows($result));
+			$bg1 = "#D7E7F5";
+			$bg2 = "#A3C7E7";
+			echo "<p><b>Tabelle Produkt</b></p>\n";
+			echo "<table cellpadding='2'>";
+			echo "<tr bgcolor='#E6E7EA'><th align='left'>ID</th><th align='left'>Produkt</th></tr>\n";
+			while ($row = mysql_fetch_row($result)) 
+			{
+				if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
+					printf("<tr bgcolor='" . $bg . "'><td align='right'>%d </td><td> &nbsp;%s</td></tr>\n",$row[0], $row[1]);
+			};
+			echo "</table>";
+		}
+		else
+			echo "<p>Leider wurde keine Datensaetze gefunden!</p>\n";
+}
+mysql_close($conn);
+
+?>