SHARE
TWEET

Untitled

a guest Jul 22nd, 2019 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?
  2.  
  3. // deine daten
  4.  
  5. $server= "localhost";
  6. $user= "tom";
  7. $passwort= "djtom751";
  8. $datenbank= "GVZ";
  9. $tabelle= "CSV";
  10.  
  11. // Datenbank auswählen
  12.  
  13. MYSQL_CONNECT($server, $user, $passwort) or die ( "<center> <H3>Datenbankserver nicht erreichbar</H3>");
  14. MYSQL_SELECT_DB($datenbank) or die ( "<center> <H3>Datenbank nicht vorhanden</H3>");
  15.  
  16. // Suchen
  17.  
  18. $result=MYSQL_QUERY(" SELECT * FROM $tabelle WHERE RELEASEDATE='$suche' OR RELEASENAME='$suche' OR RELEASECREW='$suche' OR DiSKS='$suche' OR NFO='$suche' OR SFV='$suche'");
  19.  
  20. // Ergebnisse zählen
  21.  
  22. $num_rows = mysql_num_rows($result);
  23. echo "Es wurden $num_rows Ergebnisse gefunden!";
  24.  
  25. // kopf der seite ausspucken
  26.  
  27. echo "<table>";
  28. echo "<tr>";
  29. echo "<th>";
  30. echo "releasedate";
  31. echo "</th> <th>";
  32. echo "rleasename";
  33. echo "</th> <th>";
  34. echo "releasecrew";
  35. echo "</th> <th>";
  36. echo "disks";
  37. echo "</th> </tr>";
  38.  
  39. // gefundene daten ausspucken
  40.  
  41. while($myrow=mysql_fetch_row($result))
  42. {
  43. echo "<tr>";
  44. echo "<td>";
  45. echo "$myrow[0]";
  46. echo "</td>";
  47. echo "<td>";
  48. echo "$myrow[1]";
  49. echo "</td>";
  50. echo "<td>";
  51. echo "$myrow[2]";
  52. echo "</td>";
  53. echo "<td>";
  54. echo "$myrow[3]";
  55. echo "</td>";
  56. echo "</tr>";
  57. }
  58.  
  59. // bottom der seite
  60.  
  61. echo "</table>";
  62. ?>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top