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

?>