Advertisement
axi92

db.php

Oct 20th, 2011
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.10 KB | None | 0 0
  1. <head>
  2.     <title>www.axi92.at - Classic Filtersuche</title>
  3.  
  4.     <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
  5.     <meta name="description" content="" />
  6.     <meta name="author" content="axi92" />
  7.     <meta name="keywords" content="axi92" />
  8.     <link href="filter.css" type="text/css" rel="stylesheet" />
  9.  
  10. </head>
  11. <body id="body">
  12. <?php
  13. $db_verbindung = mysql_connect("0.0.0.0", "ID", "PASSWORD") or die("Verbindung fehlgeschlagen, bitte kontaktieren sie den Webmaster!");
  14. mysql_select_db("MCZallDB") or die("Die gew&uuml;nschte Datenbank konnte nicht gefunden werden. Bitte kontaktieren sie den Webmaster!");
  15. $operator = $_GET['operator'];
  16. $filter = $_GET['filter'];
  17. $wert = $_GET['wert'];
  18. $submit = $_GET['submit'];
  19. $leer = 0;
  20.  
  21. /*echo '<iframe height="110" width="100%" frameborder="no" scrolling="no" src="http://84.113.231.167/filter.php">
  22. <p>Your browser does not support iframes.<br />Ihr Browser unterst&uuml;tzt keine iframes.</p>
  23. </iframe>';*/
  24.  
  25. if ($submit == 'Absenden')
  26. {
  27.     echo '<div align="center" id="suche">';
  28.     echo '<a id="back_link" href="filter.php"><img src="http://84.113.231.167/back.png" alt="zur&uuml;ck" /></a><br />';
  29.     if (empty($wert))
  30.         {
  31.             echo '<div id="schrift">Es wurde kein Suchwert festgelegt!</div>';
  32.             $leer = 1;
  33.         }
  34.     else
  35.         {
  36.             $leer = 0;
  37.         }
  38.  
  39.  
  40.     if (0 == $leer)
  41.     {
  42.         $result = mysql_query("SELECT * FROM players WHERE $filter $operator '$wert'");
  43.         echo "<table id=\"tabelle\">";
  44.         echo "<tr id=\"tabelle_head\"><th id=\"tabelle_head\">ID</th><th id=\"tabelle_head\">Name</th><th id=\"tabelle_head\">Logins</th><th id=\"tabelle_head\">Bl&ouml;cke</th></tr>";
  45.  
  46.         while ($row = mysql_fetch_assoc($result))
  47.         {
  48.             echo "<tr><th>".$row["ID"]."</th>";
  49.             echo "<th>".$row["Name"]."</th>";
  50.             echo "<th>".$row["totalLogin"]."</th>";
  51.             echo "<th>".$row["totalBlocks"]."</th></tr>";
  52.         }
  53.         echo "</table>";
  54.     }
  55.     echo '</div>';
  56. }
  57. mysql_close($db_verbindung);
  58. ?>
  59. </body>
  60. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement