abstract：$pdo = new PDO('mysql:dbname=php','root','root');$sql = "SELECT name,email FROM user WHERE user_id < :user_id";$stmt = $pdo->prepare($sql);$user_id = 5;$stmt-&g
$pdo = new PDO('mysql:dbname=php','root','root');
$sql = "SELECT name,email FROM user WHERE user_id < :user_id";
$stmt = $pdo->prepare($sql);
$user_id = 5;
$stmt->bindParam(':user_id',$user_id,PDO::PARAM_INT);
stmt->setFetchMode(PDO::FETCH_ASSOC);
$row = $stmt->fetch();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
var_export($row); //字符串方式输出
echo '<br>';
fetch()会将记录指针自动下移
$row = $stmt->fetch(PDO::FETCH_ASSOC);
var_export($row); //字符串方式输出
echo '<hr>';
while($row=$stmt->fetch(PDO::FETCH_ASSOC)) {
var_export($row); //字符串方式输出
echo '<br>';
}
Correcting teacher：天蓬老师Correction time：2019-02-25 09:04:58
Teacher's summary：不仅仅是pdo,其它方式操作数据库都是以下三步: 1.连接,2.操作,3,关闭, 你的这个操作过程,其实还有很大的简化空间, 可以试试看