Untitled

<?php

            session_start();


            $servername = "sql1.njit.edu";
            $username = "rkl9";
            $password = "teeing46";
            $dbname = "rkl9";

            // Create connection
            $dbc = new mysqli($servername, $username, $password, $dbname);
            // Check connection
              if (!$dbc)
              {
                  die("Connection failed: " . mysqli_connect_error());
              }


              $n = $_POST["personName"];
              $p = $_POST["pswd"];


                if($n!=''&& $p!='')
                {

                 $query = "SELECT `name`, `pwd` FROM `chatApp` WHERE `name` = '$n' AND `pwd` = '$p'";
                 $result = mysqli_query($dbc, $query);


                 if(!$result)
                 {
                    die("Query Failed: " .  mysqli_error($dbc));
                 }
                 else
                 {
                       if(mysqli_num_rows($result)>0)
                       {
                          $_SESSION['name'] = $n;
                          echo "<h2>Login successful</h2>";
                          header( "Location: index.php" );
                       }
                      else
                      {
                         echo "<h2>Your username or password is incorrect</h2>";
                      }
                 }
                }


        ?>

<!DOCTYPE html>
<html>
    <head>
        <title>Simple Chat</title>
        <link rel="stylesheet" href="style.css" media="all" />


    </head>

    <body>

    <div id="container">

        <div id="chat_box">
                <div id="chat_data">
                   <?php

                session_start();
              if(array_key_exists('name',$_SESSION) && !empty($_SESSION['name']))
               {
                  echo "Logged in as: " . $_SESSION['name'];
              }
              else
              {
                echo  'Nobody is logged in!';
              }

             function sendMessage()
                 {


                    $name = $_SESSION['name'];
                    $msg = $_POST['log'];


              $query = "INSERT INTO `chatApp`(`name`, `pwd`, `message`) VALUES ('$name', NULL, '$msg')";
                    $run = $dbc->query($query);


                    echo "<p>" . $name . " : </p> ";
                    echo "<p>" . $msg . "</p>";

          }

          ?>

            </div>

          </div>


      <form method="post" action="index.php">
            <?php
            if(isset($_POST['submit']))
            {
                sendMessage();
            }
            ?>


                <textarea name="log" placeholder="Enter Message"></textarea>
                <input type="submit" name="submit" id="submit" value="Send!" />
            </form>
      </div>


        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    </body>
</html>