<?php
    //Connecting to sql db.
    $servername = "hostname";
    $username = "username";
    $password = "password";
    $dbname = "dbname";

    $connect = mysqli_connect($servername, $username, $password, $dbname);
    if ($connect->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    //Fetch next_id
    $sql = "SELECT * FROM comments";
    $result = $connect->query($sql);
    $next_id = $result->num_rows;

    //Insert comment
    $sql = "INSERT INTO comments(comment_id, username, comment) VALUES ($next_id, '$_POST[username]', $_POST[comment_text]')";
    mysqli_query($connect, $sql);
    #mysqli_query($connect,"INSERT INTO posts (comment_id, username, comment) VALUES ($next_id, '$_POST[username]', '$_POST[comment_text])");

    $sql = "SELECT * FROM comments WHERE comment_id is $next_id";
    $result = $connect->query($sql);
    if($result->num_rows > 0){
        while($row = $result->fetch_assoc()) {
            echo "<p>Comment has been added.</p>";
            echo "<p style="margin: 0 10px;"><u>" . $row["username"] . "</u></p>";
            echo "<p style="padding-left: 50px; margin: 0 0;">" . $row["comment"] . "</p>";
        }
    } else {
        echo "<p>Failed to add comment.</p>";
    }
    $connect->close();
?>

<div id="page" class="container">
                        <section>
                            <header class="major">
                                <h2>Comments</h2>
                                <span class="byline">Here you can comment about my awesome coding skills</span>
                            </header>
                            <div style="border: 4px solid black; border-radius: 10px;">
                                <?php
                                    $servername = "hostname";
                                    $username = "user";
                                    $password = "pass";
                                    $dbname = "dbname";

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

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

                                    if ($result->num_rows > 0) {
                                        // output data of each row
                                        while($row = $result->fetch_assoc()) {
                                            echo "<p style="margin: 0 10px;"><u>" . $row["username"] . "</u></p>";
                                            echo "<p style="padding-left: 50px; margin: 0 0;">" . $row["comment"] . "</p>";
                                        }
                                    } else {
                                        echo "0 comments exist";
                                    }
                                    $conn->close();
                                ?>
                            </div>
                            <div style="border: 1px solid black; border-radius: 10px; margin-top: 20px;">
                                <form style="margin: 0 10px;" action="send_post.php" method="post">
                                    <br/><b>Make a comment:</b><br/>
                                    Username<br/>
                                    <input style="width: 300px; border: 1px solid black;" type="text" name="username" required>
                                    <!--Comment title:<br/>
                                    <input style="width: 300px; border: 1px solid black;" type="text" name="comment_title" required-->
                                    Comment:<br/>
                                    <textarea style="width: 300px; border: 1px solid black;" rows="10" cols="25" name="comment_text" required></textarea>
                                    <br/>
                                    <input type="submit">
                                </form>
                            </div>
                        </section>
                    </div>