Core Xii Core Xii - 4 months ago 21
MySQL Question

Get number of rows matched by UPDATE query with PHP mysqli

The older mysql extension has the

connection flag, but I couldn't find any equivalent for mysqli.

I have an
query and want to know how many rows its
clause matched, not how many were actually changed (as indicated by
mysqli -> affected_rows

The only way I've figured out so far is to parse
mysqli -> info
(which looks something like
Rows matched: 40 Changed: 40 Warnings: 0
) with a regex. But that seems hacky.

Answer Source

it's in the options of mysqli_real_connect.

Also introduced in PDO::MySQL in PHP 5.3.