Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ...
- <body>
- <div id="site">
- <?php include "nav.php"; ?>
- <div id="content">
- <b>Neu hochgeladen</b>
- <?php
- $db_host = "127.0.0.1";
- $db_user = "root";
- $db_pass = "";
- $db_name = "login";
- $conID = mysql_connect( $db_host, $db_user, $db_pass ) or die( "Die Datenbank konnte nicht erreicht werden!" );
- if ($conID)
- {
- mysql_select_db( $db_name, $conID );
- }
- $sql = "SELECT * FROM files ORDER BY id DESC LIMIT 10;";
- $abfrageergebnis = mysql_query( $sql, $conID );
- echo '<table border = "0">';
- echo "<tr>";
- echo '<td width="150" bgcolor="#d0e3f4"><font size="1"><center>Filename</center></font></td>';
- echo '<td width="60" bgcolor="#d0e3f4"><font size="1"><center>Category</center></font></td>';
- echo '<td width="60" bgcolor="#d0e3f4"><font size="1"><center>Date</center></font></td>';
- echo '<td width="40" bgcolor="#d0e3f4"><font size="1"><center>Link</center></font></td>';
- echo '<td width="70" bgcolor="#d0e3f4"><font size="1"><center>Size</center></font></td>';
- echo "</tr>";
- while ($datensatz = mysql_fetch_array( $abfrageergebnis ))
- {
- echo "<br>";
- echo "<tr>";
- echo '<td bgcolor="#ababab"><font size="2">' .$datensatz['filename']. '</font></td>';
- echo '<td bgcolor="#ababab"><font size="2"><center>' .$datensatz['category']. '</center></font></td>';
- echo '<td bgcolor="#ababab"><font size="2"><center>' .$datensatz['date']. '</center></font></td>';
- echo '<td bgcolor="#ababab"><center>';
- if($datensatz['type'] == "pdf")
- {
- echo '<a href="upload/'.$datensatz['category'].'/'.$datensatz['filename'].'"><img src="icons/pdf.png" height="20" width="20"></a>';
- }
- if($datensatz['type'] == "rar")
- {
- echo '<a href="upload/'.$datensatz['category'].'/'.$datensatz['filename'].'"><img src="icons/rar.png" height="20" width="20"></a>';
- }
- if($datensatz['type'] == "txt")
- {
- echo '<a href="upload/'.$datensatz['category'].'/'.$datensatz['filename'].'"><img src="icons/txt.png" height="20" width="20"></a>';
- }
- if($datensatz['type'] == "doc" || $datensatz['type'] == "docx")
- {
- echo '<a href="upload/'.$datensatz['category'].'/'.$datensatz['filename'].'"><img src="icons/word.png" height="20" width="20"></a>';
- }
- if($datensatz['type'] == "zip")
- {
- echo '<a href="upload/'.$datensatz['category'].'/'.$datensatz['filename'].'"><img src="icons/zip.png" height="20" width="20"></a>';
- }
- echo '</center></td>';
- echo '<td bgcolor="#ababab"><font size="2"><center>'.$datensatz['size'].' KB</center>';
- echo "</tr>";
- }
- echo "</table>";
- mysql_close($conID);
- ?>
- </div>
- </div>
- </body>
- ...
Advertisement
Add Comment
Please, Sign In to add comment