PHP PDO

(ｔｒｙ｛)

try{

(＄ｄｓｎ＝’ｍｙｓｑｌ：ｄｂｎａｍｅ＝ｓｈｏｐ；ｈｏｓｔ＝ｌｏｃａｌｈｏｓｔ；ｃｈａｒｓｅｔ＝ｕｔｆ８’；)

$dsn='mysql:dbname=shop;host=localho

(＄ｕｓｅｒ＝’ｒｏｏｔ’；)

$user='root';

(＄ｐａｓｓｗｏｒｄ＝’’；)

$password='';

(＄ｄｂｈ＝ｎｅｗ　ｐｄｏ（＄ｄｓｎ，＄ｕｓｅｒ，＄ｐａｓｓｗｏｒｄ）；)

$dbh=new PDO($dsn,$user,$password);

(＄ｄｂｈ－＞ｓｅｔａｔｔｒｉｂｕｔｅ（ｐｄｏ：：ａｔｔｒ＿ｅｒｒｍｏｄｅ，)

$dbh->setAttribute(PDO::ATTR_ERRMODE

(ｐｄｏ：：ｅｒｒｍｏｄｅ＿ｅｘｃｅｐｔｉｏｎ）；)

$dbh->setAttribute(PDO::ATTR_ERRMODE

(＄ｐｄｏ－＞ｓｅｔａｔｔｒｉｂｕｔｅ（ｐｄｏ：：ａｔｔｒ＿ｅｍｕｌａｔｅ＿ｐｒｅｐａｒｅｓ，ｆａｌｓｅ）；)

$pdo->setAttribute(PDO::ATTR_EMULATE

(＄ｓｑｌ＝’ｓｅｌｅｃｔ　ｎａｍｅ　ｆｒｏｍ　ｓｔａｆｆ　ｗｈｅｒｅ　ｃｏｄｅ＝？’；)

$sql='SELECT name FROM mst_staff WHE

(＄ｓｔｍｔ＝＄ｄｂｈ－＞ｐｒｅｐａｒｅ（＄ｓｑｌ）；)

$stmt=$dbh->prepare($sql);

(＄ｓｔｍｔ－＞ｂｉｎｄｖａｌｕｅ（１，ｃｏｄｅ）；)

$stmt->bindparam?bindvalue?

(＄ｓｔｍｔ－＞ｅｘｅｃｕｔｅ（）；)

$stmt->execute();

(＄ｒｅｃ＝＄ｓｔｍｔ－＞ｆｅｔｃｈ（ｐｄｏ：：ｆｅｔｃｈ＿ａｓｓｏｃ）；)

$rec=$stmt->fetch(PDO::FETCH_ASSOC);

(＄ｄｂｈ＝ｎｕｌｌ；)

$dbh=null;

(｝)

}

(ｃａｔｃｈ（ｅｘｃｅｐｔｉｏｎ　＄ｅ）｛)

catch(Exception $e)

(ｅｘｉｔ（）；｝)

exit();}