[PDO]PHP 단순조회

private $db;
private $stmt;

public function connect() {
  // 데이터베이스 연결
  $id = "";
  $dsn = "mysql:host=localhost;port=3306;dbname=".$id.";charset=utf8";

  try {
    $this->db = new PDO($dsn, $id, "", array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
    $this->db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
    $this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  } catch(PDOException $e) {
    echo $e->getMessage();
  }
}



// 단순조회
public function select($query) {
  $this->connect();

  $this->stmt = $this->db->prepare($query);
  $this->stmt->execute();

  $this->db->null;

  $this->stmt->setFetchMode(PDO::FETCH_ASSOC );

  $this->db = null;

  return $this->stmt->fetch();
}

// 단순조회
public function select2($query, $args) {
  $this->connect();

  $this->stmt = $this->db->prepare($query);
  $this->stmt->execute($args);

  $this->db->null;

  $this->stmt->setFetchMode(PDO::FETCH_ASSOC );

  $this->db = null;

  return $this->stmt->fetch();
}

select()