Code has been added to clipboard!

Creating MySQL Tables for PDO Users

Example 
<?php
  $host = 'host';
  $user = 'user';
  $pass = 'pass';
  $db =  'db';
  try {
    $conn = new PDO("mysql:host=$host;dbname=$db", $user, $pass);    
    // set the PDO error mode to exception    
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    
    // sql to create table   
    $sql = "CREATE TABLE users ( user_id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(40) NOT NULL, password VARCHAR(40) NOT NULL, email VARCHAR(60), register_date TIMESTAMP )";
    // use exec() because no results are returned
    $conn->exec($sql);
    echo "users table created successfully";
  } catch (PDOException $e) {
    echo $sql . "<br>" . $e->getMessage();
  }
  $conn = null;  
?>
Related article