regex101: PHP PDO debugDumpParams parse as sql.

SQL: the literal text SQL: (case sensitive)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\d+a digit, repeated at least once

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

Group sql(?<sql>.*)

.*any character, repeated any number of times

Sent SQL: the literal text Sent SQL: (case sensitive)

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\d+a digit, repeated at least once

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

Group send_sql(?<send_sql>.*)

.*any character, repeated any number of times

Params:the literal text Params: (case sensitive)

Global pattern flags

s modifier: single line. Allows a dot to match line terminators

Search reference

Regular Expression

SQL: \[\d+\] (?<sql>.*) Sent SQL: \[\d+\] (?<send_sql>.*) Params:

New

SQL: [126] INSERT INTO `tbl_ip_data` (`ip_start`, `ip_end`, `region_id`, `country_id`, `create_at`)
VALUES (:v0d, :v1d, :v2d, :v3d, :v4d) Sent SQL: [163] INSERT INTO `tbl_ip_data` (`ip_start`, `ip_end`, `region_id`, `country_id`, `create_at`)
 VALUES ('1900145563', '1900145563', '440118', 'CN', '2022-04-15 21:46:42') Params:  5 Key: Name: [4] :v0d paramno=-1 name=[4] ":v0d" is_param=1 param_type=2 Key: Name: [4] :v1d paramno=-1 name=[4] ":v1d" is_param=1 param_type=2 Key: Name: [4] :v2d paramno=-1 name=[4] ":v2d" is_param=1 param_type=2 Key: Name: [4] :v3d paramno=-1 name=[4] ":v3d" is_param=1 param_type=2 Key: Name: [4] :v4d paramno=-1 name=[4] ":v4d" is_param=1 param_type=2  [] []