Untitled

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

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

if(isset($_POST['save']))
{
        $sql = "INSERT INTO `form` (`firsName`, `lastName`, `website`, `email`, `message`) VALUES ('".$_POST["firstName"]."','".$_POST["lastName"]."','".$_POST["message"]."','".$_POST["email"]."','".$_POST["website"]."')";

        //$stmt = mysqli_prepare($sql);

        //$stmt->bind_param("sss", $_POST['firstName'], $_POST['lastName'], $_POST['message'], $_POST['email'], $_POST['website']);

        $result = mysqli_query($conn,$sql);
    }

$errormessages = array();
if ($_SERVER['REQUEST_METHOD'] == "POST")
{

//user has sent the form using the submit
$message = "User has sent the form </br> ";

$errormessages = array();

 if ($_POST['firstName'] == "")
 {
    $errormessages[]= "You forgot your first name";
 }
 if ($_POST['lastName'] == "")
 {
    $errormessages[]= "You forgot your last name";
 }
 if ($_POST['message'] == "")
 {
    $errormessages[]= "You forgot your message";
 }
 if ($_POST['email'] == "")
 {
    $errormessages[]= "You forgot your last email";
 }
 if ($_POST['website'] == "")
 {
    $errormessages[]= "You forgot your last website";
 }
}
else
{

//user has not yet send the form
$message = "User has not yet send the form";
}


?>

<html>
    <head>
        <title>
            My guestbook
        </title>
    </head>
    <body>

        <?php
        echo $message;
        echo "<br/>";
        //var_dump($_POST);

        foreach($errormessages as $error)
        {
            echo $error;
            echo "<br/>";
        }

        ?>
        <form action="" method="POST">
            <fieldset>
                <legend></br> My guestbook</legend>
                <label>First name</label>
                <input type="text" name="firstName" placeholder="Enter your first name"/>
                <label>Last name</label>
                <input type="text" name="lastName" placeholder="Enter your last name"/>
                <label>Message</label>
                <textarea name="message" placeholder="Your message goes here..."></textarea>
                <label>Email</label>
                <textarea name="email" placeholder="Enter your email"></textarea>
                <label>Website</label>
                <textarea name="website" placeholder="Enter your website"></textarea>
                <button type="submit" name="save">Save</button>
            </fieldset>
        </form>
    </body>