Untitled

<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "History";

$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$an = intval($_GET['q']);
$sql = "SELECT * FROM History WHERE An = " . $an;
$result = $conn->query($sql);
?>
<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="content-type" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>History of Romania</title>
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="http://netdna.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css" rel="stylesheet">
    <link href="css/flexslider.css" rel="stylesheet" >
    <link href="css/styles.css" rel="stylesheet">
    <link href="css/queries.css" rel="stylesheet">
    <link href="css/animate.css" rel="stylesheet">
  </head>
  <body id="top">
    <header id="home">
      <nav>
        <div class="container-fluid">
          <div class="row">
            <div class="col-md-8 col-md-offset-2 col-sm-8 col-sm-offset-2 col-xs-8 col-xs-offset-2">
              <nav class="pull">
                <ul class="top-nav">
                  <li><a href="index.html">Acasa <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
                  <li><a href="search.html">Cauta informatii despre un an <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
                  <li><a href="bac.html">Materie BAC Istorie <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
                  <li><a href="index_quizz.php">Teste BAC Istorie <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
                </ul>
              </nav>
            </div>
          </div>
        </div>
      </nav>
      <section class="sectiune1" id="sectiune1">
        <div class="container" style="color:white;">
          <div class="row">
            <div class="col-md-12 text-right navicon">
              <a id="nav-toggle" class="nav_slide_button" href="#"><span></span></a>
            </div>
          </div>
          <div class="row">
            <div class="col-md-8 col-md-offset-2 text-center inner">
              <h1 class="animated fadeInDown"><span>History of Romania</span></h1>
            </div>
          </div>
          <?php

          if ($result->num_rows > 0) {
            // output data of each row
            while($row = $result->fetch_assoc()) {
              echo "<br><br>An: " . $row["An"]. " - Informatii: " . $row["Informatii"]."<br>";
            }
          } else {
            echo "0 rezultate";
          }

          ?>
        </div>
      </section>
    </header>
    <div class="col-md-6 credit">
      <p>Designed &amp; Developed by <a href="http://www.fotoploiesti.info/">Robinson Chera</a></p>
    </div>

    <footer>
      <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
      <!-- Include all compiled plugins (below), or include individual files as needed -->
      <script src="js/waypoints.min.js"></script>
      <script src="js/bootstrap.min.js"></script>
      <script src="js/scripts.js"></script>
      <script src="js/jquery.flexslider.js"></script>
      <script src="js/modernizr.js"></script>
    </footer>
  </body>
</html>

<?php
$conn->close();