Anyone has an example of mysql query using OOP?

Hello,

anyone has an example of mysql query using OOP?

example..


$query="select * from users where user_id='$userid'";
$result=mysql_query($query);
$row=mysql_fetch_array($result);

echo $row[name];



how to convert that into oop approach?

thanks...

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

if (mysqli_connect_errno())
{
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

$query = "SELECT * FROM users WHERE user_id='$userid'";

if ($result = $mysqli->query($query))
{
while ($row = $result->fetch_assoc())
{
echo $row['name'] ."<br />";
}
$result->close();
}

$mysqli->close();