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

?>