Prepared statements

.

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new \mysqli("localhost", "test", "test", "test");

/* Prepared statement, stage 1: prepare */
$stmt = $mysqli->prepare("SELECT * FROM auth_logins WHERE ip_address = ?");

/* Prepared statement, stage 2: bind and execute */
$ip = '192.168.10.3';
$stmt->bind_param("s", $ip);

$stmt->execute();

var_dump($stmt->get_result()->fetch_array());
// Or
var_dump($stmt->get_result()->fetch_all());