title: I'm trying to create a table on my database using PHP so far i have managed to create a database using PHP but but fail to create table/tables
body: <pre><code>&lt;?PHP
  
      try{
          $handler = new PDO($servername, $username, $password);
          $handler-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
          $sql = "CREATE TABLE user_details ( 
              id INT NOT NULL AUTO_INCREMENT,
              email VARCHAR(30) NOT NULL,
              fullname VARCHAR(30) NOT NULL,
              username VARCHAR(30) NOT NULL,
              password VARCHAR(30)  NOT NULL,
              gender ENUM('male','female','other','')  NOT NULL , PRIMARY KEY (id)) 
              ENGINE = InnoDB
              )";
          echo "Sucessfullll";
          $handler-&gt;exc($sql);
      } catch (PDOException $msg){
          echo $msg-&gt;getMessage();
          die();
      }
  ?&gt;
  </code></pre>