Untitled

<!DOCTYPE html>
<html>

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js">
     </script>
    <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js">
     </script>

    <style>
        #atsiliepimai{
            font-family:"Trebuchet MS",Arial,Helvetica,sans-serif;
            border-collapse:collapse;
            width:70%;
        }
        #atsiliepimai td {
            border:1px solid #ddd;
            padding: 8px;}
        #atsiliepimai tr:nth-child(even){
            background-color: #f2f2f2;}
        #atsiliepimai tr:hover {
            background-color: #ddd;}
    </style>
</head>

    <center><h3>Atsiliepimu knyga</h3></center>

    <body>
    <?php
    $dbc=mysqli_connect('localhost', 'stud', 'stud', 'stud');
    if(!$dbc){
        die("Negaliu prisijungti prie MYSQL:" .mysqli_error($dbc));
    }
    if($_POST !=null){
        $vardas = $_POST['vardas'];
        $epastas = $_POST['epastas'];
        $zinute = $_POST['zinute'];
        $ip = $_SERVER['REMOTE_ADDR'];
        $sql = "INSERT INTO mantasantanaitis (vardas, epastas, zinute, ip) VALUES ('$vardas', '$epastas', '$zinute', '$ip')";
    if(mysqli_query($dbc, $sql)) echo ""; else die ("Klaida irasant:" .mysqli_error($dbc));
    }
    ?>
    </body>

    <body>
    <?php
    $servername = "localhost";
    $username = "stud";
    $password = "stud";
    $dbname = "stud";


    // Sukuriamas connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Tikrinamas connection
    if($conn->connect_error){
        die("Connection failed:".$conn->connect_error);
    }

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

    if($result->num_rows > 0){
        echo "<table style='margin: 0px auto;' id='atsiliepimai'>
        <tr>
            <th>vardas</th>
            <th>e-pastas</th>
            <th>data_laikas (ip numeris)</th>
            <th>zinute</th>
        </tr>";
        while($row = $result->fetch_assoc()){
        echo "<tr>
            <td>".$row["vardas"]."</td>
            <td>".$row["epastas"]."</td>
            <td>".$row["data"]." <br>(".$row["ip"].")</br></td>
            <td>".$row["zinute"]."</td>
        </tr>";
        }
    echo "</table>";
    } else {
     echo "0 results";
    }

    $conn->close();
    ?>

    </body>

<div class="container">
  <form method='post' action='index.php'>
     <div class="form-group col-lg-12">
          <label for="vardas" class="control-label">Vardas:</label>
          <input name='vardas' id='vardas' type='text' class="form-control input-sm">
     </div>
     <div class="form-group col-lg-12">
          <label for="epastas" class="control-label">e-pastas:</label>
          <input name='epastas' id="epastas" type='email' class="form-control input-sm">
     </div>
     <div class="form-group col-lg-12">
          <label for="zinute" class="control-label">tekstas:</label>
          <textarea name='zinute' class="form-control input-sm"></textarea>
     </div>
     <div class="form-group">
         <input type='submit' name='ok' value='siusti' class="btnbtn-default">
     </div>
 </form>
</div>


</html>