$dbUser = 'testUser';
$dbPassword = 'testPassword';
$dbCharset='utf-8';
$dbName = 'testDb';
$dbHost = 'localhost';

$dsn = sprintf("mysql:host=%s;dbname=%s;charset=%s",$dbHost,$dbName,$dbCharset);
$pdo = new PDO($dsn,$dbUser,$dbPassword);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);


//Test insert
$sql = "INSERT INTO table(field1,field2) VALUES('value1','value2')";
$pdo->exec($sql);

//Test insert multiple with prepared statement
$sql = "INSERT INTO table(field1,field2) VALUES(:value1,:value2)";
$statement = $pdo->prepare($sql);

$rows = [
[':value1' =>'value1',
':value2' => 'value2'
],
[
':value1' => 'value3',
':value2' => 'value4'
]
];

foreach($rows as $row){
$statement->execute($row);
}

//Test select
$sql = "SELECT * FROM table WHERE value1 = :value1";

$statement = $pdo->prepare($sql);
$statement->execute([':value1' => 'value3']);
$data = $statement->fetchAll();
var_dump($data);