Untitled

<html>
<head>
  <meta charset="utf-8">
  <title>nadpisik</title>
</head>
<body>
  <form action="" method="post" >
    <input type="text" id="meno" placeholder="Tvoje meno a priezvisko" name="meno" title="ĂNO presne sem napĂĹˇ svoje meno a priezvisko" required><br>
    <textarea id="textik" placeholder="Sem napíš svoje hobby" name="text" title="ak si to nepochopil/a tak tu napíš svoje hobby" required></textarea><br>
    <input type="submit" onclick="mlp()" name="submit">
  </form>

  <div id='texty'>
  </div>

  <?php
  $servername = "sql2.webzdarma.cz";
  $username = "simonovawzsk1140";
  $password = "lukessamko04";
  $dbname = "simonovawzsk1140";

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

  $sql = "SELECT meno, text FROM chat";
  $result = $conn->query($sql);
  if ($result->num_rows > 0) {
      // output data of each row
      while($row = $result->fetch_assoc()) {
          echo " <br>  Meno: ". $row["meno"]. " Správa: " . $row["text"] . "<br> ";
          echo "

          ";
      }
  } else {
      echo "Žiadna správa môžeš nejaku napísať";
  }


  $conn->close();
  ?>

  <?php
 if(isset($_POST["submit"]))
 {
  $ser = "sql2.webzdarma.cz";
  $user = "simonovawzsk1140";
  $pass = "lukessamko04";
  $db = "simonovawzsk1140";

    $con =mysqli_connect($ser, $user, $pass, $db);


    if(mysqli_connect_error()){
      echo "Chyba:".mysqli_connect_error();
      return;
    }

  $meno = $_POST["meno"];
  $text = $_POST["text"];


    $sql_dopyt="INSERT INTO `chat` (`meno`, `text`) VALUES ('$meno', '$text')";

    $vysledok=mysqli_query($con, $sql_dopyt);

    if ($vysledok==0){

      echo "Chyba: ".mysqli_error($con);
    }else{
      echo "<br> odoslanie úspešné";
    }
}


   ?>

<script
  src="https://code.jquery.com/jquery-2.2.4.js"
  integrity="sha256-iT6Q9iMJYuQiMWNd9lDyBUStIq/8PuOW33aOqmvFpqI="
  crossorigin="anonymous"></script>

</body>
</html>