Interpret:";
foreach ($alphabet as $buchstabe){
$lnk=" [$buchstabe] ";
echo $lnk . ' ';
}
echo " ";
$bntsend=$_POST['bntsend'];
$bntsendmail=$_POST['bntsendmail'];
$myname=$_POST['myname'];
$sendmail=$_POST['send1'];
$typeA=$_GET['typeA'];
$letter=$_GET['letter'];
$mname="-";
if ($myname){
//foreach($myname AS $mynameT){
// if($mynameT){$mname=$mynameT;}
$mailtext=$myname." wünscht sich ".$bntsendmail;
sendMail("Papion@web.de","Musikwunsch",$mailtext,"");
$bntsend="";
$bntsendmail="";
//}
}
if ($bntsend){ print "Hallo, du hast den Titel $bntsend ausgewählt. Trage deinen Namen ein und sende den Titel dem DJ um beim Karoke teilzunehmen. ";}
//if (!$bntsend){
print "";
//}
echo " ++++";
function askDatabase($MFCODE,$typeA,$letter) {
require('db.inc.php5');
//Verbindung zur Datenbank
$mysqli = new mysqli($Servername, $Serveruser, $Serverkey, $Serverdb);
/* check connection */
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
/* check if server is alive */
if ($mysqli->ping()) {
printf ("+ \n");
if ($MFCODE){
//$searchfor=$bntsend;
$sqlquery ="SELECT * FROM musik where MFCODE = '$MFCODE' LIMIT 0 , 50";
echo "
";
print " ";
//$sqlquery ="SELECT * FROM tabtest";
}
else{
$searchfor = $_POST['searchfor'];
if($searchfor){
echo "Deine Suche nach $searchfor ";
$sqlquery ="SELECT * FROM musik where ARTIST like '%$searchfor%' or SONG like '%$searchfor%' or MFCODE like '%$searchfor%' LIMIT 0 , 2000";
}
else{
if ($typeA){
if ($typeA==1){
$sqlquery ="SELECT * FROM musik where Song like '$letter%' order by Song LIMIT 0 , 4000";
}
if ($typeA==2){
$sqlquery ="SELECT * FROM musik where ARTIST like '$letter%' order by ARTIST LIMIT 0 , 4000";
}
}
else {
$sqlquery ="SELECT * FROM musik LIMIT 0 , 2000";
}
}
}
/* Select queries return a resultset */
if ($result = $mysqli->query($sqlquery)) {
if($result->num_rows==2000){
printf("
Die Suche wurde auf %d Titel begrenzt.
\n", $result->num_rows);
}
else{
printf("
Es wurden %d Titel gefunden.
\n", $result->num_rows);
}
showTime();
//echo "
ARTIST
SONG
";
echo "
Interpret
Titel
";
while ($row = $result->fetch_assoc()) {
echo "
";
$Artist=$row["ARTIST"];
$Song=$row["SONG"];
$MFcode=$row["MFCODE"];
$DJsend=$Song." von ".$Artist."(".$MFcode.")";
//Spalte1
echo "
";
//print "";
print "";
echo "
";
//Spalte2
echo "
";
print "";
echo "
";
echo "
";
}
echo "
";
/* free result set */
$result->close();
}
}
else {
printf ("Error: %s\n", $mysqli->error);
}
/* close connection */
$mysqli->close();
}
function showTime(){
echo "Letzte Suche vom ";
date_default_timezone_set("Europe/Berlin");
$timestamp = time();
$datum = date("d.m.Y",$timestamp);
$uhrzeit = date("H:i",$timestamp);
echo $datum," - ",$uhrzeit," Uhr