<?php
try{
$pdo = new PDO("mysql:127.0.0.1:3306;dbname='blogs';charset=utf8mb4",'root','');
echo "pdo連接成功"."";
}catch(Exception $e){
echo $e->getMessage();
}
$str = $pdo->prepare("SELECT * from user");
foreach ($str as $item){
echo $item;
}
shows that the connection is successful, but the result is that the MySQL statement
is directly displayed.
4
0
0
The current $str is a sql statement object, also called a PDOStatement object, which is a preprocessing object. It has a "queryString" attribute, and the value is your current SQL statement
pdo connection successful object(PDOStatement)#2 (1) { ["queryString"]=> string(18) "SELECT * from user" } This is the result of the operation, please give me the answer
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
