<?php

$sqlCreate = "CREATE TABLE `mytest` (
              `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
              `name` VARCHAR(255) NOT NULL,
              `a1` VARCHAR(255) NOT NULL,
              `a2` VARCHAR(255) NOT NULL,
              `a3` VARCHAR(255) NOT NULL,
              `a4` VARCHAR(255) NOT NULL,
              `a5` VARCHAR(255) NOT NULL,
              `a6` VARCHAR(255) NOT NULL,
              `a7` VARCHAR(255) NOT NULL,
              `a8` VARCHAR(255) NOT NULL,
              `a9` VARCHAR(255) NOT NULL,
              PRIMARY KEY (`id`) )";

$sqlDrop = "DROP TABLE `mytest`";

$sqlInsert = "INSERT INTO `mytest` (`name`,`a1`,`a2`,`a3`,`a4`,`a5`,`a6`,`a7`,`a8`,`a9`)
              VALUES ('a','b','c','d','e','f','g','h','i','j')";

$sqlUpdate = "UPDATE `mytest` SET `name` = 'u'";

$sqlSelect = "SELECT * FROM `mytest`";

$sqlDelete = "DELETE FROM `mytest` WHERE `name` = 'u'";

$engine = 'mysql';
$host = '127.0.0.1';
$user = 'root';
$password = '';
$database = 'mydatabase';

// CONNECTION

$time_start = microtime(true);

$bdd = new PDO($engine . ':host=' . $host . ';port=3306;dbname=' . $database . ';charset=UTF8;',$user,$password, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));

echo 'CONNECTION BDD : ' . (microtime(true) - $time_start) . '<br />' . PHP_EOL;

// FIN CONNECTION

// CREATE TABLE

$time_start = microtime(true);

$bdd->exec($sqlCreate);

echo 'CREATE TABLE BDD : ' . (microtime(true) - $time_start) . '<br />' . PHP_EOL;

// FIN CREATE TABLE

// 20 INSERT

$time_start = microtime(true);

for($i = 0; $i < 20; $i++) {
  $bdd->exec($sqlInsert);
}

echo 'INSERT : ' . (microtime(true) - $time_start) . '<br />' . PHP_EOL;

// FIN 20 INSERT

// UPDATE

$time_start = microtime(true);

$bdd->exec($sqlUpdate);

echo 'UPDATE : ' . (microtime(true) - $time_start) . '<br />' . PHP_EOL;

// FIN UPDATE

// SELECT

$time_start = microtime(true);

$bdd->exec($sqlSelect);

echo 'SELECT : ' . (microtime(true) - $time_start) . '<br />' . PHP_EOL;

// FIN SELECT

// DELETE

$time_start = microtime(true);

$bdd->exec($sqlDelete);

echo 'DELETE : ' . (microtime(true) - $time_start) . '<br />' . PHP_EOL;

// FIN DELETE

// DROP TABLE

$time_start = microtime(true);

$bdd->exec($sqlDrop);

echo 'DROP : ' . (microtime(true) - $time_start) . '<br />' . PHP_EOL;

// DROP TABLE