$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);
