<?php
$dsn = 'mysql:host=localhost;dbname=test2';
$user = 'root';
$pass = 'root1234';
$options = array(PDO::MYSQL_ATTR_INIT_COMMAND=>'SET NAMES UTF8');
try{
    $odma = new PDO($dsn, $user, $pass, $options);
    $odma->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
    echo "Successfully connected";
    $query = "INSERT INTO `products` (`id`, `name`) VALUES (NULL, 'product4')";
    $odma->exec($query);

}
catch( PDOException $error)
{
    echo "failed" . $error->getMessage();
}
?>