extract variables mysqli,prepare

extract variables mysqli,prepare

I'm trying to update my old script code to new mysqli with prepared
statement and I'm unable to extract variables.
Here is what I tried...
$settings = $mysqli->prepare("SELECT name, setting from settings where
visible = ?");
$settings->bind_param('i', $visible);
$visible = 0;
$settings->execute();
$settings->store_result();
$settings->bind_result($name, $setting);
while ($settings->fetch()) {
$showvar = array($name => $setting);
}
extract($showvar);
$settings->close();
I'm not receiving any error, but it doesn't work. Can anyone help me? Ivan.