<?php
try
{
    //connectie met sql-server, in dit geval met windows authenticatie
    $pdo = new PDO('sqlsrv:server=.SQLEXPRESS;database=Marcel;','','');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e)
{
    echo 'Unable to connect to the database server.' . $e->getMessage();
    exit;
}
?>

<form method="post" action="InsertBlogEntry.php">
    <div class="form-group">
         <label for="Artikelnaam">Artikelnaam:</label>
         <input type="text" class="form-control" id="Artikelnaam" name="Artikelnaam">
    </div>
    <div class="form-group">
         <label for="Artikelonderwerp">Artikelonderwerp</label>
         <input type="text" class="form-control" id="Artikelonderwerp" name="Artikelonderwerp">
    </div>
    <div class="form-group">
         <label for="Artikeltext">Artikeltext</label>
         <textarea class="form-control" id="Artikeltext" rows="10" name="Artikeltext" style="resize: vertical;"></textarea>
    </div>
    <button type="submit" class="btn btn-default" style="display: block; margin: auto;">Submit</button>
</form>

<?php
    //set local time for $timeSubmitted
    setlocale(LC_TIME, 'NL_nl');

    //define values
    $timeSubmitted = strftime('%A %d %B %Y om %H:%M',time());
    $Author = $_SESSION['login_user'];
    $AtrikelNaam = $_POST['Artikelnaam'];
    $Onderwerp = $_POST['Artikelonderwerp'];
    $ArtkikelInhoud = $_POST['Artikeltext'];

    //include connection
    include ('connection.php');

    //statement
    $sql = sqlsrv_query("INSERT INTO BlogEntries (BlogTimeSubmitted, BlogAuthor, ArtikelName, ArtikelOW, ArtikelInhoud) VALUES ('$timeSubmitted', '$Author', '$AtrikelNaam', '$Onderwerp', '$ArtkikelInhoud')");

    //prepare and execute query
    $stmt = sqlsrv_query($pdo, $sql);

     if($stmt)
     {
         echo 'succes';
     }
     else
     {
        echo 'failure';
        die (print_r( sqlsrv_errors(), true))
     }

     //close connection
     sqlsrv_close($pdo);
?>

CREATE TABLE BlogEntries
(
ID int not null IDENTITY(1, 1),
BlogTimeSubmitted datetime,
BlogAuthor varchar(64),
ArtikelName varchar(64),
ArtikelOW varchar (64),
ArtikelInhoud varchar(max)
);

//just for dropping the table
drop table BlogEntries

alter table BlogEntries
ADD CONSTRAINT PK_BlogID PRIMARY KEY (ID)