<?php
/**
 * Created by PhpStorm.
 * User: Daniel
 * Date: 08.11.2016
 * Time: 03:48
 */

$host = "127.0.0.1:3306";
$dbname = "lab4";
$username = "daniel";
$password = "daniel";

date_default_timezone_set("Europe/Skopje");

try {
    $dsn = "mysql:host=$host;dbname=$dbname";
    $opt = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'");
    $connection = new PDO($dsn, $username, $password, $opt);

    $sql = <<<SQL
    INSERT INTO lab4.news (news_id, date, news_title, full_text)
    VALUES(:id, :date, :header, :news_text)
SQL;

    $ps = $connection->prepare($sql);

    $params = array(
        'id' => $last_id = $connection->lastInsertId(),
        'date' => date("Y-m-d G-i-s"),
        'header' => $_GET["naslov"],
        'news_text' => $_GET["tekst"]
    );

    $ps->execute($params);

} catch (PDOException $e) {
    print $e->getMessage();
}