Mysql匹配保存的正则表达式的url

Question

I have a table in which I am saving the regex expression that later I used to detect the urls.

Now I want if I enter url in search field then in the database query will fetch all the records(regex expression) that catch the url:

for example in the db I have saved this expression

.*\/[a-z0-9]{0,}\.gif\?abc=[0-9]&rnd=[0-9]{1,}.*

Now If I search this url

cnzz.mmstat.com/9.gif?abc=1&rnd=162146281

then it should automatically fetch the record where regex detect this url.

I am using MySql and Core PHP

Answer 1

You don't have any capture groups in your regex. Use this:

.*\/[a-z0-9]{0,}\.gif\?abc=[0-9]&rnd=([0-9]{1,}.*)

So this gives the last set of numbers as a capture group. You can test it at Regex101.

Now using preg_match() you can get the last id of the URL and that can be used to make your calculations.

Sample Code

<?php
preg_match('.*\/[a-z0-9]{0,}\.gif\?abc=[0-9]&rnd=([0-9]{1,}.*)',
    "cnzz.mmstat.com/9.gif?abc=1&rnd=162146281", $matches);
$id = $matches[0];

echo "The id is: {$matches[0]}
";
?>