RegEx for capturing digits in a string (PHP)

Question

I am pulling in job numbers and matching them to data in a mysql database, then retrieving the matching data.

If my job number is 123456 then it matches up fine and I get results. Some are 123-456 some are 12-text, while some are 12-text-345

$variable = $variable

I tried matching the variable but that's what's not effective. I tried changing the SQL within PHPMyAdmin and it doesn't even work smoothly there. I googled and think I should be using RegExp. I tried. I can add a slash and make it work on individual items, however, I do not know where the hyphen will be amidst a massive array. It might be the third or fourth character. I tried pregmatch but I don't think I know what I'm doing with that. I'm looking for a few lines of code to analyze a PHP variable and both detect and escape any meta characters if there are any. A tutorial link would be fine too, I appreciate any assistance

Posting your attempted code will benefit you getting answers quicker. — Andrius Naruševičius, Jun 02 '19 at 15:43
So are you saying that the job number entered isn't in the same format as the database or the other way round? — Nigel Ren, Jun 02 '19 at 16:04

score 0 · Accepted Answer · answered Jun 02 '19 at 15:46

0

Here, if we wish to only get the numbers, on way would be to collect our digits in a capturing group and then collect everything else, then replace it with just $1, with an expression similar to:

(\d+)|\D+

Test

$re = '/(\d+)|\D+/m';
$str = 'text-12-text-345';
$subst = '$1';

$result = preg_replace($re, $subst, $str);

echo $result;

Output

DEMO

answered Jun 02 '19 at 15:46

Emma

27,428
11
44
69

3

Why not just simply replace all the non digits with empty string, i don't think there any need of capturing group – Code Maniac Jun 02 '19 at 16:04
1

Thanks Emma, I appreciate it – Brian Moore Jun 02 '19 at 21:58

RegEx for capturing digits in a string (PHP)

1 Answers1

Test

Output

DEMO