<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$host = 'localhost';
$db = 'addnews';
$user = 'root';
$pass = '';
$charset = 'utf8';
// $text = (isset($_POST['title']) && !empty($_POST['title']))?'%'.$_POST['title'].'%':'';

$title = $_POST['title'];
$date = $_POST['date'];
$status = $_POST['publish_in_index'];
$category = $_POST['category'];
$content = $_POST['content'];
$author = $_POST['author'];

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";

$opt = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

echo $title.'<br>';
echo $date.'<br>';
echo $status.'<br>';
echo $category.'<br>';
echo $content.'<br>';
echo $author.'<br>';
$pdo = new PDO($dsn, $user, $pass, $opt);

if(!empty($title) && !empty($content) && !empty($author)){
    $sql = "INSERT INTO `news` (`title`, `publish_date`, `status`, `category`, `content`, `author`)
            VALUES (:title, :publish_date, :status, :category, :content, :author)";

    $rows = $pdo->prepare($sql);
    $rows->execute([
            'title'=>$title,
            'publish_date'=>$date,
            'status'=>$status,
            'category'=>$category,
            'content'=>$content,
            'author'=>$author
        ]);

    echo "Запись добавлена";
}else{
    echo "Запись не добавлена";
}

?>