用PHP将MySQLi转换为PDO？

Question

I apologize if I am not posting this in the right place. I wanted to know if I converted this correctly. I am trying to convert all my code in PDO.

Here is the mySQLi:

    $stmt->execute();
    $stmt->bind_result($timestamp);
    $stmt->fetch();
    $stmt->close();
    return ($timestamp);

I changed it to:

$stmt->execute();
$timestamp = $stmt->fetch();
return ($timestamp);

Can someone tell me if I did this right?

Answer 1

Assuming $stmt is your connection parameter...then

$query = $stmt->prepare("SELECT * FROM table");
$query->execute();
$timestamp = $query->fetchAll();

Try it with an example you will get to know...

Or

$query = $stmt->query("select * from table");
$timestamp = $query->fetch();