Inserting data to a database using Faker and PDO

gistfile1.aw

<?php
$pdo = new PDO('mysql:host=hostname;dbname=defaultDbName', 'username', 'p@55w0rd');
$sql = 'INSERT INTO author (first_name, last_name, date_of_birth, email) VALUES (?, ?, ?, ?)';
$stmt = $pdo->prepare($sql);
$faker = \Faker\Factory::create();
$insertedPKs = array();
for ($i=0; $i < 100; $i++) {
  $stmt->bindValue(1, $faker->firstName, PDO::PARAM_STR);
  $stmt->bindValue(2, $faker->lastName, PDO::PARAM_STR);
  $stmt->bindValue(1, $faker->date, PDO::PARAM_STR);
  $stmt->bindValue(1, $faker->email, PDO::PARAM_STR);
  $stmt->execute();
  $insertedPKs[]= $pdo->lastInsertId();
}