<?php

//連庫

require_once('config.php');

try{

//$pdo=new PDO(":/Applications/MAMP/tmp/mysql/mysql.sock;dbname=article","xrg","happy1227");

$pdo=new PDO('mysql:host=localhost;port:8889;dbname=article','xrg','happy1227');

echo 'success'.'<br/>';

var_dump($pdo);

$state=$pdo->query('SELECT * from article');

foreach($state as $row) {

? ? ? ? print_r($row);

? ? ? }

? ? ? ? /* ?刪除 article 數據表中滿足條件的所有行 */

//$count = $pdo->exec("DELETE FROM article WHERE title = 'book'");

/* 返回被刪除的行數 */

//print("Deleted $count rows.\n");

? ? }catch(PDOException $e){

echo "connection failed:".$e->getMessage();

}

?>

頁面顯示

success
/Applications/MAMP/htdocs/article/connect_pdo.php:8:

object(PDO)[1]