php - 在 PhP 中从 MySql 检索和显示数据

Question

我遇到了一个问题:

Catchable fatal error: Object of class PDOStatement could not be converted to string in F:\University\xampp\htdocs\database.php on line 36

连接到数据库成功，只是我无法从数据库中检索数据并将其显示在页面上。

这是我的数据库:

http://screenshot.sh/m1Ol9a8Fp2j3a

这是我的代码

    <?php
$conn = new PDO(
    'mysql:host=localhost;dbname=u1358595', 
    'root'
    );
try{
       $conn = new PDO('mysql:host=localhost;dbname=u1358595', 'root');
    echo "Connected successfully"; 
}

catch (PDOException $exception) 
{
    echo "Oh no, there was a problem" . $exception->getMessage();
}
$query = "SELECT * FROM hotel";
$results = $conn->query($query, PDO::FETCH_OBJ);
$hotel = $results->fetch();
echo "<p>".$results."</p>";
$conn=NULL;
?>

Answer 1

您正在尝试回显一个不起作用的 PDO 对象。您正在将数据传递给 $hotel 并显示您将使用酒店的数据。

<?php
$conn = new PDO(
    'mysql:host=localhost;dbname=u1358595', 
    'root'
    );
try{
       $conn = new PDO('mysql:host=localhost;dbname=u1358595', 'root');
    echo "Connected successfully"; 
}

catch (PDOException $exception) 
{
    echo "Oh no, there was a problem" . $exception->getMessage();
}
$query = "SELECT * FROM hotel";
$results = $conn->query($query);
$hotel = $results->fetch();

echo '<pre>';
var_dump($hotel);
echo '</pre>';

$conn=NULL;
?>