Untitled

<?php

    $server = "localhost";
    $username = "root";
    $password = "";

    $conn = new mysqli($server, $username, $password, "test");
    $conn2 = new mysqli($server, $username, $password, "eve");

    $result = $conn->query("SELECT * FROM starbases;")

?>

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="icon" href="../../favicon.ico">

    <title>Dashboard Template for Bootstrap</title>

    <!-- Bootstrap core CSS -->
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
    <link href="css/style.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="dashboard.css" rel="stylesheet">
  </head>

  <body>
    <nav class="navbar navbar-inverse navbar-fixed-top">
      <div class="container-fluid">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand" href="#">Project name</a>
        </div>
        <div id="navbar" class="navbar-collapse collapse">
          <ul class="nav navbar-nav navbar-right">
            <li><a href="#">Dashboard</a></li>
            <li><a href="#">Settings</a></li>
            <li><a href="#">Profile</a></li>
            <li><a href="#">Help</a></li>
          </ul>
          <form class="navbar-form navbar-right">
            <input type="text" class="form-control" placeholder="Search...">
          </form>
        </div>
      </div>
    </nav>

    <div class="container-fluid">
      <div class="row">
        <div class="col-sm-3 col-md-2 sidebar">
          <ul class="nav nav-sidebar">
            <li class="active"><a href="#">Eins <span class="sr-only">(current)</span></a></li>
            <li><a href="#">Zwei</a></li>
            <li><a href="#">Drei</a></li>
            <li><a href="#">vier</a></li>
          </ul>
        </div>
        <div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
          <h1 class="page-header">Dashboard</h1>
          <div class="table-responsive">
            <table class="table">
                <tr>
                    <th>Name</th>
                    <th>Ort</th>
                    <th>Typ</th>
                    <th>Fuel Blocks</th>
                    <th>Fuel reicht bis</th>
                    <th>Strontium</th>
                    <th>Corp Access aktiv</th>
                </tr>
                <?php
                while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
                    $result2=$conn2->query("SELECT itemName FROM mapDenormalize WHERE itemID = ".$row["moonID"]);
                    $location = $result2->fetch_array(MYSQLI_ASSOC);
                    $result2= $conn2->query("SELECT typeName FROM invTypes WHERE typeID = ".$row["typeID"]);
                    echo $conn2->error;
                    $type = $result2->fetch_array(MYSQLI_ASSOC);

                    echo "<tr>";
                        echo "<td>".$row["itemID"]."</td>";
                        echo "<td>".$location["itemName"]."</td>";
                        echo "<td>".$type["typeName"]."</td>";
                        echo "<td>".$row["fuel"]."</td>";
                        echo "<td>-</td>";
                        echo "<td>".$row["strontium"]."</td>";
                        echo "<td>".$row["allowCorpMembers"]."</td>";
                    echo "</tr>";
                }
                ?>
            </table>
          </div>
        </div>
      </div>
    </div>

    <!-- Bootstrap core JavaScript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
  </body>
</html>