Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <title>Ak1r4 Torrent Site</title>
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
- <link rel="stylesheet" type="text/css" href="../css/loader.css">
- </head>
- <body>
- <div id="preloader">
- <div id="status"> </div>
- </div>
- <div class="container" style="margin-top: 20px">
- <div class="row">
- <div class="col-md-8 col-md-offset-2">
- <table class="table table-bordered table-hover">
- <thead>
- <tr>
- <td>TITOLO</td>
- <td>DESCRIZIONE</td>
- <td>DOWNLOAD</td>
- </tr>
- </thead>
- <tbody>
- <?php
- //$conn = new mysqli('localhost', 'root', '', 'csvtest');
- $conn = pg_connect("host=localhost dbname=csvtest user=root");
- $query = 'SELECT TITOLO, DESCRIZIONE, HASH FROM tnt WHERE CATEGORIA = 26';
- $ret = pg_query($conn, $query);
- if(!$ret) {
- echo pg_last_error($conn);
- exit;
- }
- //$sql = $conn->query('SELECT TITOLO, DESCRIZIONE, HASH FROM tnt WHERE CATEGORIA = 26');
- //while($data = $sql->fetch_array()) {
- while($data = pg_fetch_array($ret)) {
- echo '
- <tr>
- <td>'.$data['TITOLO'].'</td>
- <td>'.$data['DESCRIZIONE'].'</td>
- <td><a href="magnet:?xt=urn:btih:'.$data['HASH'].'">Link</a></td>
- </tr>
- ';
- }
- ?>
- </tbody>
- </table>
- </div>
- </div>
- </div>
- <script src="http://code.jquery.com/jquery-3.2.1.min.js"
- integrity="sha256-hwg4gsxgFZhOsEEamdOYGBf13FyQuiTwlAQgxVSNgt4="
- crossorigin="anonymous"></script>
- <script type="text/javascript" src="../js/jquery.dataTables.min.js"></script>
- <script type="text/javascript" src="../js/dataTables.bootstrap.min.js"></script>
- <script type="text/javascript" src="../js/loader.js"></script>
- <script type="text/javascript">
- $(document).ready(function() {
- $(".table").DataTable({
- "ordering": true,
- "searching": true,
- "paging": true,
- "columnDefs": [
- {
- "targets": 0,
- "searchable": true,
- "visible": true
- }
- ],
- "order": [[2, "desc"]]
- });
- });
- </script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement