PHP PDO

(ｔｒｙ｛｝ｃａｔｃｈ（ｐｄｏｅｘｃｅｐｔｉｏｎ　＄ｅ）｛ｄｉｅ（＄ｅ－＞ｇｅｔｍｅｓｓａｇｅ（））；｝)

try{}catch(){}

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

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

(＄ｕｓｅｒ＝’ｕｓｅｒｎａｍｅ’；)

$user='username';

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

$password='';

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

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

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

$dbh->setAttribute(PDO::ATTR_ERRMODE

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

$dbh->setAttribute(PDO::ATTR_ERRMODE

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

$pdo->setAttribute(PDO::ATTR_EMULATE

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

$sql='SELECT name FROM where;

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

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

(＄ｃｏｄｅ＝１；)

$code=1;

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

$stmt->bindvalue();

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

$stmt->execute();

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

$stmt->fetchall(PDO::FETCH_ASSOC);

(ｆｏｒｅａｃｈ（＄ｕｓｅｒｓ　ａｓ　＄ｕｓｅｒ）｛ｐｒｉｎｔ＿ｒ（＄ｕｓｅｒ）；｝)

foreach($users as $user){}

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

$dbh=null;