Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- // deine daten
- $server= "localhost";
- $user= "tom";
- $passwort= "djtom751";
- $datenbank= "GVZ";
- $tabelle= "CSV";
- // Datenbank auswählen
- MYSQL_CONNECT($server, $user, $passwort) or die ( "<center> <H3>Datenbankserver nicht erreichbar</H3>");
- MYSQL_SELECT_DB($datenbank) or die ( "<center> <H3>Datenbank nicht vorhanden</H3>");
- // Suchen
- $result=MYSQL_QUERY(" SELECT * FROM $tabelle WHERE RELEASEDATE='$suche' OR RELEASENAME='$suche' OR RELEASECREW='$suche' OR DiSKS='$suche' OR NFO='$suche' OR SFV='$suche'");
- // Ergebnisse zählen
- $num_rows = mysql_num_rows($result);
- echo "Es wurden $num_rows Ergebnisse gefunden!";
- // kopf der seite ausspucken
- echo "<table>";
- echo "<tr>";
- echo "<th>";
- echo "releasedate";
- echo "</th> <th>";
- echo "rleasename";
- echo "</th> <th>";
- echo "releasecrew";
- echo "</th> <th>";
- echo "disks";
- echo "</th> </tr>";
- // gefundene daten ausspucken
- while($myrow=mysql_fetch_row($result))
- {
- echo "<tr>";
- echo "<td>";
- echo "$myrow[0]";
- echo "</td>";
- echo "<td>";
- echo "$myrow[1]";
- echo "</td>";
- echo "<td>";
- echo "$myrow[2]";
- echo "</td>";
- echo "<td>";
- echo "$myrow[3]";
- echo "</td>";
- echo "</tr>";
- }
- // bottom der seite
- echo "</table>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement