blog 2015-01-31 15 阅读

pdo连接mysql

小泥巴小泥吧科技 2015-01-31


/**
 * Created by PhpStorm.
 * User: xiaoniba
 * Date: 15/1/30
 * Time: 下午9:42
 * 用pdo链接mysql数据库
 */

$host = "localhost";
$user = "root";
$password = "";
$db = "test";

try {
    $dbh = new PDO("mysql:host=localhost;dbname={$db};charset=utf8",$user,$password);

    foreach($dbh->query('SELECT * FROM user ') as $row){
        print_r($row);
    }

} catch (PDOException $e) {
    print "Error! :" . $e->getMessage() . "
";
}