How to get query result using recursive function?

Question

I have a phonecode 1234 and i am checking this phonecode in my db to get its respective's country's name if matched i am returning country's name anf if not matched i am removing the last digit from phone code example 123 and checking again if matched i am returning the country name otherwise removing the last digit again example 12 until i reach 1.

function rFunc($val)
{
    if (strlen($val) != 0) {
        $sql = mysql_query("SELECT name from country Where phonecode='$val'LIMIT 1");
        if (mysql_num_rows($sql) > 0) {
            $res  = mysql_fetch_assoc($sql);
            $name = $res['name'];
            return $name;
        } else {
            rFunc(substr($val, 0, -1));
        }
    } else {
        return "N/A";
    }
}
$value = "1234";
$na    = rFunc($value);

You need to put a `return` in front of your recursing `rFunc()` call, otherwise its return value will get lost. — KIKO Software, May 09 '19 at 06:42
Could you not simply use a `regexp` operator within the sql - like `select name from country where phonecode regexp 1234`?? — Professor Abronsius, May 09 '19 at 06:44
@KIKOSoftware Unformatted code is so much harder to read... Unreadable code is harder to troubleshoot... ;-) — Qirel, May 09 '19 at 06:45
@RamRaider: Isn't `phonecode regexp 1234` equivalent to `phonecode LIKE '%1234%'`? That's not what is wanted here. I'm not that good with regular expressions. — KIKO Software, May 09 '19 at 06:54
it is similar yes - just thought it might be a quicker approach — Professor Abronsius, May 09 '19 at 06:59

score 1 · Accepted Answer · answered May 09 '19 at 06:42

1

You just need to add return in your recursive function.

return rFunc(substr($val,0,-1));

answered May 09 '19 at 06:42

Jaymin

1,643
1
18
39

How to get query result using recursive function?

1 Answers1