PHP PDO

背景
投稿者投稿者パンサーfkいいね0お気に入り登録
プレイ回数2603難易度(4.4) 536打 長文
タグPHP PDO mysql html
自分練習用

関連タイピング

問題文

ふりがな非表示 ふりがな表示

(try{}catch(pdoexception $e){die($e->getmessage());})

try{}catch(){}

($dsn=’mysql:host=localhost;dbname=users;charset=utf8’;)

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

($user=’username’;)

$user='username';

($pass=’password’;)

$password='';

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

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

($dbh->setattribute(pdo::attr_errmode,)

$dbh->setAttribute(PDO::ATTR_ERRMODE

(pdo::errmode_exception);)

$dbh->setAttribute(PDO::ATTR_ERRMODE

($dbh->setattribute(pdo::attr_emulate_prepares,false);)

$pdo->setAttribute(PDO::ATTR_EMULATE

($sql=’select name from users where code=?’;)

$sql='SELECT name FROM WHERE;

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

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

($code=1;)

$code=1;

($stmt->bindvalue(1,$code,pdo::param_int);)

$stmt->bindValue();

($stmt->execute();)

$stmt->execute();

($count=$stmt->rowcount();)

$stmt->rowCount();

($users=$stmt->fetchall(pdo::fetch_assoc);)

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

(foreach($users as $user){print_r($user);})

foreach($users as $user){}

($dbh=null;)

$dbh=null;