View difference between Paste ID: gSLXNgqu and aMqE967v
SHOW: | | - or go back to the newest paste.
1-
<meta content="text/html; charset=UTF-8" http-equiv="content-type" />
1+
2
$servername = "localhost";
3
$username = "root";
4
$password = "root";
5
$dbname = "History";
6
7
$conn = new mysqli($servername, $username, $password, $dbname);
8
// Check connection
9
if ($conn->connect_error) {
10
    die("Connection failed: " . $conn->connect_error);
11
} 
12
$an = intval($_GET['q']);
13
$sql = "SELECT * FROM History WHERE An = " . $an;
14-
 $sql = "SELECT * FROM History WHERE An = " . $an;
14+
15
?>
16
<html>
17-
if ($result->num_rows > 0) {
17+
  <head>
18-
    // output data of each row
18+
    <meta content="text/html; charset=UTF-8" http-equiv="content-type" />
19-
    while($row = $result->fetch_assoc()) {
19+
20-
        echo //aici incepe problema 
20+
21-
  '<head>
21+
22-
    <meta charset="utf-8">
22+
23
    <link href="http://netdna.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css" rel="stylesheet">
24
    <link href="css/flexslider.css" rel="stylesheet" >
25
    <link href="css/styles.css" rel="stylesheet">
26
    <link href="css/queries.css" rel="stylesheet">
27
    <link href="css/animate.css" rel="stylesheet">
28
  </head>
29
  <body id="top">
30
    <header id="home">
31
      <nav>
32-
      </head>
32+
        <div class="container-fluid">
33-
      <body id="top">
33+
          <div class="row">
34-
        <header id="home">
34+
            <div class="col-md-8 col-md-offset-2 col-sm-8 col-sm-offset-2 col-xs-8 col-xs-offset-2">
35-
          <nav>
35+
              <nav class="pull">
36-
            <div class="container-fluid">
36+
                <ul class="top-nav">
37-
              <div class="row">
37+
                  <li><a href="index.html">Acasa <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
38-
                <div class="col-md-8 col-md-offset-2 col-sm-8 col-sm-offset-2 col-xs-8 col-xs-offset-2">
38+
                  <li><a href="search.html">Cauta informatii despre un an <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
39-
                  <nav class="pull">
39+
                  <li><a href="bac.html">Materie BAC Istorie <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
40-
                    <ul class="top-nav">
40+
                  <li><a href="index_quizz.php">Teste BAC Istorie <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
41-
                      <li><a href="index.html">Acasa <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
41+
                </ul>
42-
                      <li><a href="search.html">Cauta informatii despre un an <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
42+
              </nav>
43-
                      <li><a href="bac.html">Materie BAC Istorie <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
43+
44-
                      <li><a href="index_quizz.php">Teste BAC Istorie <span class="indicator"><i class="fa fa-angle-right"></i></span></a></li>
44+
45-
                    </ul>
45+
        </div>
46-
                  </nav>
46+
      </nav>
47-
                </div>
47+
      <section class="sectiune1" id="sectiune1">
48-
              </div>
48+
        <div class="container" style="color:white;">
49
          <div class="row">
50-
          </nav>
50+
            <div class="col-md-12 text-right navicon">
51-
          <section class="sectiune1" id="sectiune1">
51+
              <a id="nav-toggle" class="nav_slide_button" href="#"><span></span></a>
52-
            <div class="container" style="color:white;">
52+
53-
              <div class="row">
53+
54-
                <div class="col-md-12 text-right navicon">
54+
          <div class="row">
55-
                  <a id="nav-toggle" class="nav_slide_button" href="#"><span></span></a>
55+
            <div class="col-md-8 col-md-offset-2 text-center inner">
56-
                </div>
56+
              <h1 class="animated fadeInDown"><span>History of Romania</span></h1>
57-
              </div>
57+
            </div> 
58-
              <div class="row">
58+
59-
                <div class="col-md-8 col-md-offset-2 text-center inner">
59+
          <?php
60-
                  <h1 class="animated fadeInDown"><span>History of Romania</span></h1>
60+
61-
                </div>
61+
          if ($result->num_rows > 0) {
62-
               //daca inchid aici cu apostroful, nu-mi mai functioneaza meniul.. 
62+
            // output data of each row
63-
              </div>;
63+
            while($row = $result->fetch_assoc()) {
64-
               echo "<br><br>An: " . $row["An"]. " - Informatii: " . $row["Informatii"]."<br>";
64+
              echo "<br><br>An: " . $row["An"]. " - Informatii: " . $row["Informatii"]."<br>";
65-
            "</div>
65+
            }
66-
           
66+
          } else {
67-
          </section>
67+
            echo "0 rezultate";
68-
        </header>
68+
          }
69-
              <div class="col-md-6 credit">
69+
70-
                <p>Designed &amp; Developed by <a href="http://www.fotoploiesti.info/">Robinson Chera</a></p>
70+
          ?>
71-
              </div>
71+
        </div> 
72
      </section>
73
    </header>
74-
        </footer>
74+
    <div class="col-md-6 credit">
75-
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
75+
      <p>Designed &amp; Developed by <a href="http://www.fotoploiesti.info/">Robinson Chera</a></p>
76-
        <!-- Include all compiled plugins (below), or include individual files as needed -->
76+
    </div>
77-
        <script src="js/waypoints.min.js"></script>
77+
78-
        <script src="js/bootstrap.min.js"></script>
78+
    <footer>
79-
        <script src="js/scripts.js"></script>
79+
      <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
80-
        <script src="js/jquery.flexslider.js"></script>
80+
      <!-- Include all compiled plugins (below), or include individual files as needed -->
81-
        <script src="js/modernizr.js"></script>
81+
      <script src="js/waypoints.min.js"></script>
82-
      </body>';
82+
      <script src="js/bootstrap.min.js"></script>
83
      <script src="js/scripts.js"></script>
84-
    }
84+
      <script src="js/jquery.flexslider.js"></script>
85-
} else {
85+
      <script src="js/modernizr.js"></script>
86-
    echo "0 rezultate";
86+
    </footer>
87-
}
87+
  </body>
88-
$conn->close();
88+
</html>
89-
?>
89+
90
<?php
91
$conn->close();