php regex preg wont match

Question

PHP REGEX

// Search Field:
$e = "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'KM0403580-70' for key 'PRIMARY'"

// Code:
$errorRegex = ereg("\:.([0-9]+)[a-zA-Z\s]+'([A-Z]*)'$", $e, $moError);
echo $moError[2] . "  " . $moError[1];

Trying to get:

1062
KM0403580-70

Any idea's what I'm doing wrong? I've been trying to find out for 4 hours now haha

ereg is obsolete for a while now, please use preg_match instead. — Toto
– Toto, Commented Jul 17, 2016 at 10:41

le3th4x0rbot · Accepted Answer · 2016-07-16 23:07:45Z

1

This is probably the regex you are trying to write, although it will probably match a lot of things besides just your data...

^.*: ([0-9]+).* '([A-Z0-9-]+)'.*$

Something like this would be much safer in that it would only find id codes from your specific type of error:

^SQLSTATE\[[0-9]+\]: Integrity constraint violation: ([0-9]+) Duplicate entry '([A-Z0-9-]+)' for key 'PRIMARY'$

edited Jul 16, 2016 at 23:07

answered Jul 16, 2016 at 23:01

le3th4x0rbot

2,46926 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

php regex preg wont match

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related