changing getShot to pdo connection