<?php

define('DB_NAME', 'test');
define('DB_USER', 'root');
define('DB_PASSWORD', '');
define('DB_HOST', '127.0.0.1');


// Insert by default sql query

try {
    $conn = new PDO("mysql:dbname=" . DB_NAME . ";host=" . DB_HOST, DB_USER, DB_PASSWORD);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->exec("SET CHARACTER SET utf8");
    $sql = "INSERT INTO member (user, email) VALUES ('team', 'teampat@gmail.com')";
    $stm = $conn->prepare($sql);
    $stm->execute($data);
    $count = $stm->rowCount();
    echo "Inserted $count rows." . PHP_EOL;
} catch (PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}


// Insert by key value

$data = [
      'user' => 'team',
      'email' => 'teampat@gmail.com'
];

try {
    $conn = new PDO("mysql:dbname=" . DB_NAME . ";host=" . DB_HOST, DB_USER, DB_PASSWORD);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->exec("SET CHARACTER SET utf8");
    $sql = "INSERT INTO member (user, email) values (:user, :email)";
    $stm = $conn->prepare($sql);
    $stm->execute($data);
    $count = $stm->rowCount();
    echo "Inserted $count rows." . PHP_EOL;
} catch (PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}


// Insert by value

$data = ['team','teampat@gmail.com'];
try {
    $conn = new PDO("mysql:dbname=" . DB_NAME . ";host=" . DB_HOST, DB_USER, DB_PASSWORD);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->exec("SET CHARACTER SET utf8");
    $sql = "INSERT INTO member (user, email) values (?, ?)";
    $stm = $conn->prepare($sql);
    $stm->execute($data);
    $count = $stm->rowCount();
    echo "Inserted $count rows." . PHP_EOL;
} catch (PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}


// Bind params insert

try {
    $conn = new PDO("mysql:dbname=" . DB_NAME . ";host=" . DB_HOST, DB_USER, DB_PASSWORD);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->exec("SET CHARACTER SET utf8");

    $sql = "INSERT INTO member (user, email) VALUES (:user, :email)";
    $stm = $conn->prepare($sql);
    $stm->bindParam(':user', $user);
    $stm->bindParam(':email', $mail);

    // insert one row
    $user = 'team';
    $email = 'teampat@gmail.com';
    $stm->execute();
    $count = $stm->rowCount();
    echo "Inserted $count rows." . PHP_EOL;

    // insert another row
    $user = 'teamteam';
    $email = 'teamteam@team.com';
    $stm->execute();
    $count = $stm->rowCount();
    echo "Inserted $count rows." . PHP_EOL;

} catch (PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}