$db->prepare("SELECT id FROM user WHERE username = ? AND password = ?"); $db->bind_param('ss', $_GET['username'], $_GET['password']); $db->execute(); $db->store_result(); $result_1 = $db->num_rows; echo $result_1;