使用pdo连接mysql数据库

使用pdo连接mysql数据库

1、简单连接mysql数据库

<?php
	$dbname = 'testdb';
	$host = '127.0.0.1';
	$dsn = "mysql:dbname={$dbname};host={$host}";
	$user = 'dbuser';
	$password = 'dbpass';
	
	try {
	    $dbh = new PDO($dsn, $user, $password);
	} catch (PDOException $e) {
	    echo 'Connection failed: ' . $e->getMessage();
	}

2、pdo单例模式连接数据库

<?php
   class PdoExt extends PDO {
       static protected $_instance;
       protected function __contruct($dsn, $user, $password) {
           return parent::__construct($dsn, $user, $password);
       }
       
       static public function getInstance($dsn, $user, $password) {
           if (!isset(self::$_instance)) {
               self::$_instance = new self($dsn, $user, $password);
           }
           return self::$instance;
       }
   }
   
   $host = '127.0.0.1';
   $dsn = "mysql:host={$host}";
   $username = "root";
   $password = "root";
   // 连接数据库
   $pdo = PdoExt::getInstance($dsn, $username, $password);
   // 设置sql语句
   $sql = 'SELECT user,host FROM mysql.user WHERE user = :user';
   $statement = $pdo->prepare($sql);
   // 给:user绑定值
   $statement->bindParam(':user', $username);
   // 执行查询
   $statement->execute();
   // 取结果中2条数据
   $users = $statement->fetchAll(2);
   print_r($users);