$sql = "insert into admin (userName, password) VALUES (:userName, :password)"; $sth = $dbh->prepare($sql); $sth->execute($data); $db = null; } catch (PDOException $e) { echo "I'm sorry, Dave. I'm afraid I can't do that."; file_put_contents('PDOErrors.txt', $e->getMessage(), FILE_APPEND); } } } $team1 = array('name1' => 'Mirentxu', 'surname1' => 'Vera', 'phone1' => '986304040', 'email1' => '*****@*****.**', 'name2' => 'Maria Jose', 'surname2' => 'Moure', 'phone2' => '986304050', 'email2' => '*****@*****.**', 'userName' => 'veraMoure', 'password' => 'vera'); $team2 = array('name1' => 'Xandra', 'surname1' => 'Lopez', 'phone1' => '986304060', 'email1' => '*****@*****.**', 'name2' => 'Paola', 'surname2' => 'Strasser', 'phone2' => '986304070', 'email2' => '*****@*****.**', 'userName' => 'lopezStrasser', 'password' => 'lopez'); $team3 = array('name1' => 'Loreto', 'surname1' => 'Ramos', 'phone1' => '986304080', 'email1' => '*****@*****.**', 'name2' => 'Carla', 'surname2' => 'Barciela', 'phone2' => '986305010', 'email2' => '*****@*****.**', 'userName' => 'ramosBarciela', 'password' => 'ramos'); $admin = array('userName' => 'admin', 'password' => 'admin123'); $league1 = array('name' => 'League A', 'status' => 'Active', 'year' => '2010'); $league2 = array('name' => 'League C', 'status' => 'Active', 'year' => '2011'); $league3 = array('name' => 'League B', 'status' => 'Inactive', 'year' => '2009'); $fixtures = new Fixtures(); $fixtures->dropTableTeam(); $fixtures->createTableTeam(); $fixtures->insertTeam($team1); $fixtures->insertTeam($team2); $fixtures->insertTeam($team3); $fixtures->dropTableAdmin(); $fixtures->createTableAdmin(); $fixtures->insertAdmin($admin); $fixtures->dropTableLeague(); $fixtures->createTableLeague(); $fixtures->insertLeague($league1); $fixtures->insertLeague($league2); $fixtures->insertLeague($league3);