Upgrading database queries to MYSQLi or PDO

Are there direct command replacements for the following, or is there more to it than that?
$st1 = "SELECT * from `members` WHERE (memberid ='$usernum')";
$r1 = […]

See original post by invalid@example.com (pmf123)