- <?php
- $mysqlhost = "1.1.1.1"; // MySQL-Host angeben
- $mysqluser = "root"; // MySQL-User angeben
- $mysqlpwd = "rootpass"; // Passwort angeben
- $tabelle = "pmlog"; //tabelle angeben
- $spalte = "psc_betrag"; //spalte angeben
- $mysqldb="offline_pn"; // Gewuenschte Datenbank angeben
- $connection=mysql_connect($mysqlhost, $mysqluser, $mysqlpwd);
- $sender = mysql_real_escape_string($_GET["se"]);
- $empf = mysql_real_escape_string($_GET["empf"]);
- $txt = mysql_real_escape_string($_GET["txt"]);
- $name = mysql_real_escape_string($_GET["name"]);
- if(isset($_GET["methode"]) && $_GET["methode"] == "s"){
- $abfrage = "SELECT * FROM ".$mysqldb.".pmlog WHERE pmlog.read='0' and pmlog.empf ='".$name."';";
- $eQuery = mysql_query($abfrage,$connection);
- while($anzahl = mysql_fetch_object($eQuery)){
- echo "".$anzahl->sender."";
- echo "//";
- echo "".$anzahl->msg."";
- echo "</br>";}
- }
- if(isset($_GET["methode"]) && $_GET["methode"] == "a"){
- $eintrag = "INSERT INTO ".$mysqldb.".pmlog (empf, sender, msg, read) VALUES ('".$empf."', '".$sender."', '".$txt."', '0')";
- $querry = mysql_query($eintrag,$connection);
- if(mysql_num_rows($querry) >= 1){
- echo "Done";
- }
- else{
- echo "fail";
- }
- }
- ?>
offlinepm.php