hi..
kann mir jemand sagen, warum es mir keine Ausgabe anzeigt?
grüße
kann mir jemand sagen, warum es mir keine Ausgabe anzeigt?
grüße
PHP-Code:
<?php
// Datenbank Definition
$db_MenuTitle[0] = "Eintrag 1";
$db_Hostname[0] = "localhost";
$db_UserName[0] = "root";
$db_Password[0] = "**";
$db_Database[0] = "bla";
$db_Table[0] = "test";
$db_MenuTitle[1] = "Eintrag 2";
$db_Hostname[1] = "localhost";
$db_UserName[1] = "root";
$db_Password[1] = "**";
$db_Database[1] = "bla";
$db_Table[1] = "test1";
if (isset ($select_db)) {
// Connect zur Datenbank
mysql_connect($db_Hostname[$select_db], $db_UserName[$select_db], $db_Password[$select_db]) || die("Can't Connect to Database: ".mysql_error());
mysql_select_db($db_Database[$select_db]);
// SQL Befehl
$sql = "SELECT * FROM test1".$db_Table[$select_db];
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
echo "name: ".$row[name]."<br>nachname: ".$row[nachname]."<br><br>";
}
// MySQL-Statements
if (mysql_query ($sql)) {
$message = "erfolgreich";
}
else {
$message = "fehlgeschlagen. Grund: ". mysql_error ();
}
}
// Generierung des DropDown-Menues
function generate_dropdown () {
global $db_MenuTitle, $db_Hostname, $db_UserName, $db_Password, $db_Table;
if (is_array ($db_MenuTitle)) {
reset ($db_MenuTitle);
while (list ($key, $val) = each ($db_MenuTitle)) {
echo "<option value=\"".$key."\">".$val."</option>";
}
}
}
?>
<html>
<head>
<title>test</title>
</head>
<body>
<form action="<?php echo $PHP_SELF; ?>" method="POST">
<table border="0" cellspacing="0" cellpadding="5" bgcolor="#C0C0C0" width="50%">
<tr>
<th>test</th>
<th> </th>
</tr>
<tr valign="bottom">
<td>
<select name="select_db" size="<?php echo count ($db_MenuTitle); ?>">
<?php generate_dropdown (); ?>
</select>
</td>
<td>
<input type="Submit" name="submit" value="Klick">
</td>
</tr>
</table>
</form>
<p><?php echo $message; ?></p>
</body>
</html>
Kommentar