这两个代码有什么区别

Question

I coded these two blocks of code, but they seem to do the same. I don't understand when you should use each one of these.

$query= $db->query("SELECT * FROM forum_table WHERE forum_id = '$id'");

and

$sql="SELECT * FROM forum_table WHERE forum_id = '$id'";
if ($query = $db->prepare($sql))
$query->execute();

I don't get how those differ

Answer 1

For a start both of those statements are exactly the same so there is literally no difference.

There is a hint at something very different going on with the second block.

prepared statements

As for when to use one over the other.. always use prepared statements