<?php
$servername = "localhost";
$username = "root";
$password = "";
$db = "db";

$conn = new mysqli($servername, $username, $password, $db);

if ($conn->connect_error) {
    die("Failed to connect to database: " . $conn->connect_error);
}
?>

<?php
    include 'head.php';
    include 'sql.php';
?>

        <form class="form" method="post" id="newmessage" action="success.php">

            <input type="submit" value="Submit" />
        </form>
        <textarea form="newmessage" name="message" class="message" placeholder="Type your message here..."></textarea>

<?php
    include 'foot.php';
?>

<?php
    include 'head.php';
    include 'sql.php';

$message = $_POST['message'];
$date = date('d/m/y');
$ip = $_SERVER['REMOTE_ADDR'];

$sql = "INSERT INTO messages (message, date, ip)
VALUES ($message, $date, $ip)";

$conn->query($sql);

$conn->close();

?>

<div class="text" style="text-align:center;">
    Your message has been submitted successfully.<br />

    <a href="index.php" ><button style="margin-top:20px;">Back</button></a>
</div>

<?php
    include 'foot.php'
?>