Zauberer Papion Hünhan

Karaoke Musik

 


Titel:"; foreach ($alphabet as $buchstabe){ $lnk=" [$buchstabe]     "; echo $lnk . ' '; } echo "

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 "
"; askDatabase($bntsend,$typeA,$letter); 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 ""; echo "
ARTISTSONG
"; while ($row = $result->fetch_assoc()) { echo ""; $Artist=$row["ARTIST"]; $Song=$row["SONG"]; $MFcode=$row["MFCODE"]; $DJsend=$Song." von ".$Artist."(".$MFcode.")"; //Spalte1 echo ""; //Spalte2 echo ""; echo ""; } echo "
InterpretTitel
"; //print ""; print ""; echo ""; print ""; 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

"; } function sendMail($to, $subject, $msg, $headers){ mail($to, $subject, $msg, $headers); } ?>