pdo连接mysql
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
<?php /** * 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() . " "; } ?> |