Untitled

!!!!!!!!!index.php!!!!!!!!!!!!
<?php
     include("config.php");
     ini_set('display_errors', 1);
     ini_set('display_startup_errors', 1);
     error_reporting(E_ALL);
     session_start();

     if($_SERVER["REQUEST_METHOD"] == "POST") {
       $myusername = mysqli_real_escape_string($db,$_POST['name']);
       $mypassword = mysqli_real_escape_string($db,$_POST['password']);

       $sql = "SELECT * FROM chatapp WHERE Name = '$myusername' and Password = '$mypassword'";
       $result = mysqli_query($db,$sql);
       $row = mysqli_fetch_array($result,MYSQLI_ASSOC);

       $count = mysqli_num_rows($result);

       if($count == 1) {
          session_register("myusername");
          $_SESSION['login_user'] = $myusername;
       } else {
          $issue = "Your Login Name or Password is invalid";
       }
     }
  ?>

 <html>
     <head>
       <title>Chat App</title>
     </head>

     <body bgcolor = "#FFFFFF">

        <div align = "center">
            <div style = "width:300px; border: solid 1px #333333; " align = "left">
              <div style = "background-color:#333333; color:#FFFFFF; padding:3px;"><b>Login</b></div>

             <div style = "margin:30px">

              <!-- List of names in the database -->
              <div>
                 <?php
                   $query = "SELECT Name from chatapp";
                   $result1=$db->query($query);
                   echo "<br><br><table>";
                   while($row = $result1->fetch_assoc()){
                    echo "<tr><td>" . $row['Name'] . "</td></tr>";
                   }
                  ?>
              <div>

                  <br>
              <br>

                <!-- Form for inserting information into the database -->
                <form id="myForm" action="insert.php" method = "POST">
                    <label>Name:</label><input type = "text" name = "name" id="name" class = "box"/><br /><br />
                    <label>Password:</label><input type = "text" name = "password" id="password" class = "box" /><br/><br />
                    <label>Content:</label><input type = "text" id="content" name = "content" class = "box"/><br /><br />
                   <button id='insert'>Submit</button>
                </form>

                <br>
                <br>

                 <!-- Form for listening to other users of the database -->
                <form>
                   <label>Enter a valid name to retrieve chat:</label><input type = "text" name = "name1" class = "box"/><br /><br />
                   <button id='listen'>Listen</button>
  <br />
                </form>

                 <table class="table table-striped">
                  <tbody id="tablebody">
                  </tbody>
                 </table>

                <br>
                <br>

                <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.0/jquery.min.js"></script>
                <script src="my_script.js" type="text/javascript"></script>

              </div>
           </div>
       </div>
    </body>
 </html>

!!!!!!!!!!!!!!!!my_script.js!!!!!!!!!!!!!!!!
$("#content").onkeyup( function() {
$.post( $("#myForm").attr("action"),
  $("#myForm :input").serializeArray(),
    function(info){ $("#result").html(info);
  });
clearInput();
});

$("#myForm").submit( function() {
  return false;
});

function clearInput() {
$("#myForm :input").each( function() {
  $(this).val('');
  });
}

$("#listen").onclick(function(){
 var url = 'getmessage.php';
    $.getJSON(url, function(data) {
        $.each(data, function(index, data) {
         $('#tablebody').append('<tr>');
         $('#tablebody').append('<td>'+data.content+'</td>');
         $('#tablebody').append('</tr>');
    });
  });
});

!!!!!!!!!!!!!!!insert.php!!!!!!!!!!!!!!!!
<?php
  include('config.php');
  ini_set('display_errors', 1);
  ini_set('display_startup_errors', 1);
  error_reporting(E_ALL);
  if (isset($_POST['name'])) {
      $name = $_POST['name'];
  }

  if (isset($_POST['password'])) {
      $password = $_POST['password'];
  }

  if (isset($_POST['content'])) {
       $content = $_POST['content'];
   }

  $sql = "UPDATE chatapp SET Content='$content' WHERE Name= '$name'";

  if (mysqli_query($db, $sql) === TRUE) {
     echo "<span> Record updated successfully <span>";
  } else {
     echo "<span> Error updating record: <span>" . $conn->error;
    }

    if(isset($_POST["name"], $_POST["password"]))
      {
         $query= "SELECT * FROM chatapp WHERE Name = '" . $name. "' AND  Password = '" . $password "';
         $result1 = mysqli_query($db,$query);

        if(mysqli_num_rows($result1) < 1 )
        {
             echo 'Your name and password combination is incorrect!';
        }
     }
   ?>

!!!!!!!!!!!!!!!getmessage.php!!!!!!!!!!!!!!!!
<?php
$name1='';
if (isset($_POST['Name1'])) {
    $name1 = $_POST['Name1'];
}

$sql = "SELECT Content FROM chatapp WHERE Name='$name1'";
$result = mysqli_query($db,$sql);

$data = array();
while($row = mysqli_fetch_array($result)){
  $row_data = array(
   'content' => $row['Content']
   );
  array_push($data, $row_data);
}

echo json_encode($data);
?>

!!!!!!!!!!!!!!!config.php!!!!!!!!!!!!!!!!
<?php
   define('DB_SERVER', 'sample');
   define('DB_USERNAME', 'sample');
   define('DB_PASSWORD', 'sample');
   define('DB_DATABASE', 'sample');
   $db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
?>