Untitled

<!DOCTYPE html>
<html>
<head>
    <title>CubeMarket :: All Listings</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" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
    <style>
        h2, h4 {
            text-align: center;
        }
    </style>
    <?php
    require ("navbar.php");
    echo getNavBar("reports");
    ?>
</head>
<body>
<div class="jumbotron text-center">
    <h1>All Cubes</h1>
    <p>Viewing All Listings</p>
</div>
<div class="container">
    <div id="recent-reports">

        <table class="table table-striped">

            <tr>
                <th>Name</th>
                <th>Description</th>
                <th>Category</th>
                <th>Condition</th>
                <th>Imgur Link</th>
            </tr>

            <?php
            global $servername, $username, $password, $dbname, $lastPageButton, $nextPageButton;

            $servername = "localhost";
            $username = "root";
            $password = "xxxxxx";
            $dbname = "cubemarket";
            error_reporting(0);
            $link = mysqli_connect($servername, $username, $password, $dbname, 3306) or die("Error on database connection.");

			$lastPageButton = TRUE;
			$nextPageButton = TRUE;

            if (!isset(((int)$_GET['p']))) {
                $results = mysqli_query($link, "SELECT * FROM `listings` ORDER BY id DESC LIMIT 20;") or die("Error on database query.");
            } else {
                $page = mysqli_real_escape_string($link, ((int)$_GET['p']));
                if ($page < 1) {
                    $page = 1;
                }
                $first = (20 * ($page - 1)) + 1;
                $last = $first + 19;
                echo $first . " - " . $last;
                $results = mysqli_query($link, "SELECT * FROM `listings` WHERE id BETWEEN $first AND $last ORDER BY id DESC;") or die("Error on database query.");
            }
            if (mysqli_num_rows($results) > 0) {
                $tableResults = array();
                while ($row = mysqli_fetch_array($results)) {
                    $id = $row['id'];
                    $name = $row['name'];
                    $description = $row['description'];
                    $category = $row['category'];
                    $condition = $row['cubecondition'];
                    $imgurlink = $row['imgurlink'];
                    $other = $row['otherinfo'];
                    array_push($tableResults, array($id, $name, $description, $category, $condition, $imgurlink));
                }

				$allRows = mysqli_query($link, "SELECT * FROM `listings`;") or die("Error on database query.");

				if (!isset($_GET['p'])) {
					$lastPageButton = FALSE;
				} elseif (mysqli_num_rows($allRows) == (20 + 20 * mysqli_real_escape_string($link, ((int)$_GET['p'])))) {
					$nextPageButton = FALSE;
				}

                foreach ($tableResults as $item) {
					echo "<tr><td><a href='http://192.99.70.9/listing.php?id='".$item[0].">$item[1]</a></td><td>$item[2]</td><td>$item[3]</td><td>$item[4]</td><td>$item[5]</td></tr>";
				}
            } else {
                echo "<tr><td>No listings</td><td>No listings</td><td>No listings</td><td>No listings</td><td>No listings</td></tr>";
            }
            ?>

        </table>

	   	<?php
			if ($lastPageButton) {
                $page = ((int)$_GET['p'])-1;
                echo "<a href='/cubes.php?p=".$page."'><button type='submit'>Last page</button></a>";
            }

            if ($nextPageButton) {
                $page = ((int)$_GET['p'])+1;
                echo "<a href='/cubes.php/?p=".$page."'><button type='submit'>Next page</button></a>";
            }
		?>
    </div>
</div>
</body>
</html>