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,其它方式操作數(shù)據(jù)庫都是以下三步: 1.連接,2.操作,3,關(guān)閉, 你的這個操作過程,其實還有很大的簡化空間, 可以試試看