推荐：《php视频教程》
pdo类常用方法:
exec()
query()
lastinsertid()
<?php$servername = "localhost";$username = "root";$password = "133nubia022";$dbname='myweb';$pdo= new pdo("mysql:host=$servername;dbname=$dbname", $username, $password);$pdo->exec('set names utf8');$pdo->setattribute(pdo::attr_default_fetch_mode,pdo::fetch_both);$sql="insert into user(username,age) values('user123','55')";if($pdo->exec($sql)){ $lastid=$pdo->lastinsertid(); echo "id为{$lastid}的数据插入成功！";}?>
• setattribute()
设置获取模式属性
<?php$servername = "localhost";$username = "root";$password = "133nubia022";$dbname='myweb'; $pdo= new pdo("mysql:host=$servername;dbname=$dbname", $username, $password);$pdo->exec('set names utf8');$pdo->setattribute(pdo::attr_default_fetch_mode,pdo::fetch_assoc);$sql="select * from user";$smt=$pdo->query($sql);$rows=$smt->fetchall();echo '<pre>';print_r($rows);echo '</pre>';?>
***
获取索引数组
<?php$servername = "localhost";$username = "root";$password = "133nubia022";$dbname='myweb';$pdo= new pdo("mysql:host=$servername;dbname=$dbname", $username, $password);$pdo->exec('set names utf8');$pdo->setattribute(pdo::attr_default_fetch_mode,pdo::fetch_num);$sql="select * from user";$smt=$pdo->query($sql);$rows=$smt->fetchall();echo '<pre>';print_r($rows);echo '</pre>';?>
获取混合数组
<?php$servername = "localhost";$username = "root";$password = "133nubia022";$dbname='myweb';$pdo= new pdo("mysql:host=$servername;dbname=$dbname", $username, $password);$pdo->exec('set names utf8');$pdo->setattribute(pdo::attr_default_fetch_mode,pdo::fetch_both);$sql="select * from user";$smt=$pdo->query($sql);$rows=$smt->fetchall();echo '<pre>';print_r($rows);echo '</pre>';?>
以上就是php pdo 类 方法有哪些的详细内容。