$stmt = $mysqli->prepare('SELECT name, email FROM users WHERE name LIKE ?');

$like = 'k%';
$stmt->bind_param('s', $like);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($name, $email);

while($stmt->fetch()) {
echo $name;
echo $email;
}