PHP PDO Database demo
https://github.com/migliori/php-pdo-db-class

--DEBUG NUMROWS TIMER--

0.000184 ms

--DEBUG NUMROWS SQL--

SELECT COUNT('*') AS "row_count" FROM customers WHERE zip_code IS NOT NULL AND id > :a_id AND last_name LIKE :a_last_name

--DEBUG NUMROWS PARAMS--

Array
(
    [a_id] => 10
    [a_last_name] => %Ma%
)

--DEBUG NUMROWS DUMP--

SQL: [121] SELECT COUNT('*') AS "row_count" FROM customers WHERE zip_code IS NOT NULL AND id > :a_id AND last_name LIKE :a_last_name
Sent SQL: [112] SELECT COUNT('*') AS "row_count" FROM customers WHERE zip_code IS NOT NULL AND id > 10 AND last_name LIKE '%Ma%'
Params:  2
Key: Name: [5] :a_id
paramno=-1
name=[5] ":a_id"
is_param=1
param_type=1
Key: Name: [12] :a_last_name
paramno=-1
name=[12] ":a_last_name"
is_param=1
param_type=2

--DEBUG NUMROWS END--

--DEBUG QUERY TIMER--

0.000206 ms

--DEBUG QUERY SQL--

SELECT id, first_name, last_name FROM customers WHERE zip_code IS NOT NULL AND id > 10 AND last_name LIKE '%Ma%' ORDER BY id DESC

--DEBUG QUERY PARAMS--

Array
(
    [a_id] => 10
    [a_last_name] => %Ma%
)

--DEBUG QUERY DUMP--

SQL: [138] SELECT id, first_name, last_name FROM customers WHERE zip_code IS NOT NULL AND id > :a_id AND last_name LIKE :a_last_name ORDER BY id DESC
Sent SQL: [129] SELECT id, first_name, last_name FROM customers WHERE zip_code IS NOT NULL AND id > 10 AND last_name LIKE '%Ma%' ORDER BY id DESC
Params:  2
Key: Name: [5] :a_id
paramno=-1
name=[5] ":a_id"
is_param=1
param_type=1
Key: Name: [12] :a_last_name
paramno=-1
name=[12] ":a_last_name"
is_param=1
param_type=2

--DEBUG QUERY ROW COUNT--

4

--DEBUG QUERY RETURNED RESULTS--

1

--DEBUG QUERY END--