Untitled

<!DOCTYPE HTML>
<html lang="en">
<head>
    <meta charset="utf-8">
</head>

<body>
    <?php
    $servername = "localhost";

   try{
        $username = "mgoldin2";
        $password = "ninjamime#1";
        $conn = new PDO("mysql: host=$servername; dbname=mgoldin2", trim($username), trim($password));
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $user = 'user';
        $game = 'game';
        $count = 'count';
        $date = 'date';
        $state = 'state';
        $city = 'city';


       $sql = "insert into playgroups values('$user', '$game', '$count', '$date', '$state', '$city');";

//        echo "Connection Successful<br>";

//        $sql = "drop table if exists playgroup;";
//        echo "Table deleted";
//        if($sql) $conn->exec($sql);
/*
        $sql = "create table playgroups(user varchar(12), game varchar(20), count varchar(2), date varchar(10), state varchar(2), city varchar(20));";
        //use exec because no result returned
        echo "Table playgroups created successfully<br>";
*/
      $conn->exec($sql);
       $conn = null;
        }
    catch(PDOException $e){
        echo $sql . "<br>" . $e->getMessage();
    }

    ?>

</body>
</html>