<?php
define('MYSQL_SERVEUR', 'localhost');
define('MYSQL_UTILISATEUR', 'root');
define('MYSQL_MOTDEPASSE', '');
define('MYSQL_BASE', 'test');

$mysql = new MySQLi(MYSQL_SERVEUR,
                    MYSQL_UTILISATEUR,
                    MYSQL_MOTDEPASSE,
                    MYSQL_BASE);
$sql = 'CREATE TABLE IF NOT EXISTS blog'.
       ' (login VARCHAR(64)'.
        ',message TEXT'.
        ',dateheure DATETIME)';
$mysql->query($sql);

$sql = 'INSERT INTO blog (login, message, dateheure)'.
       ' VALUES(\'phpfacile\', \'Tuto MySQL\', NOW())';
$mysql->query($sql);

$mysql->close();
?>