Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$mysqli->query("create table test (i int)");
$mysqli->query("insert into test values(1),(2)");
$mysqli->query("update test set i=2");
$pattern = '~Rows matched: (?<matched>\d+) Changed: (?<changed>\d+) Warnings: (?<warnings>\d+)~';
preg_match($pattern, $mysqli->info, $matches);
$matches = array_filter($matches, "is_string", ARRAY_FILTER_USE_KEY);
var_dump($matches);