"; echo "Suche nach BWV $bwv ergab folgendes Ergebnis:"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $dbcon=mysqli_connect("mysql.goneo.de",$datenbank,$db_password, $datenbank); $result = mysqli_query($dbcon, "SELECT * FROM BWV WHERE BWV = $bwv"); while($row=mysqli_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } mysqli_close; echo""; echo"

ID	BWV	CD	TITEL	JAHR	ANLASS
",utf8_encode($row["DATA"]),"	",utf8_encode($row["BWV"]),"	",utf8_encode($row["CD"]),"	",utf8_encode($row["TITEL"]),"	",utf8_encode($row["JAHR"]),"	",utf8_encode($row["ANLASS"]),"

"; echo""; } if(isset($_POST['_button_2']) ) { $datenbank="68250m55033_10"; $db_password="2303kik11"; $cd = $_POST["text_CD"]; echo ""; echo "Suche nach CD $cd ergab folgendes Ergebnis:"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $dbcon=mysqli_connect("mysql.goneo.de",$datenbank,$db_password, $datenbank); $result = mysqli_query($dbcon, "SELECT * FROM BWV WHERE CD = $cd"); while($row=mysqli_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } mysqli_close; echo""; echo"

ID	BWV	CD	TITEL	JAHR	ANLASS
",utf8_encode($row["DATA"]),"	",utf8_encode($row["BWV"]),"	",utf8_encode($row["CD"]),"	",utf8_encode($row["TITEL"]),"	",utf8_encode($row["JAHR"]),"	",utf8_encode($row["ANLASS"]),"

"; echo""; } if(isset($_POST['_button_3']) ) { $datenbank="68250m55033_10"; $db_password="2303kik11"; $st = $_POST["text_Titel"]; echo ""; echo "Folgende BWV enthalten den Suchtext '%$st%':"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $dbcon=mysqli_connect("mysql.goneo.de",$datenbank,$db_password, $datenbank); $result = mysqli_query($dbcon, "SELECT * FROM BWV WHERE LOWER(TITEL) LIKE LOWER('%$st%') "); while($row=mysqli_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } mysqli_close; echo""; echo"

ID	BWV	CD	TITEL	JAHR	ANLASS
",utf8_encode($row["DATA"]),"	",utf8_encode($row["BWV"]),"	",utf8_encode($row["CD"]),"	",utf8_encode($row["TITEL"]),"	",utf8_encode($row["JAHR"]),"	",utf8_encode($row["ANLASS"]),"

"; echo""; } ?>