1 <?php

     2 

     3 /**

     4  * @author B.Schwarzer, Fritz-Haber-Institut

     5  * @copyright 05/2011

     6  */

     7 

     8 include_once("inc/conf.inc.php");

     9 

    10 echo "<h3> Test Verbindung zu MySQL Server-DB 'fhiiqm' </h3>\n";

    11 $localvar = setlocale(LC_ALL, '0');

    12 //echo "lokale Varablen original: $localvar<br>\n";

    13         

    14 $localvar = setlocale(LC_ALL, "de_DE.iso88591");

    15 date_default_timezone_set("Europe/Berlin");

    16 //echo "lokale Varablen: $localvar<br>\n";

    17 echo "before connection DB: ". Date("d.m.Y H:i:s")."<br>\n";

    18 

    19 //$conn=mssql_connect('I2005',$config["user"],$config["passwort"]);

    20 $conn=mysql_connect($config["server"],$config["user"],$config["passwort"]) or die("Keine Verbindung zum SQL Server");

    21 

    22 //$conn=mssql_connect('mssql',$config["user"],$config["passwort"]);

    23 echo   $conn.";  user=".$config["user"].", db=" .$config["dbname"] . "<--<br><br>\n";

    24 //echo mssql_get_last_message() . "<br>";

    25 

    26 $db=mysql_select_db($config["dbname"],$conn); // or die("Keine Verbindung zur DB fhiiqm");

    27 echo "after connection DB: ". Date("d.m.Y H:i:s")."<br>\n";

    28 if (mysql_errno())

    29 	echo "error after connect und db select: " . mysql_errno() . ": " . mysql_error() . "<br>\n";

    30 

    31 $query="SELECT produkt_ID, prod_name FROM Produkt order by prod_name 

    32 		WHERE prod_name like 'y%'";

    33 if ($conn && $db)

    34 {

    35         $result=mysql_query($query,$conn);

    36             echo "sql = $query<br><br>\n";

    37 		

    38 		if ($result && mysql_num_rows($result))

    39 		{

    40 			printf ("<p>Es wurden %d Datensaetze gefunden.</p>", mysql_num_rows($result));

    41 			$bg1 = "#D7E7F5";

    42 			$bg2 = "#A3C7E7";

    43 			echo "<p><b>Tabelle Produkt</b></p>\n";

    44 			echo "<table cellpadding='2'>";

    45 			echo "<tr bgcolor='#E6E7EA'><th align='left'>ID</th><th align='left'>Produkt</th></tr>\n";

    46 			while ($row = mysql_fetch_row($result)) 

    47 			{

    48 				if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;

    49 					printf("<tr bgcolor='" . $bg . "'><td align='right'>%d </td><td> &nbsp;%s</td></tr>\n",$row[0], $row[1]);

    50 			};

    51 			echo "</table>";

    52 		}

    53 		else

    54 			echo "<p>Leider wurde keine Datensaetze gefunden!</p>\n";

    55 }

    56 mysql_close($conn);

    57 

    58 ?>